Advance Excel Course - Rawalpindi

Part I: Getting Started with Excel
1: Introducing Excel
2: Entering and Editing Worksheet Data
3: Essential Worksheet Operations
4: Working with Cells and Ranges
5: Introducing Tables
6: Worksheet Formatting
7: Understanding Excel Files
8: Using and Creating Templates
9: Printing Your Work

Part II: Working with Formulas and Functions
10: Introducing Formulas and Functions
11: Creating Formulas That Manipulate
12: Working with Dates and Times
13: Creating Formulas That Count and Sum
14: Creating Formulas That Look Up Values
15: Creating Formulas for Financial Applications
16: Miscellaneous Calculations
17: Introducing Array Formulas
18: Performing Magic with Array Formulas

Part III: Creating Charts and Graphics
19: Getting Started Making Charts
20: Learning Advanced Charting
21: Visualizing Data Using Conditional Formatting
22: Creating Sparkline Graphics
23: Enhancing Your Work with Pictures and Drawings

Part IV: Using Advanced Excel Features
24: Customizing the Excel User Interface
25: Using Custom Number Formats
26: Using Data Validation
27: Creating and Using Worksheet Outlines
28: Linking and Consolidating Worksheets
29: Excel and the Internet
30: Protecting Your Work
31: Making Your Worksheets Error Free

Part V: Analyzing Data with Excel
32: Importing and Cleaning Data
33: Introducing Pivot Tables
34: Analyzing Data with Pivot Tables
35: Performing Spreadsheet What-If Analysis
36: Analyzing Data Using Goal Seeking and Solver
37: Analyzing Data with the Analysis ToolPak
38: Working with Get & Transform

Part VI: Programming Excel with VBA
39: Introducing Visual Basic for Applications
40: Creating Custom Worksheet Functions
41: Creating UserForms
42: Using UserForm Controls in a Worksheet
43: Working with Excel Events
44: VBA Examples
45: Creating Custom Excel Add-Ins