Excel Mastery

A course by Awesh Bhornya, Trainer

Most Popular

TO GET AN EXTRA 30% DISCOUNT CLICK THE LINK BELOW!!!

• Language-English

• Subtitles-No

• Use On Desktop,Tablet & Mobile

• Full Lifetime Access

• Certificate Of Completion

• 21 lessons (6 Hr. 13 Min. )

• Learn at Your Own Pace

What you'll learn

• Work comfortably with Microsoft Excel 2016 and many of its advanced features

• Be much quicker at carrying out regular tasks

• Use sophisticated functions that will improve the quality of your work

• Learn what is new in Excel 2016

• Become your team's go-to-guy when it comes to Excel

Course Content

• Introduction

• Fill handle, Flash Fill Nos. format

• Working with multiple sheet, freeze panes, split window

• Introduction to formulas (Basic & Advanced)

• Auto Sum Functions

• Logical Functions 1

• Logical Functions 2

• Lookup Functions 1

• Lookup functions 2

• Lookup Function 3

• Lookup functions 4

• Lookup functions 5

• Sorting and Filtering 1

• Sorting and Filtering 2

• Charts 1 Basic

• Charts 2 Advance Tree Map, sunburst Map

• Data Validation, Whole nos., list etc...

• Conditional formatting, Sales Data Analysis etc..

• Consolidation on function, SumIf/Ifs, Averageif/Ifs etc...

• Lookup functions-2 (a)

• Lookup functions-2 (b)