Learn MS Excel Intermediate
in less than 30 hours
About Course
Take your Excel skills to the next level with this Microsoft Excel Intermediate course. Learn how to use Pivot Tables and other features to organize, analyze, and visualize data. Improve your efficiency in the workplace with Microsoft Excel!
Course Timeline
Week 1
-
Defining Proper Data Set
-
Data analysis: Sumifs vs PivotTable
-
PivotTable concepts and PivotTable with different calculations
-
Cross-tabulated PivotTable report
-
Creating PivotTable from multiple sheets
Week 2
-
GetPivotData function
-
Refresh, Totals, Grouping, Sorting & Formatting PivotTable
-
Inserting slicers and timeline
-
Drill down feature & Unique count/ value
Week 3
-
Fixing blank values and empty cells
-
Use of calculated field and inserting PivotChart
-
Changing Data source
-
Linking slicer to 2 PivotTables & Conditional Formatting in PivotTable
Who should enroll for the course?
Students
Business Executives
Data enthusiasts
Aspiring marketers
Aspiring Accountants
Aspiring Chartered Accountants
Anyone who wants to learn new skills
Course Highlights
Live Online Classes
Daily Assignments and Practice Sheet
Weekly Tests
Why choose us?
.png)
Daily Live Classes
30 hours of Rigorous Training
Regular Personal and Group Discussions
5+ Real-Time Project