- Analyze data with built-in Excel formulas and functions.
- Master Excel charts and PivotTables.
- Format your spreadsheets with ease.
Overview
Increase the number skills you have and improve your spreadsheet expertise by expanding your use of the versatile features in Microsoft Excel. Learn how to work smarter with this essential business tool. Master working with formulas, charts, PivotTables, and more.
Syllabus
Courses under this program:
Course 1: Excel 2016: Advanced Formulas and Functions
-Learn how to create efficient formulas and use some of the 450+ functions in Excel to tabulate and analyze numerical, date, and text data.
Course 2: Excel 2016: Charts in Depth
-Learn how to create advanced Excel charts, such as Gantt charts, custom pie charts, waterfall charts, and more, in Excel 2016.
Course 3: Excel 2016: Pivot Tables in Depth
-Learn how to use PivotTables to summarize, sort, count, and chart your data in Microsoft Excel 2016.
Course 4: Excel 2016: Advanced Formatting Techniques
-Get simple, powerful tips for making spreadsheet information readable and understandable in Excel 2016. Learn advanced Excel formatting techniques.
Course 1: Excel 2016: Advanced Formulas and Functions
-Learn how to create efficient formulas and use some of the 450+ functions in Excel to tabulate and analyze numerical, date, and text data.
Course 2: Excel 2016: Charts in Depth
-Learn how to create advanced Excel charts, such as Gantt charts, custom pie charts, waterfall charts, and more, in Excel 2016.
Course 3: Excel 2016: Pivot Tables in Depth
-Learn how to use PivotTables to summarize, sort, count, and chart your data in Microsoft Excel 2016.
Course 4: Excel 2016: Advanced Formatting Techniques
-Get simple, powerful tips for making spreadsheet information readable and understandable in Excel 2016. Learn advanced Excel formatting techniques.
Courses
-
Get simple, powerful tips for making spreadsheet information readable and understandable in Excel 2016. Learn advanced Excel formatting techniques.
-
Learn how to create efficient formulas and use some of the 450+ functions in Excel to tabulate and analyze numerical, date, and text data.
-
Learn how to create advanced Excel charts, such as Gantt charts, custom pie charts, waterfall charts, and more, in Excel 2016.
-
Learn how to use PivotTables to summarize, sort, count, and chart your data in Microsoft Excel 2016.
Taught by
Dennis Taylor and Curtis Frye