Excel 2010 Advanced for Dummies

Course Introduction

Take your existing knowledge of Microsoft Excel 2010 and jump right into this advanced course, designed to help even the most timid learner become an expert spreadsheet designer. Offering a truly interactive guide to the more intricate skills of spreadsheet construction and programming, this course is perfect for those looking to update their skills in the workplace and rise to new heights in a competitive job market.

Excel 2010 has become an integral part of everyday business, and is now a leading tool for word processing in homes and workplaces all around the world. Learners will greatly improve their skills through this comprehensive self-paced study course, professionally crafted in the ‘For Dummies®’ style to be meaningful, accessible and fun.

Become an expert user with these advanced lessons showing you how to use advanced formatting, calculations and programming. Become proficient in constructing tables with conditional formatting for easy access to the data you require, and go a step further to construct Pivot Tables to summarise large data sets. Also, learn to work faster and smarter by programming your own in-program macros and assigning hotkeys.

By far the most popular part of this course according to past students is our emphasis on utilising the little-known tools and tricks to get better results from less effort. Learn the shortcuts that IT professionals use to maximise their efficiency, and see just how much time and energy you will save.

Key Learning Points

This advanced course assumes that the learner already has a grasp on using Microsoft Excel 2010 to create, save and edit simple spreadsheets. With these basics already under your belt, this course will empower you to use the more sophisticated tools embedded in the software.

Some of the topics covered are:

Editing and Formatting Functions:

• Altering the look of cells and tables.
• Printing with headers and footers.
• Conditional formatting based on a cell’s contents.
• Advanced table management.
• Inserting charts and images.

Advanced Functions:

• Using the Styles bar for professional formatting.
• Hiding unnecessary data, both manually and using Filters.
• Importing and exporting data.
• Simple formulas.
• Tracing precedent and dependent cells and error-checking.
• Protecting documents with password encryption.

Programming Functions:

• Advanced formulas.
• Constructing database-like reports using Pivot Tables.
• Developing personalised macros for the ultimateConstructing database-like reports using Pivot Tables.
• time-saving shortcuts.
• Adding macros to the toolbar.
• Assigning personalised hotkey functions.

This is just a sample of the comprehensive instruction included in this course, comprising expert instruction supported by activities, real world examples and interactive self-tests. Not only will you test your knowledge, you’ll be given the opportunity to each step out for yourself with structured challenges to tackle at your own pace. This advanced course will guide you in each step to becoming a true spreadsheet expert.

Advantages of this course

• Learn work-ready skills for administrative jobs and other computer-based employment.
• Gain all the skills required for MOS certification, the world’s most recognised qualification in Microsoft Office applications (available through us).
• Learn to use Excel for every purpose; planning, budgeting, data collation, reporting and analysis.
• Become the spreadsheet expert in your home or office.
• Develop confidence to tackle even the most complex spreadsheet design tasks.
• Improve efficiency using Microsoft Excel 2010 at home or in the office.
• Professional skills taught by professional educators.
• Self-paced study, with up to 12 months to complete the course.

• Units of study

• Using advanced formatting techniques to make your Excel data easier to read and understand
• Tackling common financial chores such as calculating loan payments and interest
• Applying Excel's tools for sophisticated data analysis
• Calculating math, statistical, and text functions such as exponentiation and square roots, sines, cosines, and tangents
• Creating and formatting PivotTables and PivotCharts
• Correcting, protecting, and sharing the data in your workbooks