Ultimate Microsoft Excel 2016 Course – Go from zero to expert!
What you will learn
Take your Excel skills from Beginner to Advanced
Build a rounded skills around various features of Microsoft Excel
Master the most commonly used Excel Functions
Learn to create clean & dynamic charts and reports using – Pivot Tables
Learn to use advanced Excel Functions – IF, VLOOKUP, INDEX, MATCH etc.
Managing large data sets (or lists) using Excel Tables
Description
Excel can be daunting. Mastering the Microsoft Excel skills will help you boost confidence by applying the knowledge IMMEDIATELY to PERSONAL and WORK projects.
At the end of this course, we can guarantee you that, your Microsoft Excel skills will impress your BOSS!
This course takes you on a step by step journey to master Microsoft Excel.
The material was developed using Microsoft Excel 2016 (Office 365), and most should be applicable to the prior versions as well.
We will start with basics, and cruise into intermediate and advanced topics.
What are you waiting for? ENROLL and START learning.
Time WASTED in WAITING, will never come BACK!!
English
language
Content
Course Introduction
Course Introduction
Excel Versions
Introduction
Excel Versions & Licensing
Getting Started with Excel
Introduction
Quick Tour
Signing into Office 365 Excel & Excel 2016
Creating a Workbook
Opening an existing workbook
Understanding Excel Menu (Ribbon)
The Quick Access Toolbar
The Formula bar
The Status bar
Navigating a spreadsheet
Entering Data
Introduction
Entering Data
Entering Date and Time
Copying and Pasting Cell Data
Selecting Data
Adding Comments
Search and Replace
Autofill and Flashfill
Resources
Working with Worksheets
Introduction
Adding Sheets
Deleting Worksheets
Renaming and adding color to the worksheet tab
Moving and Copying a worksheet
Viewing a worksheet in multiple windows
Splitting the worksheet window into panes
Using Freeze Panes
Hiding and Unhiding Worksheets
Resources
Working with Rows, Columns and Cells
Introduction
Copying and Pasting Rows and Columns
Hiding and Unhide Rows and Columns
Changing Column Width and Row Height
Grouping & Ungrouping
Cell & Ranges
Resources
Working with Tables
Introduction
What are Tables?
Working with tables
Sorting and Filtering
Removing Duplicates
Total Row
Table Style Options
Resources
Formatting Data
Introduction
Formatting Tools
Fonts
Alignment
Number Formatting
Border & Fill
Using Named Styles
Resources
Visualizing Data With Conditional Formatting
Introduction
Highlight Cells Rule
Top/Bottom Rules
Data Bars, Color Scales & Icon Set
Managing Conditional Formatting Rules
Resources
Working with Images and Shapes
Introduction
Inserting Pictures, Online Pictures, Shapes, Icons, SmartArt, Screenshot
Inserting Text Box, Header & Footer, WordArt, Hyperlink
Resources
Sorting and Filtering Data
Introduction
Quick Sort and Custom Sort
AutoFilter
Custom Filters
Advanced Filters
Resources
Excel File Formats
Introduction
Excel File Extensions
Excel File Compatibility
Resources
Working with Templates
Introduction
Exploring Templates
Creating Custom Templates
Printing
Introduction
Print Preview
Page Break preview
Page layout
Print Scaling
Print Settings
Resources
Introduction to Formulas and Functions
Introduction
General Math Rules
Math in Excel
Cell References – Relative, Absolute & Mixed
Named References
Excel Functions
3-D Formulas
Resources
Using Data Validation
Introduction to Data Validation
Data Validation – Options Available
Data Validation – Whole Number
Data Validation – Decimal
Data Validation – List
Data Validation – date
Data Validation – Time
Data Validation – Text Length
Data Validation – Custom
Project – Part 1
Project – Part 2
Project – Part 3
Resources
Other Resources
Keyboard Shortcuts
Upcoming Topics
Upcoming Topics
Bonus
Get our other courses at discounted price!