Excel for Interviews: Mastering Excel Functions, Formulas, and Data Analysis
This course is designed to prepare you for Excel-related interview questions. It covers a wide range of topics from basic Excel functions and formulas to advanced data analysis and visualization techniques. The course also includes practical examples and follow-up questions to ensure you fully understand each topic.
-
Introduction to Excel
- Basics of Excel
- Excel vs Excel Online
- Workbook vs Worksheet
-
Excel Basics
- Formulas
- Functions
- Data Validation
- Conditional Formatting
-
Excel Functions
- PROPER, UPPER, LOWER Functions
- AVERAGE, MAX, MIN Functions
- COUNT, COUNTA, COUNTIF Functions
-
Data Analysis in Excel
- Pivot Tables
- VLOOKUP
- Charts and Graphs
-
Advanced Excel Topics
- Macros and VBA
- Data Cleaning
- Excel Security