Microsoft Excel 2016 Level 1 (with Challenge Exercises)

LoanNew

Microsoft Excel 2016 - Level 1 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 2016. Particular emphasis is placed on developing accurate and well-designed spreadsheets employing sound design and documentation principles.

Microsoft Excel 2016 - Level 1 assumes little or no knowledge of spreadsheets or Microsoft Excel 2016.

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

Getting To Know Excel 2016

• Starting Excel From The Desktop
• Understanding The Excel Start Screen
• The Excel Workbook Screen
• How Excel 2016 Works
• Using The Ribbon
• Showing And Collapsing The Ribbon
• Understanding The Backstage View
• Accessing The Backstage View
• Using Shortcut 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 2016
• Practice Exercise
• Practice Exercise Workspace

Creating A New Workbook

• Understanding Workbooks
• Using The Blank Workbook Template
• Typing Text
• Typing Numbers
• Typing Dates
• Typing Formulas
• Easy Formulas
• Saving A New Workbook On Your Computer
• Checking The Spelling
• Making Basic Changes
• Safely Closing A Workbook
• Practice Exercise
• Practice Exercise Sample

Working With Workbooks

• Opening An Existing Workbook
• Navigating A Workbook
• Navigating Using The Keyboard
• Using Go To
• Recent Files And Folders
• Practice Exercise
• Practice Exercise Sample

Editing In A Workbook

• Understanding Data Editing
• Overwriting Cell Contents
• Editing Longer Cells
• Editing Formulas
• Clearing Cells
• Deleting Data
• Using Undo And Redo
• Practice Exercise
• Practice Exercise Sample

Selecting Ranges

• Understanding Cells And Ranges
• Selecting Contiguous Ranges
• Selecting Non-Contiguous Ranges
• Selecting Larger Ranges
• Selecting Rows
• Selecting Columns
• Practice Exercise
• Practice Exercise Sample

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
• Practice Exercise
• Practice Exercise Sample

Filling Data

• Understanding Filling
• Filling A Series
• Filling A Growth Series
• Extracting With Flash Fill
• Practice Exercise
• Practice Exercise Data

Moving Data

• Understanding Moving In Excel
• Moving Cells And Ranges
• Moving By Dragging
• Practice Exercise
• Practice Exercise Sample

Formulas And Functions

• Understanding Formulas
• Creating Formulas That Add
• Creating Formulas That Subtract
• Formulas That Multiply And Divide
• Understanding Functions
• Using The SUM Function
• Summing Non-Contiguous Ranges
• Calculating An Average
• Finding A Maximum Value
• Finding A Minimum Value
• Creating More Complex Formulas
• What If Formulas
• Common Error Messages
• Practice Exercise
• Practice Exercise Sample

Formula Referencing

• Absolute Versus Relative Referencing
• Relative Formulas
• Problems With Relative Formulas
• Creating Absolute References
• Creating Mixed References
• Practice Exercise
• Practice Exercise Sample

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
• Practice Exercise
• Practice Exercise Sample

Cell Alignment

• Understanding Cell Alignment
• Horizontal Cell Alignment
• Vertical Cell Alignment
• Indenting Cells
• Practice Exercise
• Practice Exercise Sample

Number Formatting

• Understanding Number Formatting
• Applying General Formatting
• Formatting For Money
• Formatting Percentages
• Formatting As Fractions
• Formatting As Dates
• Using The Thousands Separator
• Increasing And Decreasing Decimals
• Practice Exercise
• Practice Exercise Sample

Row And Column Formatting

• Approximating Column Widths
• Setting Precise Columns Widths
• Setting The Default Column Width
• Approximating Row Height
• Setting Precise Row Heights
• Practice Exercise
• Practice Exercise Sample

Working With A Worksheet

• Understanding Worksheets
• Changing The Worksheet View
• Worksheet Zooming
• Viewing The Formula Bar
• Viewing Worksheet Gridlines
• Inserting Cells Into A Worksheet
• Deleting Cells From A Worksheet
• Inserting Columns Into A Worksheet
• Inserting Rows Into A Worksheet
• Deleting Rows And Columns
• Working With Multiple Worksheets
• Worksheet Wisdom
• Practice Exercise
• Practice Exercise Sample

Sorting Data

• Understanding Lists
• Performing An Alphabetical Sort
• Performing A Numerical Sort
• Sorting On More Than One Column
• Practice Exercise
• Practice Exercise Sample

Filtering Data

• Understanding Filtering
• Applying And Using A Filter
• Clearing A Filter
• Creating Compound Filters
• Multiple Value Filters
• Creating Custom Filters
• Using Wildcards
• Practice Exercise
• Practice Exercise Sample

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
• Practice Exercise
• Practice Exercise Sample

Creating Charts

• Understanding The Charting Process
• Choosing The Right Chart
• Using A Recommended Chart
• Creating A New Chart From Scratch
• Working With An Embedded Chart
• Resizing A Chart
• Repositioning 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
• Deleting A Chart
• Practice Exercise
• Practice Exercise Sample

Getting Help

• Understanding How Help Works
• Using Tell Me
• Accessing The Help Window
• Navigating The Help Window
• Using Google To Get Help
• Printing A Help Topic
• Other Sources Of Assistance
• Practice Exercise
• Practice Exercise Workspace

A Guide To Brilliant Spreadsheets

• Good Planning Is Essential
• Organisation And Design
• Writing Effective Formulas
• Documented And Easy To Use
• The Appropriateness Of Spreadsheets
• Practice Exercise
• Practice Exercise Workspace

At the completion of this course you should 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

Watsonia workbook with 228 topics. Files for the exercises are provided on a CD or can be downloaded here

Approximately 20 hours

• Excel 2016: Analysing and Summarising Data
• Excel 2016: Functions
• Excel 2016: Introduction
• Excel 2016: Introduction (Self-paced)
• Excel 2016: Managing Data & Lists
• Excel 2016: Recorded Macros
• Office 2016: Excel, Word and PowerPoint Top Ten Tips
• Office 365, Office Online and OneDrive: An introduction