Excel Course Description

Our Advanced Excel Course  is designed for intermediate Excel users who want to enhance their skills and become proficient in using Excel for various tasks. Whether you’re a business professional, analyst, or student, this course will empower you to work efficiently with data, create complex formulas, and analyze information effectively. 

Course Syllabus
Excel Introduction:

1. Overview of the Excel interface
2. Basic spreadsheet concepts
3. Navigation techniques
4. Shortcut keys
5. Customizing the Ribbon
6. Using and customizing AutoCorrect
7. Changing Excel’s default options

Basic Functions:

1. Using functions (SUM, AVERAGE, MAX, MIN, COUNT, COUNTA)
2. Absolute, mixed, and relative referencing
3. Formatting and proofing
4. Currency formatting
5. Conditional formatting

Mathematical Functions:

1. SUMIF, SUMIFS, COUNTIF, COUNTIFS, AVERAGEIF, AVERAGEIFS
2. Nested IF statements
3. AND, OR, NOT functions

Workbook and Worksheet Protection:

1. File-level protection
2. Workbook and worksheet protection

Text Functions:

1. UPPER, LOWER, PROPER
2. LEFT, MID, RIGHT
3. TRIM, LEN, EXACT
4. CONCATENATE, FIND, SUBSTITUTE

Date and Time Functions:

1. TODAY, NOW
2. DAY, MONTH, YEAR
3. DATEIF, DATEADD, EOMONTH, WEEKDAY

Advanced Paste Special Techniques:

1. Paste formulas, formats, and validations
2. Transpose tables

New Features (Excel 2013/2016/365):

1. New chart types (treemap, waterfall, sunburst, box and whisker)
2. Combo charts with secondary axis
3. Slicers in pivot tables
4. Power Map and Power View
5. Forecast sheet
6. Sparklines (line, column, win/loss)
7. 3D Map
8. Advanced controls in pivot tables

Lookup Functions:

1. VLOOKUP, HLOOKUP
2. INDEX and MATCH
3. Creating a smooth user interface using lookup functions

What-If Analysis:

1. ​Goal Seek
2. Scenario analysis
3. Data tables (PMT function)
4. Solver tool

Logical Functions:

1. IF function
2. Nested IF
3. Complex IF and OR functions

Data Validation:

1. Number, date, and time validation
2. Text and list validation
3. Custom validations based on formulas

Dynamic Dropdown Lists:

1. Creating dependency lists using data validation

Worksheet Linking:

1. Using INDIRECT function


Join our Advanced Excel Training  and boost your career with in-depth knowledge and practical skills. Our industry experts will guide you through live projects, ensuring you become an Excel power user! 🚀📊