Excel 2007: Essentials

Overview:

During this excellent Excel 2007: Essentials course is intended to give you a solid understanding of how to use Excel 2007. If you’re a beginner level user of Excel 2007, or if you’ve just updated to Excel 2007, then this course contains all the information you need, and it will help you to get up to speed with simple tasks and the more difficult projects that can be undertaken using Excel 2007. Learners of this Excel 2007: Essentials course will be taught by an expert instructor who has years of experience and tons of insider tips and tricks to share with you. Be guided through all the essential features of Excel 2007, like how to create better spreadsheets and improve your spreadsheet analysis.

Our courses couldn’t be more convenient, 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).

What skills will I learn?

• Learn to work with the Excel 2007 interface
• Learn to input data into Excel 2007
• Learn to find data, sort multiple columns, and import text files
• Learn to match case and entire cell contents

Meet the instructor:

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.

Course outline:

• Module 01: Working with the User Interface
• Module 02: Entering & Managing Data
• Module 03: Using Formatting Techniques
• Module 04: Formula Basics
• Module 05: Useful Functions
• Module 06: Creating Reports
• Module 07: Sharing & Distributing Your Work
• Module 08: Tips & Tricks

What are the requirements?

• You must be 16 or over
• You should have a basic understanding of English, Maths and ICT
• You will need a computer or tablet with internet connection (or access to one)

How will I be assessed?

• You will have one assignment. Pass mark is 65%.
• You will only need to pay £19 for assessment.
• You will receive the results within 72 hours of submittal, and will be sent a certificate in 7-14 days.

Certification:

Those who successfully pass this course will be awarded a Excel 2007: Essentials certificate. Anyone eligible for certification will receive a free e-certificate, and printed certificate.

Career Path:

This excellent Excel 2007: Essentials course will qualify you to be an Executive Assistant. As an Executive Assistant you’ll usually be working in an office as part of a team, you’ll work under more senior members of staff and can work your way up the company, so pay will go up with experience. The average salary of an Executive Assistant in the UK is £30,627, and this will go up with experience (payscale.com). With this course you could fulfil any of the following roles:

• Executive Assistant
• Office Assistant
• Accounts Assistant
• Administrator
• PA