When you enroll through our links, we may earn a small commission—at no extra cost to you. This helps keep our platform free and inspires us to add more value.

Productivity
SkillShare logo

Microsoft Excel Advanced Level (2016 / 2019 ) - Learn Excel Skills for Professionals and Corporates.

Unlock creativity with Skillshare! Learn acrylic painting, AI writing, graphic design, and photography.

     0 |
  • Reviews ( 0 )
Free
Microsoft Excel Advanced Level (2016 / 2019 ) - Learn Excel Skills for Professionals and Corporates.

Related Courses

This Course Includes

  • iconskillshare
  • icon0 (0 reviews )
  • icon3 hours 34 minutes
  • iconenglish
  • iconOnline - Self Paced
  • iconcourse
  • iconSkillShare

About Microsoft Excel Advanced Level (2016 / 2019 ) - Learn Excel Skills for Professionals and Corporates.

Lesson 1 Introduction

Lesson 2 Day and Time Function

Lesson 3 Database Functions in Excel

Lesson 4 Saving and Retrieving Data in Excel

Lesson 5 Conditional Formatting Highighting Cells

Lesson 6 Conditional Formatting Data Bars

Lesson 7 Conditional Formatting Icon Sets

Lesson 8 Conditional Formatting Color Scales

Lesson 9 Conditional Formatting Using Logical Functions

Introduction to Pivot Tables

Lesson 11 Formatting Pivot Tables

Lesson 12 Filters and Slicers

Lesson 13 GETPIVOTDATA

Lesson 14 Pivot Charts

Lesson 15 VLOOKUP and HLOOKUP

Lesson 16 Match and Index

Lesson 17 Data Validation

Lesson 18 Combo Charts

Lesson 19 Auditing a Worksheet in Excel

Lesson 20 What if Analysis

Lesson 21 Security and Password

Lesson 22 Recording Macro

What You Will Learn?

  • Of all the business and office tools available in the digital age, Microsoft Excel is the most-used spreadsheet program in the world. Excel is a critical and foundational tool for any successful professional, and you can’t afford not to master it. So this course was designed keeping in my mind that students have different needs in Excel based on their experience and knowledge level with Microsoft Excel. This online course has something for everyone. This is a 2 Part Course this one being the Part 2 and is focused on Advanced Excel. In this part of the series we shall learn the Advanced Tools and Techniques in Excel. .
  • In the Advanced course, we will prepare you to become a power user of Excel - this is your last step before specializing at a professional level. The topics we have prepared will challenge you as you learn how to use advanced formula techniques and sophisticated lookups, data validations, Pivot Tables, What if Analysis and Data security in Excel. .