MS Excel - Level I, II, III


MS Excel

The breadth of business, educational, and organizational information in existence today is absolutely staggering. Imagine, if you will, having to calculate what percentage of your organization's sales occurred in one small town in, say, Qatar. If your organization operates in multiple countries and generates billions of dollars in revenue annually, it could take a lifetime to isolate the exact figures you need and then compare those to the rest of your revenues. Who has that kind of time? This is exactly where the power of Excel can help.

129 25
Topics covered:Excel Level-I - BasicsDuration: 8 Hrs.
1: Getting Started with Microsoft Office Excel
A: Navigate the Excel User Interface |B: Use Excel Commands |C: Create and Save a Basic Workbook |D: Enter Cell Data |E: Use Excel Help
Lesson 2: Performing Calculations
A: Create Worksheet Formulas |B: Insert Functions |C: Reuse Formulas
Lesson 3: Modifying a Worksheet
A: Insert, Delete, and Adjust Cells, Columns, and Rows |B: Search for and Replace Data |C: Use Proofing and Research Tools
Lesson 4: Formatting a Worksheet
A: Modify Fonts |B: Add Borders and Colors to Worksheets |C: Apply Number Formats |D: Align Cell Contents|E: Apply Styles and hemes|F: Apply Basic Conditional Formatting|G: Create and Use Templates
Lesson 5: Printing Workbooks
A: Preview and Print a Workbook |B: Define the Page Layout
Lesson 6: Managing Workbooks
A: Manage Worksheets |B: Manage Workbook and Worksheet Views |C: Manage Workbook Properties
Topics covered: Excel Level-II - IntermediateDuration: 10 Hrs.
Lesson 1: Customizing the Excel Environment
Topic A: Configure Excel Options , Topic B: Customize the Ribbon and the Quick Access , Toolbar , Topic C: Enable Excel Add-Ins
Lesson 2: Creating Advanced Formulas
Topic A: Use Range Names in Formulas, Topic B: Use Specialized Functions, Topic C: Use Array Formulas
Lesson 3: Analyzing Data with Functions and Conditional Formatting
Topic A: Analyze Data by Using Text and Logical Functions, Topic B: Apply Advanced Conditional Formatting
Lesson 4: Organizing and Analyzing Datasets and Tables
Topic A: Create and Modify Tables, Topic B: Sort Data, Topic C: Filter Data, Topic D: Use SUBTOTAL and Database Functions
Lesson 5: Visualizing Data with Basic Charts
Topic A: Create Charts, Topic B: Modify and Format Charts
Lesson 6: Analyzing Data with PivotTables, Slicers, and PivotCharts
Topic A: Create a PivotTable, Topic B: Analyze PivotTable Data, Topic C: Present Data with PivotCharts, Topic D: Filter Data by Using Slicers
Topics covered: Excel Level-III- AdvancedDuration: 10 Hrs.
1: Working with Multiple Worksheets and Workbooks Simultaneously
Topic A: Use 3-D References, Topic B: Use Links and External References, Topic C: Consolidate Data
Lesson 2: Sharing and Protecting Workbooks
Topic A: Collaborate on a Workbook, Topic B: Protect Worksheets and Workbooks
Lesson 3: Automating Workbook Functionality
Topic A: Apply Data Validation, Topic B: Work with Forms and Controls, Topic C: Work with Macros
Lesson 4: Applying Conditional Logic
Topic A: Use Lookup Functions, Topic B: Combine Functions, Topic C: Use Formulas and Functions to Apply Conditional Formatting
Lesson 5: Auditing Worksheets
Topic A: Trace Cells, Topic B: Search for Invalid Data and Formulas with Errors, Topic C: Watch and Evaluate Formulas
Lesson 6: Using Automated Analysis Tools
Topic A: Determine Potential Outcomes Using Data Tables, Topic B: Determine Potential Outcomes Using Scenarios, Topic C: Use the Goal Seek Feature, Topic D: Activate and Use the Solver Tool

For more information