Our Courses

« BACK TO OUR COURSES
Microsoft Excel

Who Should Attend?

On completion, participants will know their way around Excel. This workshop provides an understanding of different features of the interface, gives a brief overview of all the navigation options, covers some simple scenarios, and the basics of formatting. By the end of this course, users should be comfortable with creating a new spreadsheet, working with basic formulae, making their look professional and presentable, and saving and printing.

PREQUALIFICATIONS: This course assumes the user understands the basics of using a Windows-based computer. Students should be comfortable using the keyboard, mouse and Start Menu. No previous experience with any versions of Excel is necessary.

Microsoft Excel

Brochure

Related Training

Working Smart 365

Working Sm@rt in Meetings

Priority Planning

Project Planning Breakthroughs

INTRODUCTION
Excel is a spreadsheet application packaged with the Microsoft Office suite. It is a very powerful and flexible tool for organizing and analyzing data. Excel’s functionality and popularity have made it an essential component on computers in countless organizations, businesses, and other institutions throughout the world. Excel is comprehensive enough to meet the needs of beginners and experienced users. With Excel you can do a wide range of tasks, from building basic spread sheets, to performing advanced data analysis. If you start at the beginning and work your way up, it won’t be difficult to learn and work with Excel at any level you want. If you are new to Excel, the extensive array of features and capabilities that it provides may seem daunting at first, but don’t worry. The keys to becoming proficient with Excel are patience, practice, and a solid foundation built on the basics.

PREQUALIFICATIONS
This course assumes the user understands the basics of using a Windows-based computer. Students should be comfortable using the keyboard, mouse and Start Menu. No previous experience with any versions of Excel is necessary.

OUR WORKSHOPS INCLUDE

  • Extensive Learning & Reference Guides provided on USB
  • Refreshments and lunch at the workshop (at our venue)
  • Provision of a computer laboratory (if required)
  • Access to a Microsoft technical expert throughout and post the workshop

Unit 1

A FIRST LOOK AT EXCEL
  • The Excel Screen
  • About Toolbars
  • What is the Active Cell?
  • Entering Text and Numbers
  • Navigating within a worksheet
  • Saving a workbook
  • Closing a workbook
  • Creating a new workbook
  • Opening a workbook

Unit 2

FORMULAS AND FUNCTIONS
  • Creating formulas
  • Relative cell referencing
  • Absolute cell referencing
  • Sum function
  • Average function
  • Max function
  • Min function
  • Count function
  • Using a basic IF function

Unit 3

SPREADSHEET DATA
  • Entering Data
  • Formatting cells and text
  • Using auto-complete
  • Using Pick List
  • Checking the Spelling
  • Using Fill series
  • Hiding & Displaying
  • Selecting a range of cells
  • Selecting columns & rows

Unit 4

MANIPULATING WORKSHEETS
  • Switching between worksheets
  • Renaming a worksheet
  • Inserting a new worksheet
  • Deleting a worksheet
  • Copying a worksheet within a workbook
  • Moving a worksheet within a workbook
  • Colouring a worksheet tab
  • Inserting/Deleting rows & columns
  • Freeze panes
 

Unit 5

EDITING SPREADSHEETS
  • Cutting, Copying, And Pasting
  • Paste special function
  • Copying formulas
  • Using Find And Replace
 

Unit 6

CHARTS
  • Create a chart
  • Manipulate chart data
  • Format chart bars
  • Format colours & values

Unit 7

FONT FORMATTING
  • Font type and size
  • Bold, italic, underline formatting
  • Cell border formatting
  • Format background and font colour
  • Using Auto-format

Unit 8

NUMBER FORMATTING
  • Decimal point display
  • Comma formatting
  • Currency symbol
  • Date styles
  • Percentages