Microsoft Excel 2007: Essentials

Overview

This video training series begins with the simplest tasks and progresses to more difficult projects. Along the way, you will pick up tips and tricks of savvy Excel users. If you have ever wanted to learn how to use Excel to create better spreadsheets and improve spreadsheet analysis, now is the time!

Learning with Study 365 has many advantages. The course material is delivered straight to you and can be adapted to fit in with your lifestyle. It is created by experts within the industry, meaning you are receiving accurate information, which is up-to-date and easy to understand.

This course is comprised of professional learning material, all delivered through a system that you will have access to 24 hours a day, 7 days a week for 365 days (12 months).

Course Curriculum

1: Working With The User Interface

2: Entering & Managing Data

3: Using Formatting Techniques

4: Formula Basics

5: Useful Functions

6: Creating Reports

7: Sharing & Distributing Your Work

8: Tips & Tricks

Who is it for?

• Job seekers
• Graduates
• Administrators
• PA professionals
• Accountants
• Bookkeepers
• Business Owners

Course Duration:

From the day you purchase the course, you will have 12 months access to the online study platform. As the course is self-paced you can decide how fast or slow the training goes, and are able to complete the course in stages, revisiting the training at any time.

Method of Assessment: 

At the end of the course, you will have one assignment to be submitted (you need a mark of 65% to pass) and you can submit the assignment at any time. You will only need to pay £19 for assessment and certification when you submit the assignment. You will receive the results within 72 hours of submittal, and will be sent a certificate in 7-14 days if you have successfully passed.

Certification:

Successful candidates will be awarded a certificate for Excel 2007: Essentials.

Presenter Information:

Michael Alexander is a Microsoft Certified Application Developer (MCAD) with over 14 years’ experience consulting and developing office solutions.  Michael started his career in consulting and development at the White House Communications Agency in Washington DC where he spearheaded the development of a standalone HRIS system for the White House’s Military Office. He parleyed his experience with VBA and VB into a successful consulting practice in the private sector, developing middleware and reporting solutions for a wide variety of industries.

He currently lives in Frisco, TX where he serves as a Senior Program Manager for a top technology firm.  Michael is the author of several books on Microsoft Access and Excel, and is the principle behind DataPig Technologies where he shares basic Access and Excel tips to the Office community.