Month | Date | Duration | Cost | Location | Make a Booking |
---|---|---|---|---|---|
March | 2nd-6th | 1 Week | $ 3,500 | Abu Dhabi | Click to Book |
October | 12th-16th | 1 Week | $ 3,500 | Abu Dhabi | Click to Book |
November | 16th-20th | 1 Week | $ 3,500 | Ghana | Click to Book |
The course is a combination of Microsoft Excel Basic and Intermediate and Advanced
Click to read more about Microsoft Excel Basic
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
-
The course is a combination of Microsoft Excel Basic and Intermediate and Advanced
Click to read more about Microsoft Excel Basic
- 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