Udemy

Platform

English

Language

Microsoft

Category

Grant Thornton MS Excel Certificate

Basic, Intermediate and Advance

Students

7.5 hours

Content

Jul 2021

Last Update
Regular Price

Topics


What you will learn

Participants will learn to how to simplify complex spreadsheets

Enhance spreadsheets with templates, charts, graphics, and excel formulas and streamline their operational work

Use advanced functions of MS Excel to improve productivity,

They will apply visual elements and advanced formulas to a worksheet to display data in various formats.

Participants will also learn how to automate common tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others


Description

Excel is more than a tool to make spreadsheets. It is a skill that can work wonders for all. Why we say all, is because Excel teaches how to simplify and organize your work in the most efficient manner. Having an organizational skill that maximizes your efficiency, who wouldn't want that?

For students, businessmen, practitioners, or to say people who deal with large amounts of data everyday and have to make sense out of those numbers, Excel is a must-have tool.

If you are a beginner to excel who knows how to put basic numbers into it, then after taking this course you will be able to unleash yours and Excel's true potential.

This course is designed keeping every kind of user in mind, it starts from the basics and then takes you through the intermediate and advanced stages of excel.


Objectives of Excel Online Training

  • Participants will learn to how to simplify complex spreadsheets

  • Enhance spreadsheets with templates, charts, graphics, and excel formulas and streamline their operational work

  • Use advanced functions of MS Excel to improve productivity,

  • They will apply visual elements and advanced formulas to a worksheet to display data in various formats.

  • Participants will also learn how to automate common tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others

Basic

  • Introduction to the Excel Interface

  • Performing calculations

  • Formatting

  • Images and Shapes

  • Printing


Intermediate

  • Charts

  • Working with Multiple Workbooks & Worksheets

  • Text & Date Functions

  • Named Ranges

  • Summarizing Data

  • Tables

  • Pivot table, Charts & Slicers

  • Data validation


Advanced

  • Conditional logic

  • Automating Lookups

  • Formula Auditing & Protection

  • Recording Macros

  • Spreadsheet design & Documentation

  • Advance Formula Techniques

  • Data Cleaning & Preparation

  • Financial Functions & Working with Dates

  • Advanced Lookup Functions

  • Building a Professional Dashboard

  • Power Query


Screenshots

Grant Thornton MS Excel Certificate
Grant Thornton MS Excel Certificate
Grant Thornton MS Excel Certificate
Grant Thornton MS Excel Certificate

Content

Basic Excel

Basic Excel

Basic Excel

3

5

6

7

8

9

10

11

12

13

14

15

16

17

Intermediate

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

Advanced

1

2

5

6

7

9

10

11

12

13

14

16


4131068

Udemy ID

6/18/2021

Course created date

7/24/2021

Course Indexed date
Bot
Course Submitted by