Microsoft Excel 2016 - Level 1 Essentials

MDIS


Course introduction

Excel is very much more than just a spreadsheet. In the very real sense of the word, Excel is a “number-cruncher”, the likes of which have only been equalled by Lotus 1-2-3 and which it has now surpassed. From humble beginnings, Excel has developed to become the spreadsheet everyone uses, be it simple home accounting to modular solutions in major corporations.



Course Benefits


Upon completion of this workshop, participants will be able to;

  • Forms an excellent formal introduction to Microsoft Excel
  • Learn the art of number crunching in a spreadsheet
  • Be familiar with the workings of Excel
  • Be able  to confidently produce spreadsheets and calculated totals



Target Audience


Anyone who works with numbers and are seeking to present them in a coherent, tabulated format for analysis.



Course Outline


Module 1: Excel Basics

  • Interface, Ribbon & Quick Access Toolbar
  • Using the File Tab
  • Opening & Saving Excel Files
  • Spreadsheet Layout & Navigation
  • Getting Help
Module 2: Data Entry
  • Selecting Cells
  • Entering, Editing & Deleting Data
  • Data Entry Shortcuts
  • Moving & Copying Data
  • Using Paste Options
Module 3: Worksheets & Workbooks
  • Workbook Organisation
  • Worksheet Organisation
Module 4: Formatting
  • Columns & Rows
  • Text Formatting
  • Alignment, Wrapping and Indentation
  • Numbers
  • Borders & Shading
  • Clearing Formatting
  • Applying Cell Styles
  • Using the Format Painter
  • Working with Themes
  • Using Conditional Formatting
  • Formatting & Applying Table Styles
  • Formulas & Functions
  • Formulas in Excel
  • Functions
Module 5: Charts
  • Introduction to Charts in Excel
  • Building Basic Charts
  • Chart Editing & Formatting
  • Working with Quick Analysis
  • Inserting Sparklines
Module 6: Printing
  • Print Options
  • Print Preview
  • Printing Charts
Module 7: Templates
  • Using Templates
  • Creating & Modifying Templates
  • Saving on Existing Workbook as a Template
Module 8: Protections
  • Overview of Data Protection
  • Locking & Hiding Cells
  • Setting Spreadsheet Passwords
  • Worksheet & Workbook Protection
  • File Protection



Available Course Sessions


Please click here to stay updated on upcoming sessions.



Trainer Profile


Microsoft Certified Trainer

All of our Associate Trainers offer our high level of service therefore are subject to regular peer assessments and interview prior to joining our Institute. They must all be qualified and have relevant experience to an agreed level and are subjected to continual audit and evaluation. Strict internal assessment is implemented as an integral part of our quality control mechanism.



 

Top