a

Lorem ipsum dolor sit amet, conse ctetur adip elit, pellentesque turpis.

Image Alt

Microsoft Excel (Basic, Intermediate & Advanced)

  /    /  Microsoft Excel (Basic, Intermediate & Advanced)
MonthDateDurationCostLocationMake a Booking
March2nd-6th1 Week$ 3,500Abu DhabiClick to Book
October12th-16th1 Week$ 3,500Abu DhabiClick to Book
November16th-20th1 Week$ 3,500GhanaClick to Book

Microsoft Excel Basic

  • Indicate the names and functions of the Excel interface components
  • Enter and edit data
  • Format data and cells
  • Construct formulas, including the use of built-in functions, and relative and absolute references
  • Create and modify charts
  • Preview and print worksheets
  • Use the Excel online Help feature

Microsoft Excel Intermediate

  • Create pivot tables and charts
  • Learn to trace precedents and dependents
  • Convert text and validate and consolidate data
  • Collaborate with others by protecting worksheets and workbooks
  • Create, use, edit, and manage macros
  • Import and export data

Microsoft Excel Advanced

  • Filter and generate reports from Excel data
  • How to summarize and analyze data using tools such as Pivot Tables, Scenarios and Goal Seek
  • How to create macros to automate some repetitive tasks
  • How to protect worksheets and workbooks
  • How to manage and analyze data efficiently with Microsoft Excel.

Microsoft Excel Basic

Intro Section:

  • Workplace Intelligence
  • The Benefits
  • The Staff and The Workplace
  • Common Mistakes
  • Workplace Intelligence: An Overview.

Part One:

  • Workplace Dynamics
  • When You Left For Work This Morning, What Did You Leave Behind?
  • Hostile Working Environment
  • Four Generations At Work
  • Values And Generational Feedback
  • Generational Interaction In The Workplace.

Part Two:

  • What Is Organizational Culture?

Exploring Excel

  • Finding and using commands
  • Moving around a worksheet
  • Navigating the workbook

Basic Workbook Skills

  • Creating a workbook
  • Selecting cells and ranges
  • Opening, closing and saving workbooks
  • Entering data into cells
  • Entering values into ranges

Creating Simple Formulas

  • Writing formulas in cells
  • Using the Formula Bar
  • AutoSum and other basic functions
  • The Paste Function tool
  • Automatic calculation

Copying And Moving Data

  • Copying and cutting data
  • Absolute cell references
  • Filling cells
  • Using drag-and-drop
  • Undo and Redo
  • Find and Replace

Managing Worksheets

  • Naming worksheets
  • Copying and moving worksheets
  • Grouping worksheets
  • Moving data between sheets
  • Adding and deleting worksheets
  • Creating 3-D formulas

Printing

  • Choosing what to print
  • Previewing and printing
  • Page Setup
  • Margins and page orientation
  • Headers and footers
  • Repeating column/row headings
  • Page Break Preview
  • Printing gridlines

Formatting Data And Cells

  • Formatting numbers
  • Formatting text
  • Colouring data and cells
  • Wrapping and shrinking text
  • Merging cells
  • Using indents
  • Applying borders to cells
  • The Format Painter
  • Conditional formatting

Working With Columns and Rows

  • Selecting columns and rows
  • Changing column width and row height
  • Hiding and unhiding
  • Inserting and deleting

Using Large Spreadsheets

  • Changing the magnification
  • Full Screen view
  • Splitting the window
  • Using Freeze Panes

Named Ranges

  • Naming a range of cells
  • Jumping to a named range
  • Using range names in formulas
  • Re-defining and deleting range names

Working With Data Series

  • Creating a linear series
  • Working with Date series
  • Using Autofill

Microsoft Excel Intermediate

WORKING WITH FUNCTIONS

  • Using the Paste Function tool
  • Absolute and relative cell references
  • Using range names in functions
  • Creating nested functions
  • Logical functions (SUMIF, COUNTIF)
  • The IF function and nested Ifs using AND and OR conditions Using VLOOKUP
  • Financial functions (PMT, NPV)

WORKING WITH DATA

  • Using Excel as a database
  • Sorting Data
  • Custom sorts
  • Filtering using AutoFilter
  • The Advanced Filter tool
  • Database functions
  • Using the Data Form to enter data
  • Creating subtotals

WORKING WITH EXTERNAL DATA

  • Data consolidation
  • Linking to another workbook
  • Linking to an external database
  • Getting data from the web

CHARTING WITH EXCEL

  • Selecting the data to chart
  • Creating a chart
  • Choosing the right chart for the job
  • Moving and re-sizing charts
  • Customizing charts
  • Saving and copying a chart’s design

TABLES

  • Creating an Excel table
  • Table formatting
  • Adding rows and columns
  • Automatic calculation in tables

COLLABORATION TOOLS

  • Protecting a workbook
  • Protecting worksheets and cells
  • Adding comments to cells
  • Sharing workbooks
  • Tracking changes

AUDITING WORKBOOKS

  • Viewing formulas
  • Tracing precedents and dependents
  • Error checking

Microsoft Excel Advanced

  • Advanced Excel Formulas and Useful Functions
  • Text to Column
  • Flash fill
  • Sorting with Slicer
  • Lookup Functions
  • Statistical Functions
  • Database Functions
  • Index
  • Text function/operation
  • Referencing
  • Cell Comments and Cell Referencing
  • What if Analysis
  • Data Table
  • Pivot Tables
  • Grouping & Subtotal
  • Data Consolidation and Data Validation
  • Linking Files and Worksheets
  • Worksheet Protection
  • Share Workbook
  • Formula Editing
  • Error Tracing
  • Custom Number Formatting
  • Tracking Changes
  • Hyperlink
  • Importing Data
  • Introduction to Macros
  • Advanced Charts and Graphs
  • Advanced Printing
  • Cheat Sheet Handout
  • Management Trainee
  • Specialist Staff
  • Managers
  • Management Staff and Directors
Course Overview
Learning Objectives

Microsoft Excel Basic

  • Indicate the names and functions of the Excel interface components
  • Enter and edit data
  • Format data and cells
  • Construct formulas, including the use of built-in functions, and relative and absolute references
  • Create and modify charts
  • Preview and print worksheets
  • Use the Excel online Help feature

Microsoft Excel Intermediate

  • Create pivot tables and charts
  • Learn to trace precedents and dependents
  • Convert text and validate and consolidate data
  • Collaborate with others by protecting worksheets and workbooks
  • Create, use, edit, and manage macros
  • Import and export data

Microsoft Excel Advanced

  • Filter and generate reports from Excel data
  • How to summarize and analyze data using tools such as Pivot Tables, Scenarios and Goal Seek
  • How to create macros to automate some repetitive tasks
  • How to protect worksheets and workbooks
  • How to manage and analyze data efficiently with Microsoft Excel.
Program Outline

Microsoft Excel Basic

Intro Section:

  • Workplace Intelligence
  • The Benefits
  • The Staff and The Workplace
  • Common Mistakes
  • Workplace Intelligence: An Overview.

Part One:

  • Workplace Dynamics
  • When You Left For Work This Morning, What Did You Leave Behind?
  • Hostile Working Environment
  • Four Generations At Work
  • Values And Generational Feedback
  • Generational Interaction In The Workplace.

Part Two:

  • What Is Organizational Culture?

Exploring Excel

  • Finding and using commands
  • Moving around a worksheet
  • Navigating the workbook

Basic Workbook Skills

  • Creating a workbook
  • Selecting cells and ranges
  • Opening, closing and saving workbooks
  • Entering data into cells
  • Entering values into ranges

Creating Simple Formulas

  • Writing formulas in cells
  • Using the Formula Bar
  • AutoSum and other basic functions
  • The Paste Function tool
  • Automatic calculation

Copying And Moving Data

  • Copying and cutting data
  • Absolute cell references
  • Filling cells
  • Using drag-and-drop
  • Undo and Redo
  • Find and Replace

Managing Worksheets

  • Naming worksheets
  • Copying and moving worksheets
  • Grouping worksheets
  • Moving data between sheets
  • Adding and deleting worksheets
  • Creating 3-D formulas

Printing

  • Choosing what to print
  • Previewing and printing
  • Page Setup
  • Margins and page orientation
  • Headers and footers
  • Repeating column/row headings
  • Page Break Preview
  • Printing gridlines

Formatting Data And Cells

  • Formatting numbers
  • Formatting text
  • Colouring data and cells
  • Wrapping and shrinking text
  • Merging cells
  • Using indents
  • Applying borders to cells
  • The Format Painter
  • Conditional formatting

Working With Columns and Rows

  • Selecting columns and rows
  • Changing column width and row height
  • Hiding and unhiding
  • Inserting and deleting

Using Large Spreadsheets

  • Changing the magnification
  • Full Screen view
  • Splitting the window
  • Using Freeze Panes

Named Ranges

  • Naming a range of cells
  • Jumping to a named range
  • Using range names in formulas
  • Re-defining and deleting range names

Working With Data Series

  • Creating a linear series
  • Working with Date series
  • Using Autofill

Microsoft Excel Intermediate

WORKING WITH FUNCTIONS

  • Using the Paste Function tool
  • Absolute and relative cell references
  • Using range names in functions
  • Creating nested functions
  • Logical functions (SUMIF, COUNTIF)
  • The IF function and nested Ifs using AND and OR conditions Using VLOOKUP
  • Financial functions (PMT, NPV)

WORKING WITH DATA

  • Using Excel as a database
  • Sorting Data
  • Custom sorts
  • Filtering using AutoFilter
  • The Advanced Filter tool
  • Database functions
  • Using the Data Form to enter data
  • Creating subtotals

WORKING WITH EXTERNAL DATA

  • Data consolidation
  • Linking to another workbook
  • Linking to an external database
  • Getting data from the web

CHARTING WITH EXCEL

  • Selecting the data to chart
  • Creating a chart
  • Choosing the right chart for the job
  • Moving and re-sizing charts
  • Customizing charts
  • Saving and copying a chart’s design

TABLES

  • Creating an Excel table
  • Table formatting
  • Adding rows and columns
  • Automatic calculation in tables

COLLABORATION TOOLS

  • Protecting a workbook
  • Protecting worksheets and cells
  • Adding comments to cells
  • Sharing workbooks
  • Tracking changes

AUDITING WORKBOOKS

  • Viewing formulas
  • Tracing precedents and dependents
  • Error checking

Microsoft Excel Advanced

  • Advanced Excel Formulas and Useful Functions
  • Text to Column
  • Flash fill
  • Sorting with Slicer
  • Lookup Functions
  • Statistical Functions
  • Database Functions
  • Index
  • Text function/operation
  • Referencing
  • Cell Comments and Cell Referencing
  • What if Analysis
  • Data Table
  • Pivot Tables
  • Grouping & Subtotal
  • Data Consolidation and Data Validation
  • Linking Files and Worksheets
  • Worksheet Protection
  • Share Workbook
  • Formula Editing
  • Error Tracing
  • Custom Number Formatting
  • Tracking Changes
  • Hyperlink
  • Importing Data
  • Introduction to Macros
  • Advanced Charts and Graphs
  • Advanced Printing
  • Cheat Sheet Handout
Target Audience
  • Management Trainee
  • Specialist Staff
  • Managers
  • Management Staff and Directors

Call Me Back