Excel 2021 Pro
Offered By: Pluralsight
Course Description
Overview
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).
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).
Syllabus
- 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
Taught by
ClipTraining
Related Courses
Creating an Analytical DatasetUdacity مهارات برنامج Excel للعمل: المبادئ الأساسية
Macquarie University via Coursera Everyday Excel, Part 1
University of Colorado Boulder via Coursera Financial Forecasting in Python
DataCamp Microsoft Excel Mastery: From Beginner to Pro
Udemy