Master Microsoft Excel - A Comprehensive Excel Master Class

About Master Microsoft Excel - A Comprehensive Excel Master Class

This is the

Comprehensive Excel Course.

This course

covers everything there is to know about Microsoft Excel

. From the

fundamentals,

to the

most advanced features,

after taking this class you will be able to use Microsoft Excel at an expert level.

Beginners

can begin right at the beginning, then work their way through the course to achieve mastery.

Intermediate users

can join the course where needed to forward their skills.

Advanced users

can also drop into sections they need to achieve mastery. You can

learn Excel quickly

if it is taught correctly. Developed by a …

Best-selling Udemy author

Microsoft Certified Educator

Microsoft Office Specialist Expert

Tenured College Professor

Udemy Instructor Partner

… this course has been designed and perfected to make it easy for you to master Microsoft Excel. Here are highlights of what you will learn in this course:

Learn to

navigate

around Excel

Learn to enter and

edit

data in Excel

Learn to adjust the way

data

and information are displayed in Excel

Learn to write

formulas

quickly and easily with the point-and-click method

Learn to use relative, absolute, and mixed

references

in Excel

Learn to create powerful calculations with Excel

functions

Learn to use documentation so that you can work with

every function

Learn to visually represent your data:

charts, trendlines, sparklines, combo charts

Learn to use Excel

data tools

like sorting, subtotaling, and filtering

Learn to "freeze

columns and rows

" with freeze panes in Excel

Learn to

remove duplicates

from data in Excel

Learn to "

transpose data

" - switching the columns and rows in Excel

Learn to use Excel to leverage data with

Pivot Tables

&

Pivot Charts

Learn to

format

worksheets including

conditional formatting

Learn to automate Excel tasks with time-saving

macros

Learn to

integrate Microsoft Excel with Microsoft Word

Learn to use passwords in Excel to

protect

your work in multiple scenarios

Learn tips and tricks about Excel, as well as Excel

secrets and shortcuts

Learn to use

printing and sharing

in Excel

Learn to

harvest data from the web

Learn to create powerful

random data generators

Learn to use

freeze panes, sorting, filtering, & advanced filtering

Learn to

"what if" sensitivity analysis

such as goal seek, scenarios, & data tables

Learn to use

multiple windows, selection panes, proofing, & translating tools

Learn to print your worksheets with various formatting to various formats including

PDF

Learn to use pivot tables, slicers, timelines, & pivot charts

Learn to apply

styles, themes, stats, accessibility, watch & calculation options

Learn to use

get & transform

and the

power query editor

Learn to use the

data model

and to create relationships between your data

Learn to work with

data joins

and to

append data

Learn to use

3D maps

and to create recorded scenes

Learn to program Microsoft Excel with

VBA (Visual Basic for Applications)

Download all of the Excel project files that are used in the videos

Described as “

fun,

” “

amazing,

” and “

life changing

,” this Excel training will forever

transform the way you work with numbers

. Try this course for yourself and

see how quickly and easily you too can master Microsoft Excel.