Microsoft Excel 2016 for Beginners - Code Chiefs

Microsoft Excel 2016 for Beginners

Regular price £29.00 Sale

Unlimited Access

6 Units, 37 Activities and Labs

Certificate of Completion

Level 3 Equivilent Content

5+ Hours of Content


Course Description

Get started with Microsoft Excel 2016 with our Microsoft Excel 2016 for Beginners course. On this in depth course, topics you will learn include:

Getting started with Excel

Performing calculations

Modifying and formatting worksheets

Printing workbook contents

Managing large workbooks

Customising the Excel environment

Requirements

Our Microsoft Excel 2016 for Beginners course is fully compatible with any kind of device which is able to run Microsoft Office 2016. Whether you are using Windows computer, Mac, or Linux, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation.

Who is it for?

This Microsoft Excel 2016 for Beginners course is ideal for those students who want an introduction to MS Excel 2016, want to further develop thier skills or take their MS Excel knowledge to the next level.

Career path

After completing this Microsoft Excel 2016 course you will be able to build up accurate knowledge and skills with real confidence to up skill in your career.

Curriculum

Getting Started with Microsoft Excel 2016

 

  • Identify the Elements of the Excel Interface
  • Microsoft Excel 2016
  • What are Spreadsheets, Worksheets, and Workbooks?
  • What are Columns, Rows, Cells, and Ranges?
  • The Excel Interface
  • Navigation Options
  • Creating a New Blank Workbook
  • Creating a New Workbook from a Template
  •  
  • Create a Basic Worksheet
  • The Ribbon
  • The Backstage View
  • Data Types
  • Excel 2016 File Formats
  • The Save and Save As Commands
  • Saving to Microsoft OneDrive
  • Compatibility Mode
  • The Convert Option
  • The Compatibility Checker
  • Checking for Accessibility Issues
  •  
  • Use the Help System
  • Using Tell Me
  • Accessing Advanced Help Options
  • Summary
  • Review Questions

Performing Calculations

 

  • Create Formulas in a Worksheet
  • Excel Formulas
  • The Formula Bar
  • Elements of an Excel Formula
  • Common Mathematical Operators
  • The Order of Operations
  •  
  • Insert Functions in a Worksheet
  • Functions
  • The Function Library
  • Common Functions in Excel
  • The Formula AutoComplete Feature
  •  
  • Reuse Formulas
  • The Cut, Copy, and Paste Commands
  • Paste Special Options
  • Relative References
  • Absolute References
  • Mixed References
  •  
  • Summary
  • Review Questions

 

Modifying a Worksheet

 

  • Manipulate Data
  • The Undo and Redo Commands
  • The AutoFill Feature
  • AutoFill Options
  • The Transpose Option
  • Live Preview
  • The Clear Button
  •  
  • Insert, Manipulate, and Delete Cells, Columns, and Rows
  • The Insert and Delete Options
  • Column Width and Row Height Alternation Methods
  • The Hide and Unhide Options
  •  
  • Search For and Replace Data
  • Cell Names and Range Names
  • The Find Command
  • The Replace Command
  • The Go To Command
  •  
  • Spell Check a Worksheet
  • The Spelling Dialog Box
  •  
  • Summary
  • Review Questions

 

Formatting a Worksheet

 

  • Modify Fonts
  • Fonts
  • The Font Group
  • The Format Cells Dialog Box
  • The Format Painter
  • Galleries
  • Live Preview and Formatting
  • The Mini Toolbar
  •  
  • Add Borders and Colors to Cells
  • Border Options
  • Fill Options
  • Sheet Backgrounds
  • Paste Options
  •  
  • Apply Number Formats
  • Number Formats
  • Number Formats in Excel
  • Custom Number Formats
  •  
  • Align Cell Contents
  • Alignment Options
  • The Indent Commands
  • The Wrap Text Command
  • Orientation Options
  • The Merge & Center Options
  •  
  • Apply Cell Styles
  • Cell Styles
  • The Style Dialog Box
  •  
  • Summary
  • Review Questions

 

Printing Workbook Contents

 

  • Define the Basic Page Layout for a Workbook
  • The Print Options in Backstage View
  • The Page Setup Dialog Box
  • The Print Preview Option
  • Workbook Views
  • Headers and Footers
  • Header and Footer Settings
  • Page Margins
  • Margins Tab Options
  • Page Orientation
  •  
  • Refine the Page Layout and Apply Print Options
  • Zoom Options
  • Page Breaks
  • Page Break Options
  • The Print Area
  • Print Titles
  • Scaling Options
  •  
  • Summary
  • Review Questions

 

Managing Large Workbooks

 

  • Format Worksheet Tabs
  • Renaming Worksheet Tabs
  • Changing Tab Color
  •  
  • Manage Worksheets
  • Grouped Worksheets
  • Repositioning Worksheets
  • Inserting or Deleting Worksheets
  • Hiding and Unhiding Worksheets
  • Worksheet References in Formulas
  •  
  • Manage the View of Worksheets and Workbooks
  • The Split Command
  • The Freeze Panes Options
  • The Arrange All Command
  • The Arrange Windows Dialog Box
  • The View Side by Side Command
  • The Switch Windows Command
  • The New Window Command
  •  
  • Summary
  • Review Questions

 

Customizing the Excel Environment

  • Customize General and Language Options
  • The Excel Options Dialog Box
  • The General Category
  • The Language Category
  •  
  • Customize Formula Options
  • The Formulas Category
  •  
  • Customize Proofing and Save Options
  • The Proofing Category
  • The Save Category
  • Version Control
  •  
  • Customize the Ribbon and Quick Access Toolbar
  • The Customize Ribbon Category
  • The Quick Access Toolbar Category
  •  
  • Customize the Functionality of Excel by Enabling Add-Ins
  • What Are Add-ins?
  • The Add-Ins Category
  • The Developer Tab
  •  
  • Customize Advanced and Trust Center Options
  • The Advanced Category
  • The Trust Center Category
  •  
  • Summary
  • Review Questions

Extra Materials

  • Appendices
  • 10 Practical Labs
  • Keyboard Shortcut Quick Reference Sheet
  • Glossary

Certification

Courses featured on


Liquid error: Could not find asset snippets/eu-cookie-banner-app.liquid