Microsoft Excel 2016 - Level 1 Essentials

MDIS


Course introduction

Microsoft’s Excel is more than just an online spreadsheet. From its humble beginnings, the Excel program is now the main online spreadsheet employed by everyone. Be it simple home accounting to modular solutions in major corporations, Excel is used by everyone everywhere on an everyday basis. For anyone who works with numbers and are seeking to present them in a coherent, tabulated format for analysis, this Excel course is for you. After attending our Excel course physically or online, participants will be familiar with the workings of Excel and confidently produce spreadsheets and calculated totals.

No prior knowledge of Microsoft Excel is required for this course here in Singapore. However, participants will need to be familiar with basic operations of a PC, such as using a mouse and managing of program files and folders. A combination of lectures, explicit teaching, practical demonstrations, and peer teaching are applied to deliver this Excel course.



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