Overview
Excel is one of the power applications for any business or job. With nearly 475 features, this application is essential for the smooth functioning of your business. 12 of the most useful Excel features are introduced through this course.
Course outline
- 01Introduction
- 02Automatic Subtotal
- 03How To Lock Excel Functions
- 04Auditing Function
- 05Table Feature
- 06Date Function
- 07If Analysis Function
- 08If With AN/OR
- 09SumIf & CountIf
- 10Sumifs & Countifs
- 11VLookup & HLookup
- 12XLookup
- 13Pivot Table
Meet the teachers
Mohammed Alfan
Mohammed Alfan supports Microsoft's Product Development section for US and owns a data analytics institute, 'Rows & Columns' in India. He has 15+ years of MNC experience. So far, he has trained almost 14000+ students globally and bagged the Microsoft Most Valuable Professional award in the Excel Category (2022). His book, 'Data Analytics - Pivot to Rescue', is ranked in the Top 3 analytical books for beginners.
View profile ↗
