Menu
Menu
  • No products in the basket.

MS Excel 2007 Essentials Online Course

4.5( 2 REVIEWS )
398 STUDENTS
ACCREDITED BY
MS Excel 2007 Essentials Online Course

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:

Key Features

Gain an accredited UK qualification

Access to excellent quality study materials

Learners will be eligible for TOTUM Discount Card

Personalized learning experience

One year’s access to the course

Support by phone, live chat, and email

Course Curriculum Total Units : 72
1: WORKING WITH THE USER INTERFACE
1. Introducing the Ribbon User Interface
2. Introducing Workbooks & Worksheets
3. Introducing the Formula Bar
4. Saving with Different File Extensions
5. Customizing the User Interface
2: ENTERING & MANAGING DATA
1. Getting Data into Excel
2. Importing Text Files
3. Using the Freeze Panes Functionality
4. Using the Zoom Functionality
5. Using Hot Keys
6. Managing Rows & Columns
7. Finding Data
8. Matching Case & Entire Cell Contents
9. Replacing Data
10. Finding & Replacing Empty Values
11. Sorting Data
12. Sorting Multiple Columns
13. Filtering Data
3: USING FORMATTING TECHNIQUES
1. Formatting Numbers & Dates
2. Formatting Cells
3. Setting the Font Type, Color & Size
4. Using Borders & Cell Styles
5. Adding Shapes & Pictures
6. Creating WordArt
4: FORMULA BASICS
1. Constants, Formulas & Cell References
2. Understanding the Order of Operations
3. Using Formulas with Dates & Text
4. Linking Cells & Using Comparison Operators
5. Creating an Absolute Reference
6. Defining Named Ranges
7. Exploring the Function Library
8. Using the AutoSum Function
5: USEFUL FUNCTIONS
1. Using the INT Function
2. Using the Rounding Function
3. Using the ABS Function
4. Using the SUBTotal Function
5. Using Logical Functions
6. Using the AND & the OR Function
7. Using LEFT, RIGHT & MID Functions
8. Using the UPPER, LOWER, PROPER & TRIM Functions
9. Using COUNT Functions
10. Using the VLOOKUP Function
6: CREATING REPORTS
1. Creating a Subtotal Report
2. Using Conditional Formatting
3. Creating & Managing Conditions
4. Creating a Chart
5. Refining Charts
6. Using Basic Chart Types
7: SHARING & DISTRIBUTING YOUR WORK
1. Inserting Headers & Footers
2. Adding Comments
3. Adjusting Page Layout
4. Distributing Your Worksheets
5. Protecting Your Worksheets
6. Understanding Compatibility
8: TIPS & TRICKS
1. Using the Fill Handle
2. Filling in a Series of Numbers
3. Typing in Multiple Cells at Once
4. Leveraging a Custom List & Transposing a Range
5. Deleting & Inserting Blank Cells
6. Filling Holes in Your Data
7. Getting a List of Unique Records & Parsing Text
8. Rearranging Columns & Linking to Multiple Cells
9. Using Right Mouse Button Drag Options
10. Make Format Painter Persist & Paste Special Formats
11. Formatting Portions of Text & Multiple Sheets
12. Creating Cell Border Effects & Sorting on Color
13. Turning Formulas into Hard Data
14. Copy Formula References & Highlight Formulas
15. Creating Dynamic Charts & Combination Charts
16. Add a Secondary Axis, Average Line & Smooth Line
17. Comparing Data Dynamically with Charts
18. Final Comments & Credits
WhatsApp chat