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).
Author Name: ClipTraining
Author Description:
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.

Table of Contents

• 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