Excel 2007 Essentials

Improve your understanding in the essentials of Excel 2007…

This course will show you how to do more with your data, including adding graphics (such as SmartArt and PivotTables) and performing advanced data analysis. This course is a must-have for anyone who works with Excel on a daily basis.

Course delivery method: – online tutorial or 1-day corporate workshop
This Course is just 1 of the 43 in our ‘Skills, Strategies and Solutions Series’ of:

  • Online Tutorials
  • Corporate Training Programs – Soft Skills Collection

So, Register NOW, gain instant access and start straight away…

How to register get started straight away:
Click ‘register’ and follow the prompts on the screen


Excel 2007 Essentials Course Outline:

Module One: Getting Started

  • Icebreaker
  • Housekeeping Items
  • Pre-Assignment Review
  • Workshop Objectives
  • Action Plans And Evaluation Forms

Module Two: Opening And Closing Excel

  • Opening Excel
  • Understanding The Interface
  • Understanding Worksheets
  • Understanding Workbooks
  • Closing Excel

Module Three: Your First Worksheet

  • Entering Data
  • Using The Wrap Command
  • Editing Data
  • Adding Rows And Columns
  • Checking Your Spelling

Module Four: Working With Excel Files

  • About the New File Format
  • Saving Files
  • Publishing Files To PDF
  • Sending Files via E-Mail
  • Opening Files

Module Five: Viewing Excel Data

  • An Overview Of Excel Views
  • Switching Views
  • Using Zoom
  • Switching Between Open Files

Module Six: Printing Excel Data

  • An Overview Of The Page Layout Tab
  • Setting Up Your Page
  • Using Print Preview
  • Printing Data

Module Seven: Building Formulas

  • The Math Basics Of Excel
  • Building A Formula
  • Editing A Formula
  • Copying A Formula
  • Relative vs Absolute Referencing

Module Eight: Using Excel Functions

  • Formulas vs Functions
  • Understanding The Formulas Tab
  • Using The SUM Function
  • Using Other Basic Excel Functions
  • Using The Status Bar to Perform Calculations

Module Nine: Using Time Saving Tools

  • Using AutoSum
  • Using AutoFill
  • Using AutoComplete
  • Sorting Data
  • Filtering Data

Module Ten: Formatting Your Data

  • Changing The Appearance Of Your Text
  • Changing The Appearance Of Numbers
  • Setting Alignment Options
  • Changing Cell Size
  • Using The Merge Command

Module Eleven: Working With Colors

  • Adding Borders
  • Adding Shading
  • Using Cell Styles
  • Using The Format Painter
  • Using Conditional Formatting

Module Twelve: Wrapping Up

  • Words from the Wise
  • Parking Lot
  • Action Plans and Evaluations

Enrolment Process

You can enrol and start on your course today!

1. Click the ‘Enrol Now’ tab to begin the buying process.

2. Your cart will show that you can buy more than one copy of this course. You can add other courses by going to back to the courses page and selecting another course of your choice. Click add to cart to add a new course to your purchase. Click ‘proceed to checkout’ on the right hand side of the page, when you have finished shopping.

3. The next page will display your order information. Click next to continue.

4. If you are a new customer you need to register an account under the registration column. NB. Make sure you remember your username and password as this information grants you access to your online tutorial (course). If you are an existing member (customer) of Global Training Institute, you can login on the left side of the page. Click next to go to the payment page.

5. On this page you can choose your payment method, either bank transfer or PayPal (Accepts credit card or your PayPal account). Read the terms and conditions and check the box. You will receive an order invoice in your email inbox. Click next to continue.

6. You will be redirected to PayPal, where you can complete the payment process.

7. Your course will be approved within our next office day and an email will be sent to confirm your course is online and available for you to commence.

8. Enjoy your online training experience and we trust that you will gain new skills and knowledge through doing your tutorial.

Start today!

Click the Button Below to enrol in a Short Course and start today!

Enrol Now



How long does the course take?

1 week with (24 months access) depending how much time you can allocate to completing your Short Course

Online Prerequisites

  • Computer Pc or Mac
  • Google Chrome or Firefox 10+
  • Internet Connection
Payment Options