Diploma in Microsoft Excel

What is Excel? How to open and close Excel and a basic overview of Spreadsheet software. Topics covered in this module include:
• Introducing Microsoft Excel
• Starting Microsoft Excel
• Understanding spreadsheets
• Understanding the Excel window
• Understanding the workbook window
• Using the Ribbon
• Using the Quick Access Toolbar
• Getting help on Microsoft Excel
• Exiting Microsoft Excel
• Exercise / Solutions
• Summary

What are Workbooks and Worksheets? How they work and what they assist with. Topics covered in this module include:
• Creating and Saving Workbooks
• Creating a new workbook
• Saving a workbook
• Auto-saving your work
• Closing a workbook
• Opening a workbook
• Moving the cell pointer
• Moving around a worksheet
• Entering text 5 Entering numbers
• Entering dates and times
• Using the Zoom tool
• Exercise / Solutions
• Summary

How to alter Workbooks and make changes to the data held within them. Topics covered in this module include:
• Editing Workbooks
• Selecting ranges of cells
• Editing cell contents
• Clearing cell contents
• Copying cell contents
• Moving cell contents
• Inserting and deleting cells
• Inserting columns and rows
• Deleting columns and rows
• Copying cells with AutoFill
• Inserting cell comments
• Checking your spelling
• Finding and replacing data
• Exercise / Solutions
• Summary

How to perform and generate different basic calculations upon data within Workbooks. Topics covered in this module include: • Performing Simple Calculations
• Introducing formulae
• Totalling columns and rows
• Calculating with formulae
• Calculating averages
• Find the highest & lowest values
• Understanding cell referencing
• Using explicit values in formulae
• Exercise / Solutions
• Summary

Changing the format of Worksheets by editing Fonts, Colours and other factors. Topics covered in this module include
• Formatting Worksheets
• Formatting with font and colour
• Formatting numbers
• Formatting dates and times
• Copying and pasting formatting
• Adjusting column widths and row heights
• Aligning cell contents
• Indenting and rotating cell contents
• Merging cells
• Adding borders, colour and shading
• Using styles
• Using document themes
• Exercise / Solutions
• Summary

Printing Worksheets and changing options to find the most efficient print formats. Topics covered in this module include:
• Previewing and Printing Worksheets
• Previewing the worksheet
• Preparing pages for printing
• Creating headers and footers
• Specifying the print area and titles
• Controlling page breaks
• Printing a worksheet
• Exercise / Solutions
• Summary

How to manage a multitude of similar or related Workbooks to make storing and saving more effective. Topics covered in this module include:
• Managing Workbooks
• Switching between worksheets
• Renaming worksheets
• Moving and copying worksheets
• Inserting and deleting worksheets
• Referencing external data
• Exercise / Solutions
• Summary

Using data stored in Workbooks and Worksheets to generate a wide array of charts to view data more efficiently. Topics covered in this module include: • Creating Charts
• Creating new charts
• Moving and resizing charts
• Using predefined layouts and styles
• Selecting and changing chart elements
• Changing the chart type
• Adding another data series
• Naming data series
• Formatting and aligning titles
• Controlling gridlines
• Controlling axes
• Adding borders and colour
• Working with 3-D charts
• Updating the data series
• Previewing and printing charts
• Exercise / Solutions
• Summary

A more complex look at the variety of available functions and formulae.

Topics covered in this module include:
• More Functions and Formulae
• Naming cells and ranges
• Common worksheet errors
• Displaying and printing formulae
• Using the COUNT function 5
• Using the IF function
• Exercise / Solutions
• Summary

How to generate and run Macros to make workflow more quickly and smoothly.
Topics covered in this module include:

• Automating Your Work with Macros
• Recording a macro
• Replaying a macro
• Exercise / Solutions
• Summary

Using Data from a variety of external sources and how to effectively import it into Excel. Topics covered in this module include:
• Importing Data
• Importing from text files
• Importing from Microsoft Access
• Exercise / Solutions
• Summary

How to generate tables and use the versatile range of options to filter and view the data. Topics covered in this module include:
• Working with Tables
• Sorting a table of records
• Filtering a table of records
• Subtotalling a table of records
• Exercise / Solutions
• Summary

Viewing data within a Workbook more efficiently by changing the format and additional formatting options. Topics covered in this module include:
• Creating and Formatting Data
• Combining cell contents
• Using conditional formatting
• Creating a custom number format
• Creating a custom date format
• Creating and applying a style
• Exercise / Solutions
• Summary

Adding external or internal content to enhance Workbooks. Topics covered in this module include:
• Creating and Formatting Content
• Inserting clip art
• Inserting graphics
• Moving graphics
• Resizing graphics
• Formatting graphics
• Creating and modifying diagrams
• Moving and resizing diagrams
• Formatting diagrams
• Annotating a chart
• Filling data series with pictures
• Changing the chart type
• Manipulating pie charts
• Selecting and saving a chart template
• Exercise / Solutions
• Summary

Using the Thesaurus and Research options to highlight and correctly collate external sources. Topics covered in this module include:
• Using the Research Tool
• Using the Thesaurus to find synonyms
• Using research services
• Exercise / Solutions
• Summary

How to set Validation to ensure that errors are not introduced into a Workbook. Topics covered in this module include:
• Validating Data
• Using totals as visual checks
• Using formulae for automatic checks
• Using the Range Finder
• Auditing a worksheet
• Using error checking
• Watching and evaluating formulae
• Exercise / Solutions
• Summary