Microsoft Excel 2016 Introduction course, Test and Millionaire Game
Bite Size Ltd
Online self paced course
Summary
- Certificate of completion - Free
Add to basket or enquire
Overview
Certificates
Course media
Description
Getting Started
- Spreadsheet Terminology
- Creating, Saving and Closing Workbooks
- Switching Between Open Windows
- The Excel Environment
- Getting Help
- Navigating a Worksheet
- The Ribbon
Working with Data
- Entering Data
- Selecting Data
- Copying and Moving Data
- Editing Cells
- Find and Select
- Creating Custom Lists
- Working with Comments
Working with Columns and Rows
- Managing Columns and Rows
- Inserting Columns and Rows
- Deleting Columns and Rows
Worksheets
- Insert or Delete a Worksheet
- Copying and Moving Worksheets
- Managing WorkSheets
FormulaeandFunctions
- Understanding Formulas
- Order of Calculation
- Entering and Editing Formulas
- Moving and Copying Formulas
- Absolute and Relative Cell References
- Using Autosum
- Sum Function
- Min and Max Function
- Average Function
- Count Function
Formatting
- Font Formatting
- Font Alignment
- Text Wrapping
- Merge and Centre Data
- Text Orientation
- Formatting Numbers and Dates
- Conditional Formatting
- Cell Styles
- Format Painter
Charts
- Chart Basics
- Formatting Charts
- Recommended Charts
Preparing to Print
- Print Preview
- Page Break preview
- Page Setup Options
- Printing Worksheets
- Setting Up Print Areas
- Spell Check
Who is this course for?
This course is aimed at those who are new to working with Microsoft Excel.
Requirements
Computer, internet access and the enthusiasm and hunger to learn!
Career path
This course will give you the confidence to use MS Excel. Other suitable courses from our library are MS Excel Intermediate, Advanced, Master and Expert courses.
This course is included in our full Microsoft Office Library - take a look at our Bite Size MS Office Bundle.
Questions and answers
There are currently no Q&As for this course. Be the first to ask a question.
Reviews
Currently there are no reviews for this course. Be the first to leave a review.
Sidebar navigation
Legal information
This course is advertised on Reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.