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
Booking / availability