Excel-2007-Advanced

Excel 2007 Advanced

Improve your understanding in the advanced abilities 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 Advanced Course Outline:

Module One: Getting Started

  • Workshop Objectives

Module Two: SmartArt

  • Inserting SmartArt
  • An Overview of the SmartArt Tabs
  • Adding Text to the Diagram
  • Resizing and Moving the Diagram
  • Resetting the Diagram

Module Three: Inserting Objects

  • About Contextual Tabs
  • Adding Pictures from Your Computer
  • Adding ClipArt
  • Adding Text Boxes
  • Drawing Shapes

Module Four: Creating Charts

  • Inserting a Chart
  • Overview of the Chart Tools Tabs
  • Understanding the Parts of a Chart
  • Changing the Chart Style
  • Resizing and Moving the Chart

Module Five: Creating Pivot Tables

  • Inserting a Pivot Table
  • Overview of the Pivot Table Tools Tab
  • Choosing Fields

Module Six: Working with Pivot Tables

  • Changing the Data Displayed
  • Applying a Style to Your Pivot Table
  • Some Real-life Examples

Module Seven: Creating Pivot Charts

  • Creating a Pivot Chart from a Pivot Table
  • Creating a Pivot Chart from Data

Module Eight: Solving Formula Errors

  • Using Named Ranges
  • Understanding Formula Errors
  • Tracing Dependents and Precedents
  • Using the Trace Errors Commands
  • Evaluating Formulas

Module Nine: Using What-If Analysis

  • Using Goal Seek
  • Using the Scenario Manager
  • Using a One Input Data Table
  • Using a Two Input Data Table

Module Ten: Managing Your Data

  • Transposing Data from Rows to Columns
  • Using the Text to Columns Feature
  • Checking for Duplicates
  • Creating Data Validation Rules
  • Consolidating Data

Module Eleven: Grouping and Outlining Data

  • Grouping Data
  • Adding Subtotals
  • Outlining Data
  • Viewing Grouped and Outlined Data

Module Twelve: Wrapping Up

  • Words from the Wise

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

 

 

$37