Excel 2019 Pro
In this course, you’ll learn the most advanced aspects of working with Excel 2019. Explore how to perform all sorts of useful functions, pivot tables, macros, form controls, and much more in this massive deep dive into the world of Excel 2019.
What you'll learn
Learn the most advanced aspects of Excel 2019. In this course, Excel 2019 Pro, you'll take your knowledge to the ultimate level. First, you'll learn how to format and work with data. Then, you’ll learn about queries, text/logical/statistical and other functions. Finally, you’ll learn conditional formatting, charts, pivot tables, macros, and form controls. When you’re finished with this course, you'll have the skills and knowledge of Excel 2019 needed to format and work with more advanced spreadsheets (and continue your preparation for the Microsoft Office exams).
Table of contents
- Perform Logical Operations by Using the IF Function 3m
- Perform Logical Operations by Using the SUMIF Function 4m
- Perform Logical Operations by Using the AVERAGEIF Function 4m
- Perform Statistical Operations by Using the COUNTIF Function 1m
- Perform Statistical Operations by Using the SUMIFS Function 4m
- Perform Statistical Operations by Using the AVERAGEIFS Function 3m
- Perform Statistical Operations by Using the COUNTIFS Function 3m
- Perform Logical Operations by Using AND, OR, and NOT Functions 4m
- Perform Logical Operations by Using Nested Functions 7m
- Reference the Date and Time by Using the NOW and TODAY Functions 6m
- Serialize Numbers by Using DATE and TIME Functions 7m
- Perform What-if Analysis by Using Goal Seek 4m
- Perform What-if Analysis by Using Scenario Manager 7m
- Calculate Data by Using Financial Functions: PMT 4m
- Calculate Data by Using Financial Functions: PPMT & IPMT 9m
- Calculate Data by Using Financial Functions: FV 4m
- Insert Sparklines 5m
- Create a New Chart 3m
- Add Additional Data Series 4m
- Switch Between Rows and Columns in Source Data 1m
- Analyze Data by Using Quick Analysis 3m
- Resize Charts 2m
- Move Charts to a Chart Sheet 2m
- Add and Modify Chart Elements 6m
- Apply Chart Layouts 2m
- Apply Chart Styles 4m
- Add Trendlines to Charts 4m
- Create Dual-axis Charts 4m
- Save a Chart as a Template 3m
- Create Pivot Tables 6m
- Modify Field Selections and Options 5m
- Create Slicers 3m
- Group Pivot Table Data 3m
- Format Pivot Table Data 3m
- Add Additional Fields 4m
- Add Calculated Fields 5m
- Drill down into PivotTable Details 2m
- Use Cube Functions to Get Data out of the Excel Data Model 7m
- Create Pivot Charts 3m
- Manipulate Options in Existing Pivot Charts 4m
- Apply Styles to Pivot Charts 2m
- Drill down into Pivot Chart Details 3m
About the author
Bill Kulterman is an educator, author, and a Microsoft Certified Trainer (MCT). Bill has been a trainer for more than a dozen years, educating students in Excel, Visio and a bevy of additional solutions. In recent years he has focused solely on SharePoint and SharePoint Online through Office 365. When he's not creating courses, he can usually be found riding his bike or relaxing near his Koi pond.