Excel-2010-Advanced

Excel 2010 Advanced

Improve your understanding in the advanced abilities of Excel 2010…

Excel is the world’s premier spreadsheet software. You can use Excel to analyze numbers, keep track of data, and graphically represent your information. With Excel 2010, you can manage more data than ever, with increased worksheet and workbook sizes. Excel also makes your job easier by providing an easy to use interface, and an array of powerful tools to help you turn your data into useable information – and better information leads to better decision making!

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 2010 Advanced Course Outline:

Module One: Getting Started

  • Workshop Objectives

Module Two: SmartArt and Objects

  • Inserting SmartArt
  • Adding Text to the Diagram
  • Resizing and Moving the Diagram
  • Resetting the Diagram
  • Adding Pictures from Your Computer
  • Adding Clip Art
  • Adding Text Boxes
  • Drawing Shapes
  • About the Contextual Tabs

Module Three: Auditing

  • Tracing Precedent Cells
  • Tracing the Dependents of a Cell
  • Displaying Formulas Within the Sheet
  • Adding, Displaying, Editing, and Removing Comments

Module Four: Inserting a Chart

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

Module Five: Creating Pivot Tables

  • Inserting a PivotTable
  • Choosing Fields and Grouping Data
  • Overview of the Pivot Table Tools Tabs

Module Six: Working with PivotTables and PivotCharts

  • Changing the Data Displayed and Refreshing the PivotTable
  • Applying a Style to Your Pivot Table
  • Creating a Pivot Chart from a Pivot Table
  • Creating a Pivot Chart from Data
  • Some Real-life Examples

Module Seven: Macros

  • Displaying the Developer Tab
  • Recording and Running Macros
  • Changing the Security Level
  • Customizing and Changing the Quick Access Toolbar

Module Eight: Solving Formula Errors

  • Using Named Ranges
  • Understanding Formula Errors
  • Using the Trace Errors Commands
  • Using Error Checking
  • 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