Microsoft Office 2010 Excel (Fundamentals)

Printer-friendly version
Vendor: 
Subject: 
Course Contents: 

Key Learning Outcomes

1.Productivity Booster – working with speed and familiarity in spreadsheets
Effectiveness booster -Using the new interface – installing or locking commands to the Ribbon Quick Access toolbar
Important concepts to increase your productivity – adjacent and non-adjacent selections, date and time shortcuts, etc.

2.Understanding and managing data, data linking, and formulas
Understanding data types, data integrity and errors in data
Managing data with Data filters, Data sort methods – by value and by colour
Understanding key concepts in formula building – data referencing, referencing constants, correctly using arithmetical operators
Good practice in cell referencing – Relative and Absolute References

3.Understanding and building formulas with Functions
Introduction to Functions and the function library buttons
Introducing key functions – Min, Max, Average
Logical functions – the versatile and widely used IF function

4.Charting – towards professionalism in charts
Key charting concepts – important chart types and variants
Key concepts – understanding chart components for effective charting
Building professional charts by formatting key chart components – Chart Area, Plot Area, Data Series. Data Labels, and more

Notes:

The workshop will be carried out in a highly interactive manner, and depending on time, may have many more tips and tricks covered. We reserve the right to make modifications to the course coverage depending on participant level and time available.
Microsoft Excel for PC, Version 2010 will be used in the demonstration of techniques of this workshop. Participants may use version 2007 as well though differences in capability may exist in some modules. While participants are welcome to work with versions prior to 2007 or non-PC versions, some procedures and shortcuts vary and in the interest of clarity, the workshop demonstration may not be able to include them all.

Objective: 

This workshop focuses on some of the issues that novice users face when working with Excel with the objective of accelerating the progression to a proficient user. Specifically this workshop introduces key concepts in formula building that are geared towards increasing speed and productivity in data analysis and in compiling and distributing reports. The workshop also introduces important areas of spreadsheet usage that are logical next steps in spreadsheet proficiency.

Prerequisites: 

Participants should have a minimum introductory knowledge of Microsoft Excel – opening a spreadsheet, creating a new spreadsheet, saving files, entering data, formatting and printing.

This is a HANDS-ON workshop. Participants are expected to bring their own laptop computers. A mouse is not essential but good to have. Please note the software requirements mentioned under Notes above.

Benefits: 

7 hours of hands-on instruction which will familiarize you on fundamental and core techniques in Microsoft Excel, designed to get a novice user up and running with a minimum time to productivity;including many of the newer features introduced since version 2007.

Audience: 

Any regular business user or student who is a novice user of Microsoft Exceland wishes to become productive in Excel in a short time frame

Duration: 
8 hours
For more information on Microsoft Office 2010 Excel (Fundamentals) please feel free to contact us online or call us at 416-513-1535.