Key Takeways
-
Navigate Excel’s interface and tabs with ease
-
Use cell referencing and the formula bar effectively
-
Master key Excel shortcuts and productivity hacks
-
Understand data types: text, values, formulas
Who should enroll?
-
Beginners looking to build strong Excel foundations
-
Students and professionals aiming to boost productivity
-
Data enthusiasts exploring Power Query for automation
Course curriculum
-
1
Introduction & Basics
- Introduction to Excel
- Excel Interface
- Cell Referencing
- Formula Bar Details
- Workbooks and Worksheet
- Excel Limitations
-
2
Productivity & Shortcuts
- Essential Excel Shortcuts
- Excel Data Types
- Excel Best Practices
-
3
Power Query
- Power Query Introduction
- Loading Data into Power Query
- Transforming Data in Power Query
- Understanding the Sample Data Set
-
4
Functions & Charts
- Basics of Functions
- Charts
-
5
Formulas
- Basic Function of Excel part -1
- Basic Function of Excel part -2
- Min, Max & Count
-
6
Data Structure Query
- Look Up function
- Add Data from Image
- Circle Validation
- Advanced Functions
- Time related Functions
- Macros
- Integration of AI on Excel
FAQ
-
Do I need prior Excel experience to take this course?
No prior knowledge is required. This course starts with the basics and progresses to advanced features like Power Query.
-
Will I learn keyboard shortcuts and productivity tips?
Yes! The course includes essential shortcuts and practices to help you work faster and more efficiently in Excel.
-
What is Power Query and why is it useful?
Power Query is a data transformation tool in Excel. You'll learn to import, clean, and reshape data without writing code.
-
Will I receive a certificate upon completing the course?
Yes, the course provides a certification upon completion.