COURSE :

Microsoft Excel for Business Professionals

Overview

This course is designed for new or basic Excel users. The course will cover all aspects of creating new spreadsheets, including Excel calculations, printing, formatting and basic list management.

Course Duration:
This is a 1-day Excel Intermediate Course. Course starts at 09:00 and runs until 17:00.

Enquiry Us Now

COURSE OUTLINE

Excel Basics

– An overview of the screen, navigation and basic spreadsheet concepts
– Understand Excel terminology workbooks, worksheets, rows, columns, cells
– Various selection techniques
– Understanding the various mouse cursors
– Working with Ribbon Tabs, Groups and Dialog Boxes
– Standard and Contextual ribbons
– Use the task pane
– Understand and use the File Tab
– Saving, File types, File compatibility (earlier versions)
– Useful keyboard commands
– Quick Access Toolbar & Mini Toolbar
– Get Help!

Entering Data

– Various ways to Enter, Edit and Delete information (Text, Numbers, Dates)
– Use Auto List feature
– Date and Time are storage in Excel
– Enter Dates and Times
– Date / time formatting
– Methods to Move and Copy data
– Use the Fill Handle to copy data and create simple lists
– Create series of information
– Insert, Delete and Hiding Rows & Columns
– Insert, Delete and Move Cells
– Insert, Delete, Move and Copy Sheets
– Various navigation techniques

Creating & Editing Formula & Functions

– Define Formula
– Create & Edit Formula
– BODMAS : Mathematical Order
– Copy & Move Formula
– Use Basic Functions – Sum, Average, Max, Min, Count, Counta
– Use Autosum tool
– Introduction to the Function Library
– Reference a cell in other sheets
– Understand Relative Referencing
– Apply Absolute (Fixed) Referencing

Formatting and Proofing

– Formatting of Cells with Number formats, Font formats, Alignment, Borders, Fill colours and Patterns
– Quick formats and themes
– Sheet tab formatting and Renaming
– Copy and Clear Formats
– Merging cells
– Spell Check, Find & Replace and AutoCorrect

Printing and Page Setup

– Page Orientation
– Add Headers and Footers
– Print a selection
– Set a print area
– Clear a print area
– Shrink to Fit
– Adjust page breaks within Page Break Preview
– Repeat columns and rows
– Print Grid-lines
– Save print settings

Multiple File & Large Workbook Tools

– Split screen tool
– Freeze panes
– Arrange workbook windows
– Zooming tools
– GoTo tool
– Name box navigation