MS Excel is the most right tool using all over the world with unlimited scope. Excel is not going anywhere, and businesses will continue to use Excel as a primary tool for diverse functions and applications ranging from IT projects to company picnics.
A working knowledge of Excel is vital for most office based professionals today, and stronger Excel skills can open the door to promotion and leadership opportunities. Excel is a powerful tool but need solid training.
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