US $19.97

Advanced Excel

——   Created by Simon Sez IT

Share this course:

NEW
Course
57
Lessons
8h 05m
Lesson time
intermediate
Skill level

More about this course

Get beyond the basics and supercharge your current skill level in Excel. With this 9-hour, expert-led video training course, you’ll gain an in-depth understanding of more advancedExcel features thatdelve into high-level consolidation, analysis and reporting of financial information.

What You'll Learn

What's new/different in Excel 2019

Advanced charting and graphing in Excel

How to use detailed formatting tools

Lookup and advanced lookup functions

Financial functions including calculating interest and depreciation

Statistical functions

Connecting to other workbooks and datasets outside of Excel e.g. MS Access and the web.

How to create awesome visualizations using spark lines and data bars

Mastery of PivotTables and Pivot Charts

Scenario Manager, Goal Seek and Solver

Advanced charts such as Surface, Radar, Bubble and Stock Charts

Course Format

This is a video-led course. You can preview some videos below.

This course includes practice exercises so you can practice as you learn.

This course is suitable for Windows users.

57 Lessons

Chapter 1: Introduction to Excel 2019 Advanced Course
7 mins
Introduction to the Course
free preview
5 mins
Course Structure
free preview
Chapter 2: Functions
14 mins
Functions - Part 1
9 mins
Functions - Part 2
7 mins
Autosum
Chapter 3: Date and Time Functions
10 mins
How Date and Time Works
10 mins
Basic Date and Time Functions
11 mins
Complex Date and Time Functions
Chapter 4: Text Functions
13 mins
Using Text Functions - Part 1
13 mins
Using Text Functions - Part 2
Chapter 5: Logical Functions
View more lessons +

About the instructor

Simon Sez IT
Simon Sez IT
  • 34 courses

Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon …

Read more
This course is included in Arbington Premium
$15/month gets you access to every course. Start your 14 day trial today. ☝️

Class benefits

  • Certificate of Completion
  • 30 day satisfaction guarantee
  • 24/7 streaming access
  • Direct teacher access
  • 8h 05m of on-demand video
  • 3 downloadable files
  • Have a coupon?
  • Checkout