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).

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).

• Formatting 12mins
• Working with Data 43mins
• Power Query 15mins
• Text Functions 8mins
• Logical and Statistical Functions 33mins
• Expanded Functions 41mins
• Error Checking 16mins
• Conditional Formatting 21mins
• Charts 45mins
• Pivot Tables 51mins
• Advanced Options 8mins
• Finalizing a Workbook 31mins
• Macros and Form Controls 22mins