Microsoft Excel - Foundation

If you work in an office, chances are you use Microsoft Excel frequently. In fact, you may spend a whole day working on one workbook with its various spreadsheets. Discover how Microsoft Excel training can help you to increase your productivity by mastering the tips and tricks to reduce the amount of time you take to complete a task.

Course Objectives:

Building knowledge and developing your skill with the aim of finishing with a spreadsheet set
up just how you want it.
Saving time and simplify work, thus boosting your staff work productivity.
Helping you and your organization making better, smarter decisions.
Learning the tips and shortcuts.

Venue

In-House Training

Who Should Attend:

Individuals who are new to Microsoft Excel or have limited spreadsheet experience

Pre-requisite before Attending the Class

Individuals should have an understanding of any of the following operating systems: Windows 98/NT/2000/ME/XP/VISTA

Learning Methodology:

Instructor-led Training
Group Discussion
Hands-On
Exercises

Duration:

1 day (9:00am to 5:00pm)

Courses Outline

Using Excel 2010 / 2013

The Excel Cell Referencing System
Summing a Column of Numbers
Enter Dates
Worksheets and Workbooks
Saving a Workbook
Creating a New Workbook
Opening a Workbook
Switching between Workbook
Help

Manipulating Rows and Columns

Inserting Rows & Columns
Deleting Cells, Rows, and Columns
Column Width
Row Height

Worksheets

Renaming a Worksheet
Inserting a New Worksheet
Deleting a Worksheet
Moving and Copying Data between Worksheets

Alignment Formatting

Aligning Cell Contents
Centring a Title Over a Cell Range
Cell Orientation
Text Wrapping
Format Painter

Freezing Row and Column Titles

Freezing Row and Column Titles

Working with Functions

SUM Function
AVERAGE Function
MAX Function
MIN Function
COUNT Function
The COUNTA Function
The COUNTBLANK Function
Using the IF Function

Customizing Excel

Modifying Excel Options
Minimising the Ribbon
Autocorrect Options

Selection Techniques

Selecting a Cell, Cell Range, Row & Column

Manipulating Cells and Cell Content

Copying a Cell or Range Contents
Deleting Cell Contents
Moving the Contents of a Cell or Range
Editing Cell Content
Undo and Redo
AutoFill
Sorting

Font Formatting

Font Type
Font Size
Bold, Italic, Underline
Cell Border Formatting
Background Colour
Font Colour

Number Formatting

Decimal Point Display
Comma Style Formatting
Currency Symbol
Percentages

Working with Formulas

Creating Formulas
Copying Formulas
Operators
Using Operators in Formulas
Formula Error Messages
Relative Cell Referencing
Absolute Cell Referencing

Working with Charts

Inserting Different Chart Types
Resizing and Deleting a Chart
Chart Title or Labels
Chart Styles
Column, Bar, Line or Pie Slice Colours
Moving Charts

Require more support than our training courses?

Our full range of services can help you in many ways:

Custom Courses

We can work with you to deliver a tailored made course for your staff, not only in Microsoft Excel, but also PowerPoint, Word and other Microsoft Office software

Standard Business Documents

We can work with you to design standard business documents in Microsoft Excel, Word, and PowerPoint, making it quick and easy to produce professional, branded, stunning business documents

Automated Reporting

Unsure if Microsoft Excel gives you the information you need to run your business? We can design, develop and generate monthly reports in easily accessible formats such as PDF, giving you the information at your fingertips to run your business – no more days wasted in incomprehensible data reports

What You Can Expect From Our Course

Qualified Trainer

Our trainer is a Microsoft Office 2010 Master Specialist and well-sought after Microsoft Certified Trainer with more than 15 years of experience. He has conducted hundreds of Microsoft Office application classes with leading companies in the region and gets excellent ratings for
all his classes.

Small Class Sizes

We limit the number of participants to 15 pax per session. This means that participants will become more productive immediately after the training session.

Solutions

Real answers and solutions to your issues, not off the shelf training.