Autoplay
Autocomplete
Previous Lesson
Complete and Continue
PRO Excel For Accountants and Data Analysts
Course: Introduction and requirements
#1 Downloadable Practice Files
Course syllabus – Introduction (7:55)
Microsoft Power Query and ASAP Utilities for Excel- Complete Download and Installation Guide (5:29)
A Complete Guide to get started with Excel
#2 Downloadable Practice Files
Useful keyboard shortcuts in Microsoft Excel (3:35)
Excel Ribbon - Quick access toolbar (7:38)
Select and Navigate Massive Data in Excel (7:28)
The Process audit - Features to speed up your review
#3 Downloadable Practice Files
Excel Watch Window - For displaying selected results all times (5:12)
View/Compare and Monitor multiple files side by side (5:21)
All items in the Manual explained: Go to Window and Special (18:00)
Find and select cells formatting that meet specific conditions (14:39)
Printing Settings- Details (18:02)
Analysis of an Excel file using inquire
#4 Downloadable Practice Files
Activate the Inquire Add-in in Excel Introduction to Workbook Analysis Report (5:33)
Workbook Analysis Report - Introduction (4:38)
Workbook to Analyze Report - Part 1 (11:13)
Workbook to Analyze Report - Part 2 (9:21)
Relationship between Workbook/Worksheet and Cells (12:01)
Text Compare - Compare files (7:52)
Clear Formatting in Excel (3:25)
Formula Auditing
#5 Downloadable Practice Files
Excel formula calculations based on Order of Operations (6:15)
Identify Errors with Formula Auditing (10:14)
Detect/Check errors in the Formula Text in Spreadsheets (6:00)
Using Structured References like Relative & Absolute, Structured, Named Ranges / cells - Part 1 (12:40)
Using Structured References like Relative & Absolute, Structured, Named Ranges / cells - Part 2 (6:35)
Rounding Precision – Excel’s Precision as displayed (3:55)
Excel Pivot Tables
#6 Downloadable Practice Files
Pivot Tables, Data Models and Power Pivot – Introduction (7:04)
Create Pivot Table - Data Source - Single Sheets (11:11)
Multiple Sheets, External Data and Existing pivot table from Other Data Sources (9:03)
How to create a data model and power pivot (9:22)
How to filter the data - Report Level, Slicers, Timelines - Label & Value filters (14:48)
How to Sort the data in Pivot Table - Ascending, Descending, Manual or Custom Sort (9:05)
Group and rename your Data (3:54)
Summarizing Excel Data using various options (4:57)
Create a heat map data bars and sparklines in excel using Conditional formatting (4:21)
Calculated fields and items- Usage issues (7:00)
Excel pivot table issues Resolved (6:58)
Spreadsheet governance framework
#7 Downloadable Practice Files
Complete Governance around spreadsheets (3:16)
SIPOC Model - Process, maintain and monitor spreadsheets for improvement (6:29)
Get the List of File Names in a folder and create Index of sheets (5:54)
Multiple Sheets, External Data and Existing pivot table from Other Data Sources
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock