Be a Microsoft Excel Professional

What you learn during the training?

Chapter 1 IntroductionPreview

Chapter 2 ObjectivesPreview

Chapter 3 Modify Workbook TemplatesPreview

Chapter 4 Business ScenarioPreview

Chapter 5 Demo - Modify Workbook Templates

Chapter 6 Merge Multiple Workbooks

Chapter 7 Business Scenario

Chapter 8 Demo - Merge Multiple Workbooks

Chapter 9 Manage Multiple Versions Of A WorkbookPreview

Chapter 10 Remove Workbook Metadata

Chapter 11 Copy Styles Between Tables

Chapter 12 Business Scenario

Chapter 13 Demo - Copy Styles Between TemplatesPreview

Chapter 14 Copy Macros Between Workbooks

Chapter 15 Business Scenario

Chapter 16 Demo - Copy Macros Between Workbooks

Chapter 17 External Data Connections

Chapter 18 Business ScenarioPreview

Chapter 19 Demo - External Data Connections

Chapter 20 Protect Workbooks For Sharing

Chapter 21 Business Scenario

Chapter 22 Demo - Protect Workbooks For Sharing

Chapter 23 Protect Worksheet Structure

Chapter 24 Business Scenario

Chapter 25 Demo - Protect Worksheet Structure

Chapter 26 Set Tracking Options

Chapter 27 Business Scenario

Chapter 29 Restrict Editing And Limiting EditorsPreview

Chapter 30 Business ScenarioPreview

Chapter 31 Demo - Restrict Editing And Limiting Editors

Chapter 32 Encrypt Workbooks With A Password

Chapter 33 Business Scenario

Chapter 34 Demo - Encrypt Workbook With A Password

Chapter 35 Business Scenario

Chapter 36 Demo - Mark Workbooks As Final

Chapter 37 Control Calculations Options

Chapter 38 Business ScenarioPreview

Chapter 39 Demo - Control Calculations Options

Chapter 40 Summary

Chapter 41 Mark Workbooks As FinalPreview

Chapter 1 Apply Custom Formats and LAyouts

Chapter 2 Objectives

Chapter 3 Create Custom Formats (number, Time, Date)

Chapter 4 Business Scenario

Chapter 5 Demo - Create Custom Formats Number Date

Chapter 6 Create Custom Accounting Formats

Chapter 7 Advanced Fill Series OptionsPreview

Chapter 8 Business Scenario

Chapter 9 Demo - Advanced Fill Series OptionsPreview

Chapter 10 Create Custom Templates

Chapter 11 Create And Modify Cell Styles

Chapter 12 Business Scenario

Chapter 13 Demo - Create And Modify Cell StylesPreview

Chapter 14 Create Custom Color Formats

Chapter 15 Business ScenarioPreview

Chapter 16 Demo - Create Custom Color Formats

Chapter 17 Create Custom Font Formats

Chapter 18 Business Scenario

Chapter 19 Demo - Create Custom Font Formats

Chapter 20 Create Themes

Chapter 21 Business Scenario

Chapter 22 Demo - Create Themes

Chapter 23 Create Form FieldsPreview

Chapter 24 Business Scenario

Chapter 25 Demo - Create Form Fields

Chapter 26 Control The Tab Order Of Objects

Chapter 27 Summary

Chapter 28 Quiz

Chapter 1 IntroductionPreview

Chapter 2 Objectives

Chapter 3 Nested Functions

Chapter 4 If, And, Or Functions

Chapter 5 Business ScenarioPreview

Chapter 6 Demo - If And Or Functions

Chapter 7 Advanced Sumifs Function

Chapter 8 Business Scenario

Chapter 9 Demo - Advanced Sumifs FunctionsPreview

Chapter 10 Advanced Countifs Function

Chapter 11 Business Scenario

Chapter 12 Demo - Advanced Countifs Functions

Chapter 13 Advanced Averageifs Function

Chapter 14 Business Scenario

Chapter 15 Demo - Advanced Averageifs FunctionsPreview

Chapter 16 What-if-analysis Tools

Chapter 17 Watch Window

Chapter 18 Business Scenario

Chapter 19 Demo - Utilize Watch Window

Chapter 20 Goal Seek

Chapter 21 Business ScenarioPreview

Chapter 22 Demo - Goal Seek

Chapter 23 Create Scenarios

Chapter 24 Business Scenario

Chapter 25 Demo - Create Scenarios

Chapter 26 Create Data Table

Chapter 27 Business Scenario

Chapter 28 Demo - Data TablePreview

Chapter 29 Consolidate Data

Chapter 30 Business Scenario

Chapter 31 Demo - Consolidate Data

Chapter 32 Financial FunctionsPreview

Chapter 33 Summary

Chapter 34 Quiz

Chapter 1 Introduction

Chapter 2 Objectives

Chapter 3 Pivotchart

Chapter 4 Create New Pivotcharts

Chapter 5 Business Scenario

Chapter 6 Demo - Create New PivotchartsPreview

Chapter 7 Pivotcharts With Animations

Chapter 8 Business Scenario

Chapter 9 Pivotcharts With Animations

Chapter 10 Manipulate Options In Existing PivotchartsPreview

Chapter 11 Business Scenario

Chapter 12 Manipulate Options In Existing Pivotcharts

Chapter 13 Pivotchart StylesPreview

Chapter 14 Business ScenarioPreview

Chapter 15 Demo - Pivotcharts Styles

Chapter 16 Summary

Chapter 17 Quiz

Chapter 1 Introduction

Chapter 2 Objectives

Chapter 3 Introduction To Apps For Office

Chapter 4 Installing Apps From Office Store

Chapter 5 Business ScenarioPreview

Chapter 6 Demo - Installing Apps From Office Store

Chapter 7 Inserting And Managing Apps

Chapter 8 Business Scenario

Chapter 9 Demo - Inserting And Managing Apps

Chapter 10 Timeline Filter

Chapter 11 Business Scenario

Chapter 12 Demo - Timeline Filter

Chapter 13 Introduction To Powerview ReportPreview

Chapter 14 Create Powerview Report

Chapter 15 Business ScenarioPreview

Chapter 16 Demo - Creating Powerview Reports

Chapter 17 Powerview Reports Options

Chapter 18 Business Scenario

Chapter 19 Demo - Powerview Reports OptionPreview

Chapter 20 Summary

Chapter 21 Quiz

Chapter 1 Introduction

Chapter 2 Objectives

Chapter 3 Creating Excel User Defined Templates

Chapter 4 Business Scenario

Chapter 5 Demo 1 - Creating Excel User Defined Templates

Chapter 6 Multiple List Box

Chapter 7 Business ScenarioPreview

Chapter 8 Demo 2 - Multiple List Box

Chapter 9 Advanced Validation Rule With Isnumber

Chapter 10 Business Scenario

Chapter 11 Demo 3 - Advanced Validation Rule With IsnumberPreview

Chapter 12 Advanced Validation Rule With Istext

Chapter 13 Business Scenario

Chapter 14 Demo 4 - Advanced Validation Rule With Istext

Chapter 15 Combine Date And Logical Functions

Chapter 16 Business Scenario

Chapter 17 Demo 5 - Combine Date And Logical Functions

Chapter 18 Eomonth Function

Chapter 19 Business Scenario

Chapter 20 Demo 6 - Eomonth FunctionPreview

Chapter 21 Match Function

Chapter 22 Business Scenario

Chapter 23 Match Function

Chapter 24 Business ScenarioPreview

Chapter 25 Index With Match Function

Chapter 26 ndex With Match Function

Chapter 27 Summary

Do you wish to become an expert in MS Excel?