KEMBAR78
Advanced Excel | PDF
Scribd
Upload
97 views3 pages

Advanced Excel

The document outlines a comprehensive Advanced Excel training program consisting of 11 modules. Topics covered include the Excel interface, data manipulation, formulas and functions, data visualization, PivotTables, lookup functions, macros, Visual Basic for Applications, and dashboard creation. Each module provides detailed insights into specific Excel features and functionalities aimed at enhancing users' proficiency in Excel.

Uploaded by

omer.mohemmed
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
97 views3 pages

Advanced Excel

The document outlines a comprehensive Advanced Excel training program consisting of 11 modules. Topics covered include the Excel interface, data manipulation, formulas and functions, data visualization, PivotTables, lookup functions, macros, Visual Basic for Applications, and dashboard creation. Each module provides detailed insights into specific Excel features and functionalities aimed at enhancing users' proficiency in Excel.

Uploaded by

omer.mohemmed
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 3

Advanced Excel

Module 1 - Introduction to Excel


 What is Excel? Excel Usage
 Advantages of Excel
 Introduction to Excel Interface

Module 2 - The Building Blocks of Spreadsheets


 What are Rows, Columns and Cells?
 Editing Data in Cells
 Customize the Quick Access Toolbar and Ribbon
 Freeze Worksheet Rows and Columns, Change Views and Orientation
 Navigate within the Workbooks

Module 3 - Editing Data in Microsoft Excel


 Manipulate Data in Worksheets
 Format Cells and Ranges
 Define Reference-Named Ranges
 Relative and Absolute Reference
 Working with Different Types of Data
 What are Lists? Features of Lists.
 Format the List as a Table
 Create and Format Tables, and Modify them.
 Database Functions:DSUM(),DAVERAGE(),DCOUNT()

Module 4 - Perform Operations by Using Formulas and Functions


 Structure of a Function
 Calculate and Transform Data and also the format as well as modify text
 Perform Logical Operations in Formulas
 Display Formulas
 Use Advanced Date and Time Functions
 Fill Cells Based on Existing Data
 Troubleshoot Formulas
Module 5 - Formatting and Validating Data
 Font of the Data
 Color of the Text and Cell
 Format and Validate Data (Data Validation)
 Conditional Formatting ( Use of Formula)
 Insert Sparkline and Summarize Data Visually

Module 6 - Creating Visualization


 Create Charts
 Modify Charts
 Format Charts
 Create and Modify Advanced Charts

Module 7 - PivotTables and PivotCharts


 Create PivotTables
 Modify Field Selections and Options
 Create Slicers and Group PivotTable Data
 Create PivotCharts
 Manipulate Options in Existing PivotCharts
 Apply Styles to PivotCharts
 Drill Down into PivotChart Details

Module 8 - LOOKUP Function


 LOOKUP() and VLOOKUP() Function
 HLOOKUP() Function
 INDEX(), MATCH()
 ADDRESS(), AREAS(), UNIQUE(), CHOOSE(), COLUMN(), COLUMNS()
Functions
Module 9 - Macros
 Enable Macros in a Workbook
 Create and Modify Simple Macros
 Copy Macros Between Workbooks

Module 10 - Visual Basic for Application in Excel


 Introduction to Visual Basic for Application
 A Glimpse of Visual Basic Editor
 Working in a VBA
 Conditional statement in VBA
 Loops Statements in VBA

Module 11 - Creating Dashboards


 Creation of an Excel Dashboard
 Adding Various Elements in a Dashboard
 Configuring Dashboard

You might also like