Excel 2016 Essentials

All you need to know about the essentials for Excel 2016

Whether you are brand new to the world of Excel, or you have training and knowledge of the software and are looking to improve your skills, this masterclass will take you to the next level. By the time you finish the beginner, intermediate and advanced portions, you too will be an expert in Excel.

What our teachers think:

Informative

Nelisha Vadival

Too long

Read Less

Excel 2016

Alet Mari Grobbelaar

Good

Read Less

Course curriculum

1. 1.1. What is Microsoft Excel
1. 2.1. Finding and Opening Microsoft Excel
2. 2.2. Excel's Start Screen
3. 2.3. Explaining the Excel Interface
4. 2.4. Excel Interface Continued
5. 2.5. Excel Workbook vs Excel Worksheet
6. 2.6. Saving and Opening Excel Documents
7. 2.7. Customise the Excel Quick Access Toolbar
8. 2.8. Customizing the Excel Ribbon
9. 2.9. Excel Shortcut Keys
1. 3.1. Creating Excel Labels
2. 3.2. Entering Numeric Values in Excel
3. 3.3. Formatting Date Values in Excel
4. 3.4. Building Basic Formulas in Excel
5. 3.5. Order of Operations
6. 3.6. Relative vs Absolute Cell References
1. 4.1. Excel Functions Explained
2. 4.2. The SUM() Function
3. 4.3. The MIN() and MAX() Function
4. 4.4. The AVERAGE() Function
5. 4.5. COUNT() Functions
1. 5.1. Moving and Copying Data
2. 5.2. Insert and Delete Rows Columns
3. 5.3. Adjusting the Width and Height of Cells
4. 5.4. Hide and Unhide Excel Rows and Columns
5. 5.5. Rename, Move and Delete Excel Worksheets
6. 5.6. Adding Protection to Specific Cells
7. 5.7. Protecting the Structure of a Workbook
8. 5.8. Adding a Workbook Password to Open File
1. 6.1. Formatting Fonts and Cell Background Color
2. 6.2. Adding Cell Borders
3. 6.3. Formatting Data Appropriately
4. 6.4. The Magic behind Excel's Format Painter
5. 6.5. Creating Styles for Formatting Efficiency
6. 6.6. Merging Cells for a Cleaner Look
7. 6.7. The Power of Conditional Formatting
1. 7.1. Grab User’s Attention using Illustrations
2. 7.2. Customizing Icons
3. 7.3. Create Compelling Graphics with SmartArt
1. 8.1. The Commonly used Column Chart
2. 8.2. Changing the Chart Design
3. 8.3. Formatting Elements of a Chart
4. 8.4. Modifying the Data, Type and Location of a Chart
5. 8.5. Little Slice of Pie Charts
1. 9.1. Print Preview Options
2. 9.2. Excel's Page Layout View
3. 9.3. Printing a Specific Range of Cells
4. 9.4. Converting Spreadsheets to PDF Files
1. 10.1. Why Create an Excel Template
2. 10.2. How to Create an Excel Template
1. 11.1. How to Prepare Data for Analysis
2. 11.1.1 Excel Practice File
3. 11.2. How to Sort Data in Excel
4. 11.3. Multi-Level Sorting
5. 11.4. Custom Sorting Datasets in Excel
6. 11.5. Applying Filters to Datasets
7. 11.6. Creating Subtotals within a Dataset
8. 11.7. Converting Datasets into Tables
9. 11.8. Finding & Removing Duplicate Values
1. 12.1. The SUMIF() Function
2. 12.2. The DSUM() Function
3. 12.3. DSUM() Function Cont.
4. 12.4. The SUBTOTAL() Function
1. 13.1. What is Excel Data Validation
2. 13.2. Creating a Drop Down List with Data Validation
3. 13.3. Different Types of Excel Data Validation
4. 13.4. Adding Custom Alerts to Data Validation
5. 13.5. Creating a Dynamic Drop Down List
6. 13.6. Complex Validation Dependent Drop Down List
1. 14.1. Creating an Excel Pivot Table
2. 14.2. Modifying Excel PivotTables
3. 14.3. Grouping and Filtering PivotTable Data
4. 14.4. Drilling Down into PivotTable Data
5. 14.5. Creating Pivot Charts & Utilizing Slicers
1. 15.1. What is PowerPivot
2. 15.2. Activating the Excel PowerPivot Add-In
3. 15.3. Creating Relationships between Data Tables
4. 15.4. Using Data Models to Create PivotTables
5. 15.5. How to Create PowerPivot KPI’s
1. 16.1. Excel’s IF() Function
2. 16.2. IF() Function with AND() Criteria
3. 16.3. IF() Function with OR() Criteria
4. 16.4. Nesting Multiple IF() Functions
5. 16.5. The COUNTIF() Function
6. 16.6. Key Benefits of Named Ranges
1. 17.1. VLOOKUP() Function
2. 17.2. The Beauty of Excel’s IFERROR() Function
3. 17.3. HLOOKUP() Function
4. 17.4. INDEX() Function
5. 17.5. MATCH() Function
6. 17.6. INDEX() and MATCH() Combined
7. 17.7. Two-Way Lookup with INDEX() and MATCH()
1. 1. LEFT(), RIGHT() and MID() Function
2. 2. Extracting Specific Text using LEN() & SEARCH()
3. 3. Combining Text with CONCATENATE()
4. 4. Quick Tips & Other Text Based Functions
1. 1. Tracing Precedents & Dependents in Formulas
2. 2. Showing Formulas
3. 3. Grouping Data
4. 4. 3D Referencing in Formulas
5. 5. Utilizing the Watch Window in Excel
6. 6. How to Freeze Panes in Excel
1. 1. Excel’s Scenario Manager Tool
2. 2. Goal Seek in Excel
3. 3. Compare Results with Excel Data Tables
4. 4. Solver Tool

About this course

106 lessons
8.5 hours of video content

Learning Objectives

By the end of this course, you will:

be a better, faster, stronger Excel user
save hours of time and boost your productivity in Excel
use math, statistical, logic and text functions
create basic and advanced formulas
be creating charts from your data
master Pivot Tables

Certification

You will receive a certificate of completion for Excel 2016 Essentials. You will receive 5 SACE points.

Pricing

This course is part of our CPTD Bundle.

Excel 2016 Essentials

Whether you are brand new to the world of Excel, or you have training and knowledge of the software and are looking to improve your skills, this masterclass will take you to the next level. By the time you finish the beginner, intermediate and advanced portions, you too will be an expert in Excel.

What our teachers think:

Informative

Nelisha Vadival

Excel 2016

Alet Mari Grobbelaar

Course curriculum

1. Excel Essentials Course Introduction

2. Getting Started with Excel

3. Values, Referencing and Formulas

4. Intro to Excel Functions

5. Adjusting Excel Worksheets

6. Visually Pleasing Cell Formatting

7. How to Insert Images and Shapes

8. Visualize Data with Charts

9. Excel's Printing Options

10. Benefits of Using Excel Templates

11. Working with Excel Datasets

12. Excel Database Functions

13. Excel Data Validation

14. Excel PivotTables

15. Excel's PowerPivot Add-In

16. Excel's Conditional Functions

17. Excel's Lookup Functions

18. Text Based Functions in Excel

19. Auditing Formulas and Custom Views in Excel

20. Excel’s “What If” Tools

About this course

Learning Objectives

Certification

Pricing