Excel Introduction Course, Private 1-to-1, Live Online Classroom

Excel Introduction Course, Private 1-to-1, Live Online Classroom

Actions and Detail Panel

£150

During this one-day Excel course you will master the main features of Microsoft Office Excel. Instructor led. Practical. Online.

About this event

MICROSOFT EXCEL COURSE: INTRODUCTION, PRIVATE 1-TO-1, PC AND MAC VERSIONS 2007 UPWARDS

EXCEL COURSE SUMMARY

During this intensive one-day Excel course you will master the main features of Microsoft Office Excel. It is entirely ‘hands on’ and you will practice creating and modifying actual spreadsheets.

This course runs online via your internet connection and Gotomeeting.com

Course Outcome: 

Create a budget or financial model with formulae.

EXCEL COURSE OUTLINE

Getting Started with Excel: About Workbooks, Exploring your Workbook, Getting Help with Excel The Excel Ribbons and Menus: The Quick Access Toolbar and File Menu, The Home Tab, The Insert Tab, The Page Layout Tab, The Formulas Tab, The Data Tab, The Review Tab 

Excel Course Basics: Working with Excel, Basic Excel Features, Moving Data, Smart Tags and Options Buttons, Editing Tools Copying Data Inserting, Moving, Copying, Deleting sheets, Colouring sheettabs 

Editing your Workbook: Entering data, Modifying Cells and Data, Autofill Cell Formatting for Text, Number and Dates, Copy Formats Conditional Formatting 

Entering basic Formulae: Creating basic formulae, Popular functions (Sum, Min, Max, Avg, Count, Counta, CountBlank, If, Using the function wizard ) , reading and understanding existing formulae. Creating formulae on multiple sheets, sheet linking, file linking. 

Working with data sets: Sort, Filter, Find, Replace 

Printing and Viewing your Workbook: Using the View Tab, Managing a Single Window, Managing Multiple Windows, Printing your Workbook 

WHAT IS INCLUDED:

  • Excel Course Certificate on completion (assessment based) 
  • Excel Course notes 
  • Practical Class Excel Course exercises, Excel Course Homework / Excel Course Revision work 
  • To assist after the course, 1 free session for questions online.

Share with friends