Description

This is a beginner’s Microsoft Excel training course and aims to give the new spreadsheet user a thorough grounding in the basics of creating and working with spreadsheets using Excel.

Particular emphasis is placed on developing accurate and well-designed spreadsheets employing sound design and documentation principles.

Prerequisites

This course assumes little or no knowledge of spreadsheets or Microsoft Excel.

However, it would be beneficial to have a general understanding of personal computers and the operating system environment, especially in regard to working with files and folders.

Key Topics

• Getting to know Microsoft Excel
• Creating A New Workbook
• Working With Workbooks
• Selecting Ranges
• Formulas And Functions
• Copying Data
• Formula Referencing
• Font Formatting
• Cell Alignment
• Row And Column Formatting
• Number Formatting
• Printing
• Creating Charts

Learning Objectives

When the participant completes this course they will be able to:

• navigate your way around Microsoft Excel 2016
• create and work with a new workbook
• open and navigate within workbooks and worksheets
• make changes to data in a workbook
• understand and work with ranges in a worksheet
• copy and paste data in Excel
• use the fill operations available to fill a data series
• move the contents of cells and ranges within and between workbooks
• understand, create and work with formulas and functions
• understand and use formula cell referencing
• use font formatting techniques
• align the contents of cells in a number of ways
• understand and use the number formatting features in Excel
• format rows and columns in a worksheet
• work with elements that make up the structure of a worksheet
• sort data in a list in a worksheet
• filter data in a table
• print your workbook data
• create effective charts in Microsoft Excel
• obtain help for Excel whenever you need it
• understand points to consider to avoid problems in your worksheets

Topic Outline

Getting To Know Microsoft Excel

• Starting Microsoft Excel
• The Excel Screen
• How Microsoft Excel Works
• Using The Ribbon
• Using Ribbon Key Tips
• Minimising The Ribbon
• Understanding The Backstage View
• Accessing The Backstage View
• Using Short Cut Menus
• Understanding Dialog Boxes
• Launching Dialog Boxes
• Understanding The Quick Access Toolbar
• Adding Commands To The QAT
• Understanding The Status Bar
• Exiting Safely From Excel
• Creating A New Workbook

Understanding Workbooks

• Creating A New Workbook
• Typing Text
• Typing Numbers
• Typing Dates
• Typing Formulas
• Saving A New Workbook
• Easy Formulas
• Checking The Spelling
• Making Basic Changes
• Printing A Worksheet
• Safely Closing A Workbook
• Working With Workbooks

Opening An Existing Workbook

• Navigating A Workbook
• Navigating Using The Keyboard
• Using Go To
• Understanding Data Editing
• Overwriting Cell Contents
• Editing Longer Cells
• Clearing Cells
• Selecting Ranges

Understanding Cells And Ranges

• Selecting Contiguous Ranges
• Selecting Non-Contiguous Ranges
• Using Special Selection Techniques
• Selecting Larger Ranges
• Selecting Rows
• Selecting Columns
• Formulas And Functions

Understanding Formulas

• Creating Formulas That Add
• Creating Formulas That Subtract
• Formulas That Multiply And Divide
• Understanding Functions
• Using The SUM Function To Add
• Summing Non-Contiguous Ranges
• Calculating An Average
• Finding A Maximum Value
• Finding A Minimum Value
• More Complex Formulas
• What If Formulas
• Copying Data

Understanding Copying In Excel

• Using Fill For Quick Copying
• Copying From One Cell To Another
• Copying From One Cell To A Range
• Copying From One Range To Another
• Copying Relative Formulas
• Copying To A Non-Contiguous Range
• Formula Referencing

Absolute Versus Relative Referencing

• Relative Formulas
• Problems With Relative Formulas
• Creating Absolute References
• Creating Mixed References
• Font Formatting

Understanding Font Formatting

• Working With Live Preview
• Changing Fonts
• Changing Font Size
• Growing And Shrinking Fonts
• Making Cells Bold
• Italicising Text
• Underlining Text
• Changing Font Colours
• Changing Background Colours
• Using The Format Painter
• Cell Alignment

Understanding Cell Alignment

• Aligning Right
• Aligning To The Centre
• Aligning Left
• Rotating Text
• Indenting Cells
• Row And Column Formatting

Approximating Column Widths

• Setting Precise Columns Widths
• Setting The Default Column Width
• Approximating Row Height
• Setting Precise Row Heights
• Hiding Rows And Columns
• Unhiding Rows And Columns
• Number Formatting

Understanding Number Formatting

• Applying General Formatting
• Formatting As Currency
• Formatting Percentages
• Formatting As Fractions
• Formatting As Dates
• Using The Thousands Separator
• Printing

Understanding Printing

• Previewing Before You Print
• Selecting A Printer
• Printing A Range
• Printing An Entire Workbook
• Specifying The Number Of Copies
• The Print Options
• Creating Charts

Understanding The Charting Process

• Choosing The Chart Type
• Creating A New Chart
• Working With An Embedded Chart
• Resizing A Chart
• Dragging A Chart
• Printing An Embedded Chart
• Creating A Chart Sheet
• Changing The Chart Type
• Changing The Chart Layout
• Changing The Chart Style
• Printing A Chart Sheet
• Embedding A Chart Into A Worksheet

Concluding Remarks

Target Audience

This course is designed for users new to Microsoft Excel and spreadsheeting. It is a beginner’s course and aims to give the new spreadsheet user a thorough grounding in the basics of creating and working with spreadsheets using Microsoft Excel.