Excel 2021 Pro
In this course, Excel 2021 Pro, you will take your Excel knowledge to the ultimate level. When youíre finished with this course, you will have the skills needed to create advanced professional spreadsheets (and complete preparation for the Office exams).
What you'll learn
n this course, Excel 2021 Pro, you will take your Excel knowledge to the ultimate level. First, you will 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 will have the skills needed to feel fully complete in creating professional spreadsheets (and complete preparation for the 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
- Using Nested Formulas 8m
- Reference the Date and Time by Using the NOW and TODAY Functions 6m
- Serialize Numbers by Using DATE and TIME Functions 8m
- 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 6m
- Create a New Chart 4m
- Add Additional Data Series 4m
- Switch Between Rows and Columns in Source Data 1m
- Analyze Data by Using Quick Analysis 4m
- Resize Charts 4m
- Move Charts to a Chart Sheet 2m
- Add and Modify Chart Elements 7m
- Apply Chart Layouts 3m
- Apply Chart Styles 3m
- Add Trendlines to Charts 3m
- Create Dual-Axis Charts 4m
- Save a Chart as a Template 3m
- Create PivotTables 6m
- Modify Field Selections and Options 5m
- Create Slicers 4m
- Move Pivot Table Row Fields Into Separate Columns 4m
- Group PivotTable Data 4m
- Format PivotTable Data 5m
- Add Additional Fields 4m
- Add Calculated Fields 5m
- Drill Down Into PivotTable Details 2m
- Create PivotCharts 3m
- Modify Field Selections and Options in PivotCharts 4m
- Apply Styles to PivotCharts 2m
- Drill Down Into PivotChart Details 3m
- Inspect a Workbook for Hidden Properties or Personal Information 4m
- Inspect a Workbook for Accessibility Issues 7m
- Inspect a Workbook for Compatibility Issues 5m
- Restrict Editing and Protect a Workbook 5m
- Protect Workbook Structure 3m
- Encrypt a Workbook With A Password 3m
- Manage Workbook Versions 5m
About the author
ClipTraining, an industry leader in affordable cloud-based training and support, is a provider of Windows/Office/Office 365 and Security task-based end-user training videos. Our goal is to provide engaging training that ensure the learner can succeed in mastering new skills or enhancing existing ones.