Excel

Excel Introduction:

Work effectively with Excel learning shortcuts, quick and clever ways to enter data saving time. Understand and create basic formulas and charts.

Course Outline Excel Introduction 1 Day

Who is it for?

The course is suitable for those with little or no prior knowledge of Microsoft Excel and focuses on the basics of creating spreadsheets including entering and editing data, formatting spreadsheets, basic formulae, functions and charts.

Prerequisites

Delegates should have a basic knowledge of computers and working in a Windows environment.

Workbook Creation
A first look at Microsoft Excel:
  • Understanding the Screen layout
  • Opening, Closing & Saving data
Editing Features
Working with Sheets:
  • Enter & Edit Data
  • Insert and delete columns and rows
  • Cut/Copy & Paste
  • Page setup
  • Printing
  • autofill
Formatting
Formatting Text and Numbers:
  • Font Formatting
  • Borders and Shading
  • Number Formatting
Calculations
Formulae and Functions:
  • Basic calculations
  • Order of Precedence
  • Functions
  • Absolute Referencing
Charting
Creating and Editing Charts:
  • Basic Charting
  • Formatting Charts

Tags: Microsoft Excel, Software

About the Trainers

Qualifications - European Computing Driving License (ECDL) Microsoft Office Specialists (MOS) Microsoft Office User Specialist (MOUS), Microsoft Certified Applications Specialist (MCAS), 2 of our trainers have taken the Institute of Learning Management Train the Trainer Master Class Award. Every trainer has a minimum of 5 years training experience.

mpn

NC Member logo

Latest News

Windows 8 and 10

Windows 8 courses now available.

New courses for Microsoft Windows 10 will be available soon – be one of the first to see it with us.

MS Office Training

Microsoft Office weekend training and Microsoft Office 2013 upgrade training now available.

Testimonials

"This morning I set up a Macro (as per Thursday’s advanced course) and recorded the whole operation so I could apply to future reports downloads and ‘wow’ this has really saved so much time -thank you."

Iris Vicary, Telent

"After taking part in the intermediate and advanced excel courses I soon booked onto the word training. Nicola was both helpful and technical. The courses were just the right length and I would strongly recommend."

James Harris, Critchleys Chartered Accountants