MOS Excel Specialist 3 Day Course ( 2 Courses ) See Dates/Register  

Learning Worksheet Fundamentals

• Creating Workbooks
• Magnifying and Shrinking a Worksheet on Screen
• Understanding MS Excel Window Environment
• Hiding and Unhiding Rows & Columns
• Selecting a Range of Cells
• Freezing and Unfreezing Rows & Columns
• Entering Text/Numbers/Dates in a Worksheet
• Moving Between Worksheets in a Workbook
• Entering a Range of Data
• Adding and Deleting Worksheets in a Workbook
  
• Editing Cell Contents
  
• Creating a Three-Dimensional Formula
  
• Moving Between Worksheets
  
• Linking Workbooks
  
• Naming and Saving Workbooks
  
• Opening Workbooks
  
• Renaming Worksheets
  
• Closing Workbooks and Quitting Excel

Editing and Formatting Worksheets

• Formatting Numbers
• Creating Charts Using the Chart Wizard
  
• Adjusting the Size of Rows and Columns
  
• Moving/Resizing/Deleting Charts
  
• Aligning Cell Contents
  
• Modifying Chart Titles and Adding Axis Labels
  
• Creating and Applying Conditional Formats
  
• Moving and Formatting Chart Elements
  
• Finding and Replacing Cell Content
  
• Changing the Chart Type & Organising Source Data
  
• Inserting and Deleting Cells/Rows/Columns
  
• Updating Data and Formatting the Axes
  
• Cutting/Copying/Pasting/Clearing Cells
  
• Adding Gridlines and Arrows
  
• Using Additional Paste Features

Formatting Cells

• Formatting Text
• Building/Editing/Copying Formulas
• Formatting Numbers as Currency
• Using the Sum Function and AutoSum
• Using Format Painter
• Using the Formula Palette
• Adding Borders/Shading to Cells
• Using the Date Functions
• Using AutoFormat
• Using Absolute and Relative Cell References
• Creating and Applying Styles
• Using Basic Statistical Functions
• Merging Cells

Changing Print Options

• Adding Headers and Footers
• Using the PMT Function to Forecast Loan Payments
• Changing Margins and Centering a Worksheet
• Calculating Cumulative Interest
• Changing the Orientation and Scale
• Computing Investment Value
• Adding and Deleting Page Breaks
• Using the IF Function
• Setting and Clearing a Print Area

 Rows/Columns/Worksheets/Workbooks

• Magnifying and Shrinking a Worksheet on Screen
• Understanding MS Excel Window Environment
• Hiding and Unhiding Rows and Columns
• Selecting a Range of Cells
• Freezing and Unfreezing Rows and Columns
• Entering Text/Numbers/Dates in a Worksheet
• Moving Between Worksheets in a Workbook
• Entering a Range of Data
• Adding and Deleting Worksheets in a Workbook
• Editing Cell Contents
• Creating a Three-Dimensional Formula
• Moving Between Worksheets
• Linking Workbooks

Working with Charts

• Creating Charts using the Chart Wizard
• Adjusting the Size of Rows and Columns
• Moving/Resizing/Deleting Charts
• Aligning Cell Contents
• Modifying Chart Titles and Adding Axis Labels
• Creating and Applying Conditional Formats
• Moving and Formatting Chart Elements
• Finding and Replacing Cell Content
• Changing the Chart Type & Organising Source Data
• Inserting and Deleting Cells/Rows/Columns
• Updating Data and Formatting the Axes
• Cutting/Copying/Pasting/Clearing Cells
• Adding Gridlines and Arrows
• Using Additional Paste Features
• Previewing and Printing a Chart

Performing Basic Calculations

• Building/Editing/Copying Formulas
• Formatting Numbers as Currency
• Using the Sum Function and AutoSum
• Using Format Painter
• Using the Formula Palette
• Adding Borders/Shading to Cells
• Using the Date Functions
• Using AutoFormat
• Using Absolute and Relative Cell References
• Creating and Applying Styles
• Using Basic Statistical Functions
• Merging Cells
• Using Numbered Series and AutoFill

Using Basic Financial and Logical Functions

• Using the PMT Function to Forecast Loan Payments
• Changing Margins and Centering a Worksheet
• Calculating Cumulative Interest
• Changing the Orientation and Scale
• Computing Investment Value
• Adding and Deleting Page Breaks
• Using the IF Function

Using Excel with the Internet

• Creating and Editing Hyperlinks
• Saving Workbooks and Worksheets as Webpages
• Sending Workbooks via E-Mail