• Whatsapp
  • Instagram
  • Facebook
  • Twitter
  • LinkedIn
  • YouTube

Microsoft Excel has the basic features of all spreadsheets, using a grid of cells arranged in numbered rows and letter-named columns to organize data manipulations like arithmetic operations. It has a battery of supplied functions to answer statistical, engineering and financial needs.

 

 COURSE OUTLINE 

 

 BASIC LEVEL 

 

User Interface

  • Ribbon User interface

  • Launching & Quitting

  • Help

 

Creating Spreadsheet

  • Creating a New Workbook

  • Navigating in Excel

  • Moving the Cell Pointer

  • Using Excel Menus

  • Using Excel Toolbars: Hiding, Displaying, and Moving Toolbars

  • Entering Values in a Worksheet and Selecting a Cell Range

  • Previewing and Printing a Worksheet

  • Getting Help from the Office Assistant

  • Saving a Workbook & Re-opening a saved workbook

  • Formatting a Worksheet

  • Creating Headers, Footers, and Page Numbers

  • Adjusting Page Margins and Orientation

  • Adding Print Titles and Gridlines, rows to repeat at top of each page

 

Formatting Fonts & Values

  • Adjusting Row Height and Column Width

  • Changing Cell Alignment

  • Adding Borders

  • Applying Colors and Patterns

  • Using the Format Painter

  • Using AutoFormat

  • Merging Cells, Rotating Text, and using AutoFit

  • Using AutoFill

  • Managing your workbooks

  • Switching Between Sheets in a Workbook

  • Inserting and Deleting Worksheets

  • Renaming and Moving Worksheets

 

Formulas

  • Creating a basic Formula

  • Calculating Value Totals with AutoSum

  • Editing & Copying Formulas

  • Fixing Errors in Your Formulas

  • Formulas with Several Operators and Cell Ranges

 

Working with the Forms Menu

  • Copy & Paste Filtered Records

  • Creating a Chart

  • Moving and Resizing a Chart

  • Formatting and Editing Objects in a Chart

  • Changing a Chart’s Source Data

  • Changing a Chart Type and Working with Pie Charts

  • Adding Titles, Gridlines, and a Data Table

  • Formatting a Data Series and Chart Axis

  • Annotating a Chart

  • Working with 3-D Charts

  • Selecting and Saving a Custom Chart

  • Using Fill Effects

  • Working with Other Programs

  • Modifying an Inserted Excel Worksheet

  • Inserting a Graphic into a Worksheet

 

Protecting a Workbook

  • Hiding Columns, Rows and Sheets

  • Splitting and Freezing a Window

  • Inserting Page Breaks

  • Advanced Printing Options

  • Entering Date Values and using AutoComplete

  • Editing, Clearing, and Replacing Cell Contents

  • Cutting, Copying, and Pasting Cells

  • Moving and Copying Cells with Drag and Drop

  • Collecting and Pasting Multiple Items

  • Using the Paste Special Command

  • Inserting and Deleting Cells, Rows, and Columns

  • Using Undo, Redo, and Repeat

  • Checking Your Spelling

  • Finding and Replacing Information

 

 

ADVANCED LEVEL

 

Data

  • To name cells

  • To navigate workbooks using named ranges

  • To create named ranges based on cell values

  • To delete named cells/ranges

  • To AutoFormat a cell range

  • To remove the effects of AutoFormat

  • To create a custom number format

  • Using custom number formatting codes

  • To format a range of cells using conditional formatting

  • To use the Paste Special command

  • ‘Paste Special’ options

  • Transpose data

 

Protection

  • What is ‘worksheet protection’?

  • To protect a worksheet

  • To un-protect a worksheet

  • To protect cells

  • To unprotect cells

 

Display

  • To freeze column titles

  • To freeze row titles

  • To freeze row and column titles at the same time

  • To unfreeze rows or columns

  • To hide worksheets

  • To re-display hidden worksheets

  • To create subtotals

  • To remove subtotals

 

Security

  • To specify a password for opening a workbook

  • To specify a password for saving a workbook

  • To use the ‘read-only recommended’ option

  • To use the ‘Always create backup’ option

  • To protect a workbook

  • To un-protect a workbook

  • To remove a password from an Excel workbook

 

Linking

  • To link individual cells within a worksheet

  • To link charts to data within a worksheet

  • To link a cell range on one worksheet to another worksheet (in the same workbook)

  • To link charts between worksheets

  • To link data from one workbook to another

  • To link a chart from one workbook to another

  • Copying a chart from one workbook to another

  • To copy data to the Clipboard

  • To embed data (or a chart) from Excel into a Word document

  • To Paste Link selected Excel data / chart to a Word document

  • To consolidate data over several worksheets

 

Templates

  • What are templates?

  • To use a template

  • To create a template

  • To edit a template

 

Charts and Templates

  • To use the Chart Wizard to create a chart

  • To quickly create a chart using default settings

  • To change the angle of pie chart slices

  • To format the chart axis numbers

  • To format the chart axis scales

  • To format the chart axis text

  • To move a chart item

  • To resize a chart item

  • To re-position a chart title

  • To re-position a chart legend

  • To re-position a chart data label

  • To explode all the segments within a pie chart

  • To delete a data series in a chart

  • To add a data series to a chart

  • To modify the chart type for a defined data series

 

USING FUNCTIONS

  • What is the ‘Insert Function’ utility?

  • Ways to access the Function Wizard

  • To use the Insert Function to enter a function

  • Using the mouse to enter information into the Function Wizard

  • To use the TODAY function

 

PIVOT TABLES / DYNAMIC CROSSTAB

  • What are Pivot Tables?

  • To create a PivotTable

  • To drop data into the Pivot Table

  • To modify data and refresh the Pivot Table

  • To group data within a Pivot table

 

SCENARIOS / VERSIONS

  • What is the ‘Scenario Manager’?

  • Scenario Manager – an example

  • To show a scenario

  • To view an alternative scenario

  • To create a scenario summary

  • Data analysis

  • Statistical Analysis

  • Solver

Microsoft Excel Training Course

Program fees

Basic: USD 515

Advance: USD 578

To register, please click on the tab below, or for further assistance get in touch with us on info@iti.ae , or give us a call at 8004852

© 2022 by INTERNATIONAL TRAINING INSTITUTE. DUBAI, KNOWLEDGE PARK