Excel 2010 Advanced Online Certificate Course

Learn How To Become a Competent Everyday User of Excel

Excel 2010 Advanced Online Certificate Course

NOW ONLY

AU$199

Save AU$70 (26%)
OFF RRP AU$269
or 4 interest-free payments of $49.75 with Learn more
Get Info Pack

Learn How To Become a Competent Everyday User of Excel

Part 1 : Getting the Most from Your Data

To begin, participants will learn about Excel's automatic grouping, outlining, and subtotaling features. Participants will also explore the Scenario Manager, data analysis tools, add-ins, one and two data input tables, goal seek, and Solver. The section will conclude with a discussion on hyperlinks.

Part 2 : Pivoting Data

This section focuses on one of Excel's most powerful tools: PivotTables. Participants will explore all aspects of PivotTables, including creating a PivotTable; using the contextual tabs; pivoting, summarizing, and analyzing data; formatting the PivotTable; and using external data with a PivotTable. This section also includes information on Slicers (a new feature that lets users analyze and interpret pivoted data with ease) and the classic PivotTable frame (used in Excel 2003 and earlier). The session will conclude with a comprehensive introduction to integrating data with PowerPivot and creating a PivotTable from that data.

Part 3 : Charting Pivoted Data

In this section, participants will learn how to create, use, edit, and format PivotCharts. Participants will also get experience with advanced PivotChart tasks, including creating a PivotChart from PowerPivot data and using PivotCharts to display scenario results.

Part 4 : Advanced Excel Tasks

The next section of this manual will explore a few Excel features that we find handy for everyday chores. First, advanced functions (PMT, FV, VLOOKUP, and HLOOKUP) and logical functions (IF, IFERROR, AND, OR, NOT, FALSE, and TRUE) will be covered. Then, AutoFill lists (which can save time when entering data) will be discussed. The section will conclude with information on linking, consolidating, and combining Excel data, with a final lesson on using the classic PivotTable and PivotChart wizard to pivot consolidated data.

Part 5 : Macros, Visual Basic, and Excel Programming

The final section of this manual will explore how to automate Excel tasks with macros. We will cover recording, running, and editing both basic and relative reference macros. Information on assigning a keyboard shortcut to a macro and managing macro security is also included. Then, Visual Basic tasks will be covered, including copying macros, using the Visual Basic Editor, declaring variables, iterating over a range, prompting for user input, and using conditional (If'_Then'_Else) statements.

Course Fast Facts:

  1. Easy to follow and understand
  2. Only 6 to 8 hours of study is required
  3. Unlimited, lifetime access to online course
  4. Delivered 100% on-line and accessible 24/7 from any computer or smartphone
  5. You can study from home or at work, at your own pace, in your own time
  6. Certificate of Completion

Course Delivery

Courses are accessed online via our learning management system by any device including PC, MAC, tablet or Smart Phone.

Recognition & Accreditation

The courses offered by Courses For Success are unique as they are taught in a step by step process enabling students to complete them quickly and easily, so that you can obtain your qualification sooner. All students who complete the course receive a certificate of completion. Courses For Success is committed to high completion rates and therefore 100% student satisfaction.

Getting the Most from Your Data

  • Section 1.1: Outlining and Grouping Data
  • Using Automatic Outlining (Part One)
  • Using Automatic Outlining (Part Two)
  • Using Automatic Outlining (Part Three)
  • Using Automatic Outlining (Part Four)
  • Displaying and Collapsing Levels (Part One)
  • Displaying and Collapsing Levels (Part Two)
  • Grouping Data Manually (Part One)
  • Grouping Data Manually (Part Two)
  • Grouping Data Manually (Part Three)
  • Grouping Data Manually (Part Four)
  • Creating Subtotals (Part One)
  • Creating Subtotals (Part Two)
  • Creating Subtotals (Part Three)
  • Creating Subtotals (Part Four)
  • Creating Subtotals (Part Five)
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Step-By-Step (Part Five)
  • Step-By-Step (Part Six)
  • Step-By-Step (Part Seven)
  • Step-By-Step (Part Eight)
  • Skill Sharpener
  •  Section 1.2: Exploring Scenarios
  • What is a Scenario? (Part One)
  • What is a Scenario? (Part Two)
  • Creating a Scenario (Part One)
  • Creating a Scenario (Part Two)
  • Creating a Scenario (Part Three)
  • Creating a Scenario (Part Four)
  • Creating a Scenario (Part Five)
  • Creating a Scenario (Part Six)
  • Saving Multiple Scenarios (Part One)
  • Saving Multiple Scenarios (Part Two)
  • Saving Multiple Scenarios (Part Three)
  • Merging Scenarios (Part One)
  • Merging Scenarios (Part Two)
  • Merging Scenarios (Part Three)
  • Merging Scenarios (Part Four)
  • Merging Scenarios (Part Five)
  • Creating a Scenario Summary Report (Part One)
  • Creating a Scenario Summary Report (Part Two)
  • Creating a Scenario Summary Report (Part Three)
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Step-By-Step (Part Five)
  • Step-By-Step (Part Six)
  • Step-By-Step (Part Seven)
  • Step-By-Step (Part Eight)
  • Step-By-Step (Part Nine)
  • Step-By-Step (Part Ten)
  • Step-By-Step (Part Eleven)
  • Skill Sharpener
  •  Section 1.3: Using Data Analysis Tools
  • Enabling Data Analysis Tools (Part One)
  • Enabling Data Analysis Tools (Part Two)
  • Enabling Data Analysis Tools (Part Three)
  • Enabling Data Analysis Tools (Part Four)
  • Enabling Data Analysis Tools (Part Five)
  • Enabling Data Analysis Tools (Part Six)
  • Enabling Data Analysis Tools (Part Seven)
  • An Overview of Excel’s Analysis Tools (Part One)
  • An Overview of Excel’s Analysis Tools (Part Two)
  • An Overview of Excel’s Analysis Tools (Part Three)
  • An Overview of Excel’s Analysis Tools (Part Four)
  • An Overview of Excel’s Analysis Tools (Part Five)
  • An Overview of Excel’s Analysis Tools (Part Six)
  • An Overview of Excel’s Analysis Tools (Part Seven)
  • An Overview of Excel’s Analysis Tools (Part Eight)
  • An Overview of Excel’s Analysis Tools (Part Nine)
  • An Overview of Excel’s Analysis Tools (Part Ten)
  • An Overview of Excel’s Analysis Tools (Part Eleven)
  • An Overview of Excel’s Analysis Tools (Part Twelve)
  • An Overview of the Available Add-In Tools (Part One)
  • An Overview of the Available Add-In Tools (Part Two)
  • An Overview of the Available Add-In Tools (Part Three)
  • An Overview of the Available Add-In Tools (Part Four)
  • An Overview of the Available Add-In Tools (Part Five)
  • An Overview of the Available Add-In Tools (Part Six)
  • An Overview of the Available Add-In Tools (Part Seven)
  • Using a One or Two Input Data Table (Part One)
  • Using a One or Two Input Data Table (Part Two)
  • Using a One or Two Input Data Table (Part Three)
  • Using a One or Two Input Data Table (Part Four)
  • Using a One or Two Input Data Table (Part Five)
  • Using a One or Two Input Data Table (Part Six)
  • Using a One or Two Input Data Table (Part Seven)
  • Using a One or Two Input Data Table (Part Eight)
  • Using a One or Two Input Data Table (Part Nine)
  • Using a One or Two Input Data Table (Part Ten)
  • Using a One or Two Input Data Table (Part Eleven)
  • Using Goal Seek (Part One)
  • Using Goal Seek (Part Two)
  • Using Goal Seek (Part Three)
  • Using Goal Seek (Part Four)
  • Using Goal Seek (Part Five)
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Step-By-Step (Part Five)
  • Skill Sharpener
  •  Section 1.4: Using Solver
  • Setting up a Worksheet for Solver (Part One)
  • Setting up a Worksheet for Solver (Part Two)
  • Setting up a Worksheet for Solver (Part Three)
  • Running Solver (Part One)
  • Running Solver (Part Two)
  • Running Solver (Part Three)
  • Running Solver (Part Four)
  • Running Solver (Part Five)
  • Running Solver (Part Six)
  • Running Solver (Part Seven)
  • Generating Reports and Scenarios with Solver
  • Changing Solver Values (Part One)
  • Changing Solver Values (Part Two)
  • Managing Solver Constraints
  • Choosing a Solving Method (Part One)
  • Choosing a Solving Method (Part Two)
  • Using Solver as a Goal Seek Tool (Part One)
  • Using Solver as a Goal Seek Tool (Part Two)
  • Using Solver as a Goal Seek Tool (Part Three)
  • Using Solver as a Goal Seek Tool (Part Four)
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Step-By-Step (Part Five)
  • Step-By-Step (Part Six)
  • Step-By-Step (Part Seven)
  • Skill Sharpener
  •  Section 1.5: Excel and Hyperlinks
  • What is a Hyperlink?
  • Inserting Hyperlinks (Part One)
  • Inserting Hyperlinks (Part Two)
  • Inserting Hyperlinks (Part Three)
  • Inserting Hyperlinks (Part Four)
  • Inserting Hyperlinks (Part Five)
  • Inserting Hyperlinks (Part Six)
  • Inserting Hyperlinks (Part Seven)
  • Inserting Hyperlinks (Part Eight)
  • Inserting Hyperlinks (Part Nine)
  • Editing Hyperlinks (Part One)
  • Editing Hyperlinks (Part Two)
  • Formatting Hyperlinks (Part One)
  • Formatting Hyperlinks (Part Two)
  • Formatting Hyperlinks (Part Three)
  • Formatting Hyperlinks (Part Four)
  • Formatting Hyperlinks (Part Five)
  • Using Hyperlinks in Excel (Part One)
  • Using Hyperlinks in Excel (Part Two)
  • Using Hyperlinks in Excel (Part Three)
  • Using Hyperlinks in Excel (Part Four)
  • Using Hyperlinks in Excel (Part Five)
  • Using Hyperlinks in Excel (Part Six)
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Step-By-Step (Part Five)
  • Step-By-Step (Part Six)
  • Step-By-Step (Part Seven)
  • Step-By-Step (Part Eight)
  • Skill Sharpener
  • Case Study

Pivoting Data

  • Section 1.1: Getting Started with PivotTables
  • What is a PivotTable? (Part One)
  • What is a PivotTable? (Part Two)
  • Creating a PivotTable (Part One)
  • Creating a PivotTable (Part Two)
  • Creating a PivotTable (Part Three)
  • Creating a PivotTable (Part Four)
  • Creating a PivotTable (Part Five)
  • Creating a PivotTable (Part Six)
  • Using the PivotTable Tools Tabs (Part One)
  • Using the PivotTable Tools Tabs (Part Two)
  • Using the PivotTable Tools Tabs (Part Three)
  • Using the PivotTable Tools Tabs (Part Four)
  • Using the PivotTable Tools Tabs (Part Five)
  • Using the PivotTable Tools Tabs (Part Six)
  • Using the PivotTable Tools Tabs (Part Seven)
  • Using the PivotTable Tools Tabs (Part Eight)
  • Using the PivotTable Tools Tabs (Part Nine)
  • Using the PivotTable Tools Tabs (Part Ten)
  • Using the PivotTable Tools Tabs (Part Eleven)
  • Using the PivotTable Tools Tabs (Part Twelve)
  • Using the PivotTable Tools Tabs (Part Thirteen)
  • Using the PivotTable Tools Tabs (Part Fourteen)
  • Using the PivotTable Tools Tabs (Part Fifteen)
  • Using the PivotTable Tools Tabs (Part Sixteen)
  • Adding and Removing Data with the Field List (Part One)
  • Adding and Removing Data with the Field List (Part Two)
  • Adding and Removing Data with the Field List (Part Three)
  • Adding and Removing Data with the Field List (Part Four)
  • Adding and Removing Data with the Field List (Part Five)
  • Adding and Removing Data with the Field List (Part Six)
  • Adding and Removing Data with the Field List (Part Seven)
  • Changing the Field List Layout (Part One)
  • Changing the Field List Layout (Part Two)
  • Changing the Field List Layout (Part Three)
  • Pivoting Data (Part One)
  • Pivoting Data (Part Two)
  • Pivoting Data (Part Three)
  • Pivoting Data (Part Four)
  • Pivoting Data (Part Five)
  • Pivoting Data (Part Six)
  • Pivoting Data (Part Seven)
  • Pivoting Data (Part Eight)
  • Pivoting Data (Part Nine)
  • Pivoting Data (Part Ten)
  • Pivoting Data (Part Eleven)
  • Pivoting Data (Part Twelve)
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Step-By-Step (Part Five)
  • Step-By-Step (Part Six)
  • Step-By-Step (Part Seven)
  • Step-By-Step (Part Eight)
  • Step-By-Step (Part Nine)
  • Skill Sharpener
  •  Section 1.2: Working with PivotTable Data
  • Expanding and Collapsing Data (Part One)
  • Expanding and Collapsing Data (Part Two)
  • Expanding and Collapsing Data (Part Three)
  • Expanding and Collapsing Data (Part Four)
  • Filtering Data (Part One)
  • Filtering Data (Part Two)
  • Filtering Data (Part Three)
  • Filtering Data (Part Four)
  • Filtering Data (Part Five)
  • Filtering Data (Part Six)
  • Filtering Data (Part Seven)
  • Filtering Data (Part Eight)
  • Filtering Data (Part Nine)
  • Sorting Data (Part One)
  • Sorting Data (Part Two)
  • Sorting Data (Part Three)
  • Sorting Data (Part Four)
  • Sorting Data (Part Five)
  • Sorting Data (Part Six)
  • Sorting Data (Part Seven)
  • Sorting Data (Part Eight)
  • Grouping Data (Part One)
  • Grouping Data (Part Two)
  • Grouping Data (Part Three)
  • Refreshing Data (Part One)
  • Refreshing Data (Part Two)
  • Refreshing Data (Part Three)
  • Refreshing Data (Part Four)
  • Refreshing Data (Part Five)
  • Editing the Data Source (Part One)
  • Editing the Data Source (Part Two)
  • Editing the Data Source (Part Three)
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Step-By-Step (Part Five)
  • Step-By-Step (Part Six)
  • Step-By-Step (Part Seven)
  • Step-By-Step (Part Eight)
  • Step-By-Step (Part Nine)
  • Skill Sharpener
  •  Section 1.3: Formatting a PivotTable
  • Modifying Fields and Labels (Part One)
  • Modifying Fields and Labels (Part Two)
  • Modifying Fields and Labels (Part Three)
  • Modifying Fields and Labels (Part Four)
  • Modifying Fields and Labels (Part Five)
  • Modifying Fields and Labels (Part Six)
  • Modifying Fields and Labels (Part Seven)
  • Modifying Fields and Labels (Part Eight)
  • Modifying Fields and Labels (Part Nine)
  • Modifying Values (Part One)
  • Modifying Values (Part Two)
  • Modifying Values (Part Three)
  • Modifying Values (Part Four)
  • Modifying Values (Part Five)
  • Modifying Values (Part Six)
  • Modifying Values (Part Seven)
  • Modifying Values (Part Eight)
  • Using the Layout Group on the Design Tab (Part One)
  • Using the Layout Group on the Design Tab (Part Two)
  • Using the Layout Group on the Design Tab (Part Three)
  • Using the Layout Group on the Design Tab (Part Four)
  • Using the Layout Group on the Design Tab (Part Five)
  • Using the Layout Group on the Design Tab (Part Six)
  • Using the Layout Group on the Design Tab (Part Seven)
  • Using the Layout Group on the Design Tab (Part Eight)
  • Applying a Style to a PivotTable (Part One)
  • Applying a Style to a PivotTable (Part Two)
  • Applying a Style to a PivotTable (Part Three)
  • Changing PivotTable Style Options (Part One)
  • Changing PivotTable Style Options (Part Two)
  • Manually Formatting a PivotTable (Part One)
  • Manually Formatting a PivotTable (Part Two)
  • Manually Formatting a PivotTable (Part Three)
  • Using the PivotTable Options Dialog (Part One)
  • Using the PivotTable Options Dialog (Part Two)
  • Using the PivotTable Options Dialog (Part Three)
  • Using the PivotTable Options Dialog (Part Four)
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Step-By-Step (Part Five)
  • Step-By-Step (Part Six)
  • Step-By-Step (Part Seven)
  • Step-By-Step (Part Eight)
  • Skill Sharpener
  •  Section 1.4: Using the Classic PivotTable Layout
  • Creating an Empty (Classic) PivotTable Frame (Part One)
  • Creating an Empty (Classic) PivotTable Frame (Part Two)
  • Creating an Empty (Classic) PivotTable Frame (Part Three)
  • Creating an Empty (Classic) PivotTable Frame (Part Four)
  • Switching an Existing PivotTable to a Classic Layout (Part One)
  • Switching an Existing PivotTable to a Classic Layout (Part Two)
  • Switching an Existing PivotTable to a Classic Layout (Part Three)
  • Adding Data (Part One)
  • Adding Data (Part Two)
  • Adding Data (Part Three)
  • Pivoting Data (Part One)
  • Pivoting Data (Part Two)
  • Pivoting Data (Part Three)
  • Pivoting Data (Part Four)
  • Pivoting Data (Part Five)
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Step-By-Step (Part Five)
  • Step-By-Step (Part Six)
  • Skill Sharpener
  •  Section 1.5: Advanced PivotTable Tasks
  • Creating a PivotTable Based on External Data (Part One)
  • Creating a PivotTable Based on External Data (Part Two)
  • Creating a PivotTable Based on External Data (Part Three)
  • Creating a PivotTable Based on External Data (Part Four)
  • Creating a PivotTable Based on External Data (Part Five)
  • Creating a PivotTable Based on External Data (Part Six)
  • Creating a PivotTable Based on External Data (Part Seven)
  • Creating a PivotTable Based on External Data (Part Eight)
  • Creating a PivotTable Based on External Data (Part Nine)
  • Creating a PivotTable Based on External Data (Part Ten)
  • Creating a PivotTable Based on External Data (Part Eleven)
  • Creating a PivotTable Based on External Data (Part Twelve)
  • Refreshing External Data (Part One)
  • Refreshing External Data (Part Two)
  • Creating a Slicer (Part One)
  • Creating a Slicer (Part Two)
  • Creating a Slicer (Part Three)
  • Creating a Slicer (Part Four)
  • Creating a Slicer (Part Five)
  • Creating a Slicer (Part Six)
  • Creating a Slicer (Part Seven)
  • Creating a Slicer (Part Eight)
  • Using the Slicer Tools Tab (Part One)
  • Using the Slicer Tools Tab (Part Two)
  • Using the Slicer Tools Tab (Part Three)
  • Using the Slicer Tools Tab (Part Four)
  • Using the Slicer Tools Tab (Part Five)
  • Using the Slicer Tools Tab (Part Six)
  • Using the Slicer Tools Tab (Part Seven)
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Step-By-Step (Part Five)
  • Step-By-Step (Part Six)
  • Step-By-Step (Part Seven)
  • Skill Sharpener
  •  Section 1.6: Using PowerPivot
  • System Requirements
  • Downloading and Installing PowerPivot (Part One)
  • Downloading and Installing PowerPivot (Part Two)
  • Downloading and Installing PowerPivot (Part Three)
  • Importing Access Data (Part One)
  • Importing Access Data (Part Two)
  • Importing Access Data (Part Three)
  • Importing Access Data (Part Four)
  • Importing Access Data (Part Five)
  • Importing Access Data (Part Six)
  • Importing Access Data (Part Seven)
  • Importing Excel Data (Part One)
  • Importing Excel Data (Part Two)
  • Importing Excel Data (Part Three)
  • Importing Excel Data (Part Four)
  • Importing Excel Data (Part Five)
  • Integrating Data with Relationships (Part One)
  • Integrating Data with Relationships (Part Two)
  • Integrating Data with Relationships (Part Three)
  • Creating a PivotTable with PowerPivot Data (Part One)
  • Creating a PivotTable with PowerPivot Data (Part Two)
  • Creating a PivotTable with PowerPivot Data (Part Three)
  • Creating a PivotTable with PowerPivot Data (Part Four)
  • Creating a PivotTable with PowerPivot Data (Part Five)
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Step-By-Step (Part Five)
  • Step-By-Step (Part Six)
  • Step-By-Step (Part Seven)
  • Step-By-Step (Part Eight)
  • Step-By-Step (Part Nine)
  • Step-By-Step (Part Ten)
  • Step-By-Step (Part Eleven)
  • Step-By-Step (Part Twelve)
  • Step-By-Step (Part Thirteen)
  • Step-By-Step (Part Fourteen)
  • Step-By-Step (Part Fifteen)
  • Step-By-Step (Part Sixteen)
  • Step-By-Step (Part Seventeen)
  • Skill Sharpener
  • Case Study

Charting Pivoted Data

  • Section 1.1: Getting Started with PivotCharts
  • Creating a PivotChart from Scratch (Part One)
  • Creating a PivotChart from Scratch (Part Two)
  • Creating a PivotChart from Existing Data (Part One)
  • Creating a PivotChart from Existing Data (Part Two)
  • Adding Data to your Chart (Part One)
  • Adding Data to your Chart (Part Two)
  • Adding Data to your Chart (Part Three)
  • Pivoting Data (Part One)
  • Pivoting Data (Part Two)
  • Pivoting Data (Part Three)
  • Pivoting Data (Part Four)
  • Pivoting Data (Part Five)
  • Pivoting Data (Part Six)
  • Pivoting Data (Part Seven)
  • Pivoting Data (Part Eight)
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Step-By-Step (Part Five)
  • Step-By-Step (Part Six)
  • Step-By-Step (Part Seven)
  • Step-By-Step (Part Eight)
  • Step-By-Step (Part Nine)
  • Skill Sharpener
  •  Section 1.2: Using the PivotChart Tools Tabs
  • Using the Design Tab (Part One)
  • Using the Design Tab (Part Two)
  • Using the Design Tab (Part Three)
  • Using the Design Tab (Part Four)
  • Using the Design Tab (Part Five)
  • Using the Design Tab (Part Six)
  • Using the Design Tab (Part Seven)
  • Using the Layout Tab (Part One)
  • Using the Layout Tab (Part Two)
  • Using the Layout Tab (Part Three)
  • Using the Layout Tab (Part Four)
  • Using the Layout Tab (Part Five)
  • Using the Layout Tab (Part Six)
  • Using the Layout Tab (Part Seven)
  • Using the Layout Tab (Part Eight)
  • Using the Format Tab (Part One)
  • Using the Format Tab (Part Two)
  • Using the Format Tab (Part Three)
  • Using the Format Tab (Part Four)
  • Using the Format Tab (Part Five)
  • Using the Format Tab (Part Six)
  • Using the Format Tab (Part Seven)
  • Using the Analyze Tab (Part One)
  • Using the Analyze Tab (Part Two)
  • Using the Analyze Tab (Part Three)
  • Using the Analyze Tab (Part Four)
  • Using the Analyze Tab (Part Five)
  • Using the Analyze Tab (Part Six)
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Step-By-Step (Part Five)
  • Step-By-Step (Part Six)
  • Step-By-Step (Part Seven)
  • Step-By-Step (Part Eight)
  • Step-By-Step (Part Nine)
  • Step-By-Step (Part Ten)
  • Skill Sharpener
  •  Section 1.3: Formatting a PivotChart
  • Renaming Fields (Part One)
  • Renaming Fields (Part Two)
  • Renaming Fields (Part Three)
  • Changing the Chart Type (Part One)
  • Changing the Chart Type (Part Two)
  • Changing the Chart Type (Part Three)
  • Changing the Chart Type (Part Four)
  • Changing the Chart Type (Part Five)
  • Changing the Chart Type (Part Six)
  • Changing the Chart Type (Part Seven)
  • Applying a Chart Style (Part One)
  • Applying a Chart Style (Part Two)
  • Applying a Chart Style (Part Three)
  • Manually Formatting Chart Elements (Part One)
  • Manually Formatting Chart Elements (Part Two)
  • Manually Formatting Chart Elements (Part Three)
  • Manually Formatting Chart Elements (Part Four)
  • Manually Formatting Chart Elements (Part Five)
  • Manually Formatting Chart Elements (Part Six)
  • Manually Formatting Chart Elements (Part Seven)
  • Manually Formatting Chart Elements (Part Eight)
  • Manually Formatting Chart Elements (Part Nine)
  • Manually Formatting Chart Elements (Part Ten)
  • Manually Formatting Chart Elements (Part Eleven)
  • Manually Formatting Chart Elements (Part Twelve)
  • Changing the Layout of Chart Elements (Part One)
  • Changing the Layout of Chart Elements (Part Two)
  • Changing the Layout of Chart Elements (Part Three)
  • Changing the Layout of Chart Elements (Part Four)
  • Changing the Layout of Chart Elements (Part Five)
  • Changing the Layout of Chart Elements (Part Six)
  • Changing the Layout of Chart Elements (Part Seven)
  • Changing the Layout of Chart Elements (Part Eight)
  • Changing the Layout of Chart Elements (Part Nine)
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Step-By-Step (Part Five)
  • Step-By-Step (Part Six)
  • Step-By-Step (Part Seven)
  • Skill Sharpener
  •  Section 1.4: Advanced PivotChart Tasks
  • Creating a PivotChart Based on External Data (Part One)
  • Creating a PivotChart Based on External Data (Part Two)
  • Creating a PivotChart Based on External Data (Part Three)
  • Creating a PivotChart Based on External Data (Part Four)
  • Creating a PivotChart Based on External Data (Part Five)
  • Creating a PivotChart Based on External Data (Part Six)
  • Creating a PivotChart Based on External Data (Part Seven)
  • Creating a PivotChart Based on External Data (Part Eight)
  • Creating a Slicer (Part One)
  • Creating a Slicer (Part Two)
  • Creating a Slicer (Part Three)
  • Creating a Slicer (Part Four)
  • Creating a Slicer (Part Five)
  • Creating a PivotTable and PivotChart from a Scenario (Part One)
  • Creating a PivotTable and PivotChart from a Scenario (Part Two)
  • Creating a PivotTable and PivotChart from a Scenario (Part Three)
  • Creating a PivotTable and PivotChart from a Scenario (Part Four)
  • Creating a PivotTable and PivotChart from a Scenario (Part Five)
  • Creating a PivotTable and PivotChart from a Scenario (Part Six)
  • Creating a PivotTable and PivotChart from a Scenario (Part Seven)
  • Creating a PivotTable and PivotChart from a Scenario (Part Eight)
  • Creating a PivotTable and PivotChart from a Scenario (Part Nine)
  • Creating PivotCharts with PowerPivot Data (Part One)
  • Creating PivotCharts with PowerPivot Data (Part Two)
  • Creating PivotCharts with PowerPivot Data (Part Three)
  • Creating PivotCharts with PowerPivot Data (Part Four)
  • Creating PivotCharts with PowerPivot Data (Part Five)
  • Creating PivotCharts with PowerPivot Data (Part Six)
  • Creating PivotCharts with PowerPivot Data (Part Seven)
  • Creating PivotCharts with PowerPivot Data (Part Eight)
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Step-By-Step (Part Five)
  • Step-By-Step (Part Six)
  • Step-By-Step (Part Seven)
  • Step-By-Step (Part Eight)
  • Step-By-Step (Part Nine)
  • Skill Sharpener
  • Case Study

Advanced Excel Tasks

  • Section 1.1: Using Advanced Functions
  • Using the PMT Function (Part One)
  • Using the PMT Function (Part Two)
  • Using the PMT Function (Part Three)
  • Using the PMT Function (Part Four)
  • Using the PMT Function (Part Five)
  • Using the PMT Function (Part Six)
  • Using the FV Function (Part One)
  • Using the FV Function (Part Two)
  • Understanding Logical Functions (Part One)
  • Understanding Logical Functions (Part Two)
  • Understanding Logical Functions (Part Three)
  • Understanding Logical Functions (Part Four)
  • Understanding Logical Functions (Part Five)
  • Understanding Logical Functions (Part Six)
  • Understanding Logical Functions (Part Seven)
  • Understanding Logical Functions (Part Eight)
  • Using Logical Functions (Part One)
  • Using Logical Functions (Part Two)
  • Using Logical Functions (Part Three)
  • Using Logical Functions (Part Four)
  • Using IFERROR with Array Formulas (Part One)
  • Using IFERROR with Array Formulas (Part Two)
  • Using IFERROR with Array Formulas (Part Three)
  • Using IFERROR with Array Formulas (Part Four)
  • Using IFERROR with Array Formulas (Part Five)
  • Using IFERROR with Array Formulas (Part Six)
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Step-By-Step (Part Five)
  • Skill Sharpener
  • Section 1.2: Using the VLOOKUP Function
  • Understanding VLOOKUP and HLOOKUP
  • Using VLOOKUP to Find Data (Part One)
  • Using VLOOKUP to Find Data (Part Two)
  • Using VLOOKUP to Find Data (Part Three)
  • Using VLOOKUP to Find Data (Part Four)
  • How to Find an Exact Match with VLOOKUP (Part One)
  • How to Find an Exact Match with VLOOKUP (Part Two)
  • Finding an Approximate Match with VLOOKUP (Part One)
  • Finding an Approximate Match with VLOOKUP (Part Two)
  • Using VLOOKUP as an Array Formula (Part One)
  • Using VLOOKUP as an Array Formula (Part Two)
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Step-By-Step (Part Five)
  • Skill Sharpener
  • Section 1.3: Using Custom AutoFill Lists
  • What is an AutoFill List?
  • Creating a Custom AutoFill List (Part One)
  • Creating a Custom AutoFill List (Part Two)
  • Creating a Custom AutoFill List (Part Three)
  • Creating a Custom AutoFill List (Part Four)
  • Creating a Custom AutoFill List (Part Five)
  • Using a Custom AutoFill List
  • Modifying a Custom AutoFill List
  • Deleting a Custom AutoFill List
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Step-By-Step (Part Five)
  • Step-By-Step (Part Six)
  • Skill Sharpener
  • Section 1.4: Linking, Consolidating, and Combining Data
  • Linking Workbooks (Part One)
  • Linking Workbooks (Part Two)
  • Linking Workbooks (Part Three)
  • Consolidating Workbooks (Part One)
  • Consolidating Workbooks (Part Two)
  • Consolidating Workbooks (Part Three)
  • Consolidating Workbooks (Part Four)
  • Consolidating Workbooks (Part Five)
  • Combining Worksheets (Part One)
  • Combining Worksheets (Part Two)
  • Combining Worksheets (Part Three)
  • Pivoting Consolidated Data (Part One)
  • Pivoting Consolidated Data (Part Two)
  • Pivoting Consolidated Data (Part Three)
  • Pivoting Consolidated Data (Part Four)
  • Pivoting Consolidated Data (Part Five)
  • Pivoting Consolidated Data (Part Six)
  • Pivoting Consolidated Data (Part Seven)
  • Pivoting Consolidated Data (Part Eight)
  • Pivoting Consolidated Data (Part Nine)
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Step-By-Step (Part Five)
  • Step-By-Step (Part Six)
  • Step-By-Step (Part Seven)
  • Skill Sharpener
  • Case Study

 

Macros, Visual Basic, and Excel Programming

  • Section 1.1: Creating a Basic Macro
  • Recording a Macro (Part One)
  • Recording a Macro (Part Two)
  • Editing a Macro (Part One)
  • Editing a Macro (Part Two)
  • Running a Macro
  • Understanding Macro Security (Part One)
  • Understanding Macro Security (Part Two)
  • Understanding Macro Security (Part Three)
  • Understanding Macro Security (Part Four)
  • Understanding Macro Security (Part Five)
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Step-By-Step (Part Five)
  • Step-By-Step (Part Six)
  • Skill Sharpener
  • Section 1.2: Visual Basic and Macros
  • Opening the Visual Basic Editor (Part One)
  • Opening the Visual Basic Editor (Part Two)
  • Understanding the Visual Basic Editor (Part One)
  • Understanding the Visual Basic Editor (Part Two)
  • Adding Code to your Macro
  • Adding Comments to Visual Basic Code (Part One)
  • Adding Comments to Visual Basic Code (Part Two)
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Skill Sharpener
  • Section 1.3: More Macro Tasks
  • What are Relative References?
  • Recording a Relative Reference Macro
  • Running a Relative Reference Macro
  • Assigning a Keyboard Shortcut to a Macro (Part One)
  • Assigning a Keyboard Shortcut to a Macro (Part Two)
  • Copying a Macro from a Workbook or Template (Part One)
  • Copying a Macro from a Workbook or Template (Part Two)
  • Copying a Macro from a Workbook or Template (Part Three)
  • Copying a Macro from a Workbook or Template (Part Four)
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Step-By-Step (Part Five)
  • Step-By-Step (Part Six)
  • Skill Sharpener
  • Section 1.4: Advanced Visual Basic Tasks
  • Declaring Variables
  • Iteration Over a Range
  • Prompting for User Input
  • Prompting for User Input
  • Using If, Then, and Else Statements (Part One)
  • Using If, Then, and Else Statements (Part Two)
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Step-By-Step (Part Five)
  • Step-By-Step (Part Six)
  • Skill Sharpener
  • Case Study 

Entry requirements

Students must have basic literacy and numeracy skills.

Minimum education

Open entry. Previous schooling and academic achievements are not required for entry into this course.

Computer requirements

Students will need access to a computer and the internet.

Minimum specifications for the computer are:

Windows:

  • Microsoft Windows XP, or later
  • Modern and up to date Browser (Internet Explorer 8 or later, Firefox, Chrome, Safari)

MAC/iOS

  • OSX/iOS 6 or later
  • Modern and up to date Browser (Firefox, Chrome, Safari)

All systems

  • Internet bandwidth of 1Mb or faster
  • Flash player or a browser with HTML5 video capabilities(Currently Internet Explorer 9, Firefox, Chrome, Safari)

Students will also need access the following applications:

Adobe Acrobat Reader

1.  Who are Courses For Success?

Courses For Success is a global course platform that started in 2008 with 5 courses, since then we have grown to over 10,000 online courses. As our courses are delivered online via the internet, we sell our courses worldwide.

Our courses span across many categories including Academic, Animal, Beauty, Business, Career, Counseling, Creative & Media, Health & Therapy, Hobbies & Trades, IT, Personal Development, Sports & Fitness.

Some of the companies we work with include Groupon, Living Social, CNN, Entrepreneur, Mashable, Reed UK, Stack Social and many more.

2.  Is there a refund/cancellation policy?

Yes, we have a 7-day money-back refund guarantee. Just send us an email to email/info)(coursesforsuccess.com with the subject Courses For Success Refund so we can accommodate your request.

3.  What is the FREE Personal Success Training Program?

The Personal Success Training Program was developed by Courses For Success to help our customers achieve success. Currently, we are offering this program for FREE with every course or bundle purchase this month. This is a limited time offer! We have received thousands of reviews for this program, please see: Personal Success Training Program Reviews

4.  Are there any requirements to study this course?

No, anyone who has an interest in learning more about this subject matter is encouraged to take our course. There are no entry requirements to take this course.

5.  Do I require to have finished high school to complete this course?

No, you do not require a High School Diploma or to have finished school to study this course, this course is open to anyone who would like to take this course.

6.  What if English is not my first language?

This course is provided in English, however, due to the digital nature of our training, you can take your time studying the material and make use of tools such as google translate and Grammarly.

7.  Is this course online or conducted in person?

All our courses are accessible online on any device. You may complete them at your own pace and at your own time.

8.  How do I receive my course?

After you have completed the payment, you will receive a confirmation email and tax receipt. You will also receive an email containing your course login details (username and password), as well as instructions on how to access and log in to your course via the internet with any device, please check your junk/spam folder in the event that you do not receive the email.

9.  When does this course start?

Providing you have internet access you can start this course whenever you like, just go to the login page and insert your username and password and you can access the online material.

10.  What is online learning like?

Online learning is easy, if not easier than a traditional academic situation. By studying an online course, the usual boundaries caused by location and time constraints are eliminated, meaning you are free to study where and when you want at your own pace. Of course, you will need to be able to self-manage your time and be organized, but with our help, you’ll soon find yourself settling into a comfortable rhythm of study.

11.  What computer skills do I need for my course?

You don't need to be a computer expert to succeed with our online training, but you should be comfortable typing, using the internet and be capable of using common software (such as Microsoft word).

12.  How long will you have access to the online course?

There is no time limit for completing this course, it can be studied in your own time at your own pace. Once you have purchased this course you will have unlimited lifetime access, meaning you can access this course whenever you want.

13.  How long will my course take?

Individual courses are designed to be completed within 6-8 hours.

If you choose a course bundle, simply multiply the above hours by the number of courses included in the bundle.
For example:

  • 2 course bundle is 2 x 6-8 hours = 12-16 hours
  • 3 course bundle is 3 x 6-8 hours = 18-24 hours
  • 5 course bundle is 5 x 6-8 hours = 30-40 hours
  • 10 course bundle is 10 x 6-8 hours = 60-80 hours
14.  Do I need to buy textbooks?

All the required material for your course is included in the online system, you do not need to buy anything else.

15.  Is the course interactive?

Yes, all our courses are interactive.

16.  Is there an assessment or exam?

Yes, you will be required to complete a multiple-choice test online at the end of your course, you can do this test as many times as you require.

17.  What type of certificate will I receive?

You will receive a Certificate of Completion that is applicable worldwide, which demonstrates your commitment to learning new skills. You can share the certificate with your friends, relatives, co-workers and employers. Also, include it in your resume/CV, professional social media profiles and job applications.

Wendy Sue Hunt - 5 STAR REVIEW
"If you are considering taking any “Courses for Success”, I would highly recommend it. I have always been a firm believer it’s important to always sharpen your skills. You are never too old to learn more. I found the courses very helpful, interesting and easy to understand.
The term “Courses for Success” helped me in my current position to succeed. After completing the courses, I gave my manager the completion certificates. Recently I received a promotion too."
Valencia Marie Aviles - 5 STAR REVIEW
"I had a very good experience with my course. It has helped me to get multiple jobs and prepared me for almost everything I would need to know. The course was very informative and easy to understand and broken up perfectly to be done in a short amount of time while still learning a good amount! I would recommend Courses for Success to anyone trying to get abs certifications for job advancements, it is well worth it!"
ELENA GRIFFIN - 5 STAR REVIEW
"I have absolutely enjoyed the materials from Courses for Success. The materials are easy to understand which makes learning enjoyable. Courses for Success have great topics of interest which make you come back for more.
Thank you Courses for Success for being part of my learning journey and making education affordable!"

Our completion certificates are very valuable and will help you progress in your work environment and show employers how committed you are to learn new skills, you might even get a promotion.

18.  Will this course be credited by universities?

No, it is not equivalent to a college or university credit.

19.  Am I guaranteed to get a job with this certificate?

This course will give you the skills you need to help you obtain employment, but it’s up to you if you get the job or not.

20.  How will this course assist me with my career?

Studying and completing this course will show employers that you have the knowledge in this field, additionally you will gain more confidence in this area of expertise.

21.  How long is the certificate valid for?

The Certificates are valid for life and do not need renewing. 

22.  Can I take more than one course at a time?

Courses are studied online at your own pace and you are free to study as many or as few courses as you wish, we also offer online course bundles that allow you to save on additional courses so that you may get all the topics related to your training goals in one go.

23.  What are the Payment Methods available? Is there a payment plan?

We accept payments via PayPal, Credit Card and Bank Transfer. *For faster transaction Credit Card payments are preferred. Please purchase online via our website course product page or contact us at email/info)(coursesforsuccess.com, to pay via bank transfer.

24.  Can I purchase for multiple people?

Yes, you can do this by purchasing individually via website or send us a request via email at email/info)(coursesforsuccess.com

25.  Can I request for an invoice before purchase?

Yes, you can request for an invoice via email at email/info)(coursesforsuccess.com

26.  Purchase for a gift?

Yes, you can purchase this course as a gift, simply send an email to email/info)(coursesforsuccess.com, with the course details and we can accommodate this.

27.  Can I create my own course bundle?

Yes, you can customize your own bundle. Please send us the complete list with the exact course link of the courses you'd like to bundle up via email email/info)(coursesforsuccess.com and we will create them for you. *Each course access, time of completion and certification varies depending on the course type.

28.  How will I contact Courses For Success if I have any questions?

You can contact our support team, at any time through live chat on our website, or email at email/info)(coursesforsuccess.com, or by calling one of our phone numbers depending on which country you are in.  

About this Course

Learn How To Become a Competent Everyday User of Excel

Part 1 : Getting the Most from Your Data

To begin, participants will learn about Excel's automatic grouping, outlining, and subtotaling features. Participants will also explore the Scenario Manager, data analysis tools, add-ins, one and two data input tables, goal seek, and Solver. The section will conclude with a discussion on hyperlinks.

Part 2 : Pivoting Data

This section focuses on one of Excel's most powerful tools: PivotTables. Participants will explore all aspects of PivotTables, including creating a PivotTable; using the contextual tabs; pivoting, summarizing, and analyzing data; formatting the PivotTable; and using external data with a PivotTable. This section also includes information on Slicers (a new feature that lets users analyze and interpret pivoted data with ease) and the classic PivotTable frame (used in Excel 2003 and earlier). The session will conclude with a comprehensive introduction to integrating data with PowerPivot and creating a PivotTable from that data.

Part 3 : Charting Pivoted Data

In this section, participants will learn how to create, use, edit, and format PivotCharts. Participants will also get experience with advanced PivotChart tasks, including creating a PivotChart from PowerPivot data and using PivotCharts to display scenario results.

Part 4 : Advanced Excel Tasks

The next section of this manual will explore a few Excel features that we find handy for everyday chores. First, advanced functions (PMT, FV, VLOOKUP, and HLOOKUP) and logical functions (IF, IFERROR, AND, OR, NOT, FALSE, and TRUE) will be covered. Then, AutoFill lists (which can save time when entering data) will be discussed. The section will conclude with information on linking, consolidating, and combining Excel data, with a final lesson on using the classic PivotTable and PivotChart wizard to pivot consolidated data.

Part 5 : Macros, Visual Basic, and Excel Programming

The final section of this manual will explore how to automate Excel tasks with macros. We will cover recording, running, and editing both basic and relative reference macros. Information on assigning a keyboard shortcut to a macro and managing macro security is also included. Then, Visual Basic tasks will be covered, including copying macros, using the Visual Basic Editor, declaring variables, iterating over a range, prompting for user input, and using conditional (If'_Then'_Else) statements.

Course Fast Facts:

  1. Easy to follow and understand
  2. Only 6 to 8 hours of study is required
  3. Unlimited, lifetime access to online course
  4. Delivered 100% on-line and accessible 24/7 from any computer or smartphone
  5. You can study from home or at work, at your own pace, in your own time
  6. Certificate of Completion

Course Delivery

Courses are accessed online via our learning management system by any device including PC, MAC, tablet or Smart Phone.

Recognition & Accreditation

The courses offered by Courses For Success are unique as they are taught in a step by step process enabling students to complete them quickly and easily, so that you can obtain your qualification sooner. All students who complete the course receive a certificate of completion. Courses For Success is committed to high completion rates and therefore 100% student satisfaction.

Getting the Most from Your Data

  • Section 1.1: Outlining and Grouping Data
  • Using Automatic Outlining (Part One)
  • Using Automatic Outlining (Part Two)
  • Using Automatic Outlining (Part Three)
  • Using Automatic Outlining (Part Four)
  • Displaying and Collapsing Levels (Part One)
  • Displaying and Collapsing Levels (Part Two)
  • Grouping Data Manually (Part One)
  • Grouping Data Manually (Part Two)
  • Grouping Data Manually (Part Three)
  • Grouping Data Manually (Part Four)
  • Creating Subtotals (Part One)
  • Creating Subtotals (Part Two)
  • Creating Subtotals (Part Three)
  • Creating Subtotals (Part Four)
  • Creating Subtotals (Part Five)
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Step-By-Step (Part Five)
  • Step-By-Step (Part Six)
  • Step-By-Step (Part Seven)
  • Step-By-Step (Part Eight)
  • Skill Sharpener
  •  Section 1.2: Exploring Scenarios
  • What is a Scenario? (Part One)
  • What is a Scenario? (Part Two)
  • Creating a Scenario (Part One)
  • Creating a Scenario (Part Two)
  • Creating a Scenario (Part Three)
  • Creating a Scenario (Part Four)
  • Creating a Scenario (Part Five)
  • Creating a Scenario (Part Six)
  • Saving Multiple Scenarios (Part One)
  • Saving Multiple Scenarios (Part Two)
  • Saving Multiple Scenarios (Part Three)
  • Merging Scenarios (Part One)
  • Merging Scenarios (Part Two)
  • Merging Scenarios (Part Three)
  • Merging Scenarios (Part Four)
  • Merging Scenarios (Part Five)
  • Creating a Scenario Summary Report (Part One)
  • Creating a Scenario Summary Report (Part Two)
  • Creating a Scenario Summary Report (Part Three)
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Step-By-Step (Part Five)
  • Step-By-Step (Part Six)
  • Step-By-Step (Part Seven)
  • Step-By-Step (Part Eight)
  • Step-By-Step (Part Nine)
  • Step-By-Step (Part Ten)
  • Step-By-Step (Part Eleven)
  • Skill Sharpener
  •  Section 1.3: Using Data Analysis Tools
  • Enabling Data Analysis Tools (Part One)
  • Enabling Data Analysis Tools (Part Two)
  • Enabling Data Analysis Tools (Part Three)
  • Enabling Data Analysis Tools (Part Four)
  • Enabling Data Analysis Tools (Part Five)
  • Enabling Data Analysis Tools (Part Six)
  • Enabling Data Analysis Tools (Part Seven)
  • An Overview of Excel’s Analysis Tools (Part One)
  • An Overview of Excel’s Analysis Tools (Part Two)
  • An Overview of Excel’s Analysis Tools (Part Three)
  • An Overview of Excel’s Analysis Tools (Part Four)
  • An Overview of Excel’s Analysis Tools (Part Five)
  • An Overview of Excel’s Analysis Tools (Part Six)
  • An Overview of Excel’s Analysis Tools (Part Seven)
  • An Overview of Excel’s Analysis Tools (Part Eight)
  • An Overview of Excel’s Analysis Tools (Part Nine)
  • An Overview of Excel’s Analysis Tools (Part Ten)
  • An Overview of Excel’s Analysis Tools (Part Eleven)
  • An Overview of Excel’s Analysis Tools (Part Twelve)
  • An Overview of the Available Add-In Tools (Part One)
  • An Overview of the Available Add-In Tools (Part Two)
  • An Overview of the Available Add-In Tools (Part Three)
  • An Overview of the Available Add-In Tools (Part Four)
  • An Overview of the Available Add-In Tools (Part Five)
  • An Overview of the Available Add-In Tools (Part Six)
  • An Overview of the Available Add-In Tools (Part Seven)
  • Using a One or Two Input Data Table (Part One)
  • Using a One or Two Input Data Table (Part Two)
  • Using a One or Two Input Data Table (Part Three)
  • Using a One or Two Input Data Table (Part Four)
  • Using a One or Two Input Data Table (Part Five)
  • Using a One or Two Input Data Table (Part Six)
  • Using a One or Two Input Data Table (Part Seven)
  • Using a One or Two Input Data Table (Part Eight)
  • Using a One or Two Input Data Table (Part Nine)
  • Using a One or Two Input Data Table (Part Ten)
  • Using a One or Two Input Data Table (Part Eleven)
  • Using Goal Seek (Part One)
  • Using Goal Seek (Part Two)
  • Using Goal Seek (Part Three)
  • Using Goal Seek (Part Four)
  • Using Goal Seek (Part Five)
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Step-By-Step (Part Five)
  • Skill Sharpener
  •  Section 1.4: Using Solver
  • Setting up a Worksheet for Solver (Part One)
  • Setting up a Worksheet for Solver (Part Two)
  • Setting up a Worksheet for Solver (Part Three)
  • Running Solver (Part One)
  • Running Solver (Part Two)
  • Running Solver (Part Three)
  • Running Solver (Part Four)
  • Running Solver (Part Five)
  • Running Solver (Part Six)
  • Running Solver (Part Seven)
  • Generating Reports and Scenarios with Solver
  • Changing Solver Values (Part One)
  • Changing Solver Values (Part Two)
  • Managing Solver Constraints
  • Choosing a Solving Method (Part One)
  • Choosing a Solving Method (Part Two)
  • Using Solver as a Goal Seek Tool (Part One)
  • Using Solver as a Goal Seek Tool (Part Two)
  • Using Solver as a Goal Seek Tool (Part Three)
  • Using Solver as a Goal Seek Tool (Part Four)
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Step-By-Step (Part Five)
  • Step-By-Step (Part Six)
  • Step-By-Step (Part Seven)
  • Skill Sharpener
  •  Section 1.5: Excel and Hyperlinks
  • What is a Hyperlink?
  • Inserting Hyperlinks (Part One)
  • Inserting Hyperlinks (Part Two)
  • Inserting Hyperlinks (Part Three)
  • Inserting Hyperlinks (Part Four)
  • Inserting Hyperlinks (Part Five)
  • Inserting Hyperlinks (Part Six)
  • Inserting Hyperlinks (Part Seven)
  • Inserting Hyperlinks (Part Eight)
  • Inserting Hyperlinks (Part Nine)
  • Editing Hyperlinks (Part One)
  • Editing Hyperlinks (Part Two)
  • Formatting Hyperlinks (Part One)
  • Formatting Hyperlinks (Part Two)
  • Formatting Hyperlinks (Part Three)
  • Formatting Hyperlinks (Part Four)
  • Formatting Hyperlinks (Part Five)
  • Using Hyperlinks in Excel (Part One)
  • Using Hyperlinks in Excel (Part Two)
  • Using Hyperlinks in Excel (Part Three)
  • Using Hyperlinks in Excel (Part Four)
  • Using Hyperlinks in Excel (Part Five)
  • Using Hyperlinks in Excel (Part Six)
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Step-By-Step (Part Five)
  • Step-By-Step (Part Six)
  • Step-By-Step (Part Seven)
  • Step-By-Step (Part Eight)
  • Skill Sharpener
  • Case Study

Pivoting Data

  • Section 1.1: Getting Started with PivotTables
  • What is a PivotTable? (Part One)
  • What is a PivotTable? (Part Two)
  • Creating a PivotTable (Part One)
  • Creating a PivotTable (Part Two)
  • Creating a PivotTable (Part Three)
  • Creating a PivotTable (Part Four)
  • Creating a PivotTable (Part Five)
  • Creating a PivotTable (Part Six)
  • Using the PivotTable Tools Tabs (Part One)
  • Using the PivotTable Tools Tabs (Part Two)
  • Using the PivotTable Tools Tabs (Part Three)
  • Using the PivotTable Tools Tabs (Part Four)
  • Using the PivotTable Tools Tabs (Part Five)
  • Using the PivotTable Tools Tabs (Part Six)
  • Using the PivotTable Tools Tabs (Part Seven)
  • Using the PivotTable Tools Tabs (Part Eight)
  • Using the PivotTable Tools Tabs (Part Nine)
  • Using the PivotTable Tools Tabs (Part Ten)
  • Using the PivotTable Tools Tabs (Part Eleven)
  • Using the PivotTable Tools Tabs (Part Twelve)
  • Using the PivotTable Tools Tabs (Part Thirteen)
  • Using the PivotTable Tools Tabs (Part Fourteen)
  • Using the PivotTable Tools Tabs (Part Fifteen)
  • Using the PivotTable Tools Tabs (Part Sixteen)
  • Adding and Removing Data with the Field List (Part One)
  • Adding and Removing Data with the Field List (Part Two)
  • Adding and Removing Data with the Field List (Part Three)
  • Adding and Removing Data with the Field List (Part Four)
  • Adding and Removing Data with the Field List (Part Five)
  • Adding and Removing Data with the Field List (Part Six)
  • Adding and Removing Data with the Field List (Part Seven)
  • Changing the Field List Layout (Part One)
  • Changing the Field List Layout (Part Two)
  • Changing the Field List Layout (Part Three)
  • Pivoting Data (Part One)
  • Pivoting Data (Part Two)
  • Pivoting Data (Part Three)
  • Pivoting Data (Part Four)
  • Pivoting Data (Part Five)
  • Pivoting Data (Part Six)
  • Pivoting Data (Part Seven)
  • Pivoting Data (Part Eight)
  • Pivoting Data (Part Nine)
  • Pivoting Data (Part Ten)
  • Pivoting Data (Part Eleven)
  • Pivoting Data (Part Twelve)
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Step-By-Step (Part Five)
  • Step-By-Step (Part Six)
  • Step-By-Step (Part Seven)
  • Step-By-Step (Part Eight)
  • Step-By-Step (Part Nine)
  • Skill Sharpener
  •  Section 1.2: Working with PivotTable Data
  • Expanding and Collapsing Data (Part One)
  • Expanding and Collapsing Data (Part Two)
  • Expanding and Collapsing Data (Part Three)
  • Expanding and Collapsing Data (Part Four)
  • Filtering Data (Part One)
  • Filtering Data (Part Two)
  • Filtering Data (Part Three)
  • Filtering Data (Part Four)
  • Filtering Data (Part Five)
  • Filtering Data (Part Six)
  • Filtering Data (Part Seven)
  • Filtering Data (Part Eight)
  • Filtering Data (Part Nine)
  • Sorting Data (Part One)
  • Sorting Data (Part Two)
  • Sorting Data (Part Three)
  • Sorting Data (Part Four)
  • Sorting Data (Part Five)
  • Sorting Data (Part Six)
  • Sorting Data (Part Seven)
  • Sorting Data (Part Eight)
  • Grouping Data (Part One)
  • Grouping Data (Part Two)
  • Grouping Data (Part Three)
  • Refreshing Data (Part One)
  • Refreshing Data (Part Two)
  • Refreshing Data (Part Three)
  • Refreshing Data (Part Four)
  • Refreshing Data (Part Five)
  • Editing the Data Source (Part One)
  • Editing the Data Source (Part Two)
  • Editing the Data Source (Part Three)
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Step-By-Step (Part Five)
  • Step-By-Step (Part Six)
  • Step-By-Step (Part Seven)
  • Step-By-Step (Part Eight)
  • Step-By-Step (Part Nine)
  • Skill Sharpener
  •  Section 1.3: Formatting a PivotTable
  • Modifying Fields and Labels (Part One)
  • Modifying Fields and Labels (Part Two)
  • Modifying Fields and Labels (Part Three)
  • Modifying Fields and Labels (Part Four)
  • Modifying Fields and Labels (Part Five)
  • Modifying Fields and Labels (Part Six)
  • Modifying Fields and Labels (Part Seven)
  • Modifying Fields and Labels (Part Eight)
  • Modifying Fields and Labels (Part Nine)
  • Modifying Values (Part One)
  • Modifying Values (Part Two)
  • Modifying Values (Part Three)
  • Modifying Values (Part Four)
  • Modifying Values (Part Five)
  • Modifying Values (Part Six)
  • Modifying Values (Part Seven)
  • Modifying Values (Part Eight)
  • Using the Layout Group on the Design Tab (Part One)
  • Using the Layout Group on the Design Tab (Part Two)
  • Using the Layout Group on the Design Tab (Part Three)
  • Using the Layout Group on the Design Tab (Part Four)
  • Using the Layout Group on the Design Tab (Part Five)
  • Using the Layout Group on the Design Tab (Part Six)
  • Using the Layout Group on the Design Tab (Part Seven)
  • Using the Layout Group on the Design Tab (Part Eight)
  • Applying a Style to a PivotTable (Part One)
  • Applying a Style to a PivotTable (Part Two)
  • Applying a Style to a PivotTable (Part Three)
  • Changing PivotTable Style Options (Part One)
  • Changing PivotTable Style Options (Part Two)
  • Manually Formatting a PivotTable (Part One)
  • Manually Formatting a PivotTable (Part Two)
  • Manually Formatting a PivotTable (Part Three)
  • Using the PivotTable Options Dialog (Part One)
  • Using the PivotTable Options Dialog (Part Two)
  • Using the PivotTable Options Dialog (Part Three)
  • Using the PivotTable Options Dialog (Part Four)
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Step-By-Step (Part Five)
  • Step-By-Step (Part Six)
  • Step-By-Step (Part Seven)
  • Step-By-Step (Part Eight)
  • Skill Sharpener
  •  Section 1.4: Using the Classic PivotTable Layout
  • Creating an Empty (Classic) PivotTable Frame (Part One)
  • Creating an Empty (Classic) PivotTable Frame (Part Two)
  • Creating an Empty (Classic) PivotTable Frame (Part Three)
  • Creating an Empty (Classic) PivotTable Frame (Part Four)
  • Switching an Existing PivotTable to a Classic Layout (Part One)
  • Switching an Existing PivotTable to a Classic Layout (Part Two)
  • Switching an Existing PivotTable to a Classic Layout (Part Three)
  • Adding Data (Part One)
  • Adding Data (Part Two)
  • Adding Data (Part Three)
  • Pivoting Data (Part One)
  • Pivoting Data (Part Two)
  • Pivoting Data (Part Three)
  • Pivoting Data (Part Four)
  • Pivoting Data (Part Five)
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Step-By-Step (Part Five)
  • Step-By-Step (Part Six)
  • Skill Sharpener
  •  Section 1.5: Advanced PivotTable Tasks
  • Creating a PivotTable Based on External Data (Part One)
  • Creating a PivotTable Based on External Data (Part Two)
  • Creating a PivotTable Based on External Data (Part Three)
  • Creating a PivotTable Based on External Data (Part Four)
  • Creating a PivotTable Based on External Data (Part Five)
  • Creating a PivotTable Based on External Data (Part Six)
  • Creating a PivotTable Based on External Data (Part Seven)
  • Creating a PivotTable Based on External Data (Part Eight)
  • Creating a PivotTable Based on External Data (Part Nine)
  • Creating a PivotTable Based on External Data (Part Ten)
  • Creating a PivotTable Based on External Data (Part Eleven)
  • Creating a PivotTable Based on External Data (Part Twelve)
  • Refreshing External Data (Part One)
  • Refreshing External Data (Part Two)
  • Creating a Slicer (Part One)
  • Creating a Slicer (Part Two)
  • Creating a Slicer (Part Three)
  • Creating a Slicer (Part Four)
  • Creating a Slicer (Part Five)
  • Creating a Slicer (Part Six)
  • Creating a Slicer (Part Seven)
  • Creating a Slicer (Part Eight)
  • Using the Slicer Tools Tab (Part One)
  • Using the Slicer Tools Tab (Part Two)
  • Using the Slicer Tools Tab (Part Three)
  • Using the Slicer Tools Tab (Part Four)
  • Using the Slicer Tools Tab (Part Five)
  • Using the Slicer Tools Tab (Part Six)
  • Using the Slicer Tools Tab (Part Seven)
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Step-By-Step (Part Five)
  • Step-By-Step (Part Six)
  • Step-By-Step (Part Seven)
  • Skill Sharpener
  •  Section 1.6: Using PowerPivot
  • System Requirements
  • Downloading and Installing PowerPivot (Part One)
  • Downloading and Installing PowerPivot (Part Two)
  • Downloading and Installing PowerPivot (Part Three)
  • Importing Access Data (Part One)
  • Importing Access Data (Part Two)
  • Importing Access Data (Part Three)
  • Importing Access Data (Part Four)
  • Importing Access Data (Part Five)
  • Importing Access Data (Part Six)
  • Importing Access Data (Part Seven)
  • Importing Excel Data (Part One)
  • Importing Excel Data (Part Two)
  • Importing Excel Data (Part Three)
  • Importing Excel Data (Part Four)
  • Importing Excel Data (Part Five)
  • Integrating Data with Relationships (Part One)
  • Integrating Data with Relationships (Part Two)
  • Integrating Data with Relationships (Part Three)
  • Creating a PivotTable with PowerPivot Data (Part One)
  • Creating a PivotTable with PowerPivot Data (Part Two)
  • Creating a PivotTable with PowerPivot Data (Part Three)
  • Creating a PivotTable with PowerPivot Data (Part Four)
  • Creating a PivotTable with PowerPivot Data (Part Five)
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Step-By-Step (Part Five)
  • Step-By-Step (Part Six)
  • Step-By-Step (Part Seven)
  • Step-By-Step (Part Eight)
  • Step-By-Step (Part Nine)
  • Step-By-Step (Part Ten)
  • Step-By-Step (Part Eleven)
  • Step-By-Step (Part Twelve)
  • Step-By-Step (Part Thirteen)
  • Step-By-Step (Part Fourteen)
  • Step-By-Step (Part Fifteen)
  • Step-By-Step (Part Sixteen)
  • Step-By-Step (Part Seventeen)
  • Skill Sharpener
  • Case Study

Charting Pivoted Data

  • Section 1.1: Getting Started with PivotCharts
  • Creating a PivotChart from Scratch (Part One)
  • Creating a PivotChart from Scratch (Part Two)
  • Creating a PivotChart from Existing Data (Part One)
  • Creating a PivotChart from Existing Data (Part Two)
  • Adding Data to your Chart (Part One)
  • Adding Data to your Chart (Part Two)
  • Adding Data to your Chart (Part Three)
  • Pivoting Data (Part One)
  • Pivoting Data (Part Two)
  • Pivoting Data (Part Three)
  • Pivoting Data (Part Four)
  • Pivoting Data (Part Five)
  • Pivoting Data (Part Six)
  • Pivoting Data (Part Seven)
  • Pivoting Data (Part Eight)
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Step-By-Step (Part Five)
  • Step-By-Step (Part Six)
  • Step-By-Step (Part Seven)
  • Step-By-Step (Part Eight)
  • Step-By-Step (Part Nine)
  • Skill Sharpener
  •  Section 1.2: Using the PivotChart Tools Tabs
  • Using the Design Tab (Part One)
  • Using the Design Tab (Part Two)
  • Using the Design Tab (Part Three)
  • Using the Design Tab (Part Four)
  • Using the Design Tab (Part Five)
  • Using the Design Tab (Part Six)
  • Using the Design Tab (Part Seven)
  • Using the Layout Tab (Part One)
  • Using the Layout Tab (Part Two)
  • Using the Layout Tab (Part Three)
  • Using the Layout Tab (Part Four)
  • Using the Layout Tab (Part Five)
  • Using the Layout Tab (Part Six)
  • Using the Layout Tab (Part Seven)
  • Using the Layout Tab (Part Eight)
  • Using the Format Tab (Part One)
  • Using the Format Tab (Part Two)
  • Using the Format Tab (Part Three)
  • Using the Format Tab (Part Four)
  • Using the Format Tab (Part Five)
  • Using the Format Tab (Part Six)
  • Using the Format Tab (Part Seven)
  • Using the Analyze Tab (Part One)
  • Using the Analyze Tab (Part Two)
  • Using the Analyze Tab (Part Three)
  • Using the Analyze Tab (Part Four)
  • Using the Analyze Tab (Part Five)
  • Using the Analyze Tab (Part Six)
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Step-By-Step (Part Five)
  • Step-By-Step (Part Six)
  • Step-By-Step (Part Seven)
  • Step-By-Step (Part Eight)
  • Step-By-Step (Part Nine)
  • Step-By-Step (Part Ten)
  • Skill Sharpener
  •  Section 1.3: Formatting a PivotChart
  • Renaming Fields (Part One)
  • Renaming Fields (Part Two)
  • Renaming Fields (Part Three)
  • Changing the Chart Type (Part One)
  • Changing the Chart Type (Part Two)
  • Changing the Chart Type (Part Three)
  • Changing the Chart Type (Part Four)
  • Changing the Chart Type (Part Five)
  • Changing the Chart Type (Part Six)
  • Changing the Chart Type (Part Seven)
  • Applying a Chart Style (Part One)
  • Applying a Chart Style (Part Two)
  • Applying a Chart Style (Part Three)
  • Manually Formatting Chart Elements (Part One)
  • Manually Formatting Chart Elements (Part Two)
  • Manually Formatting Chart Elements (Part Three)
  • Manually Formatting Chart Elements (Part Four)
  • Manually Formatting Chart Elements (Part Five)
  • Manually Formatting Chart Elements (Part Six)
  • Manually Formatting Chart Elements (Part Seven)
  • Manually Formatting Chart Elements (Part Eight)
  • Manually Formatting Chart Elements (Part Nine)
  • Manually Formatting Chart Elements (Part Ten)
  • Manually Formatting Chart Elements (Part Eleven)
  • Manually Formatting Chart Elements (Part Twelve)
  • Changing the Layout of Chart Elements (Part One)
  • Changing the Layout of Chart Elements (Part Two)
  • Changing the Layout of Chart Elements (Part Three)
  • Changing the Layout of Chart Elements (Part Four)
  • Changing the Layout of Chart Elements (Part Five)
  • Changing the Layout of Chart Elements (Part Six)
  • Changing the Layout of Chart Elements (Part Seven)
  • Changing the Layout of Chart Elements (Part Eight)
  • Changing the Layout of Chart Elements (Part Nine)
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Step-By-Step (Part Five)
  • Step-By-Step (Part Six)
  • Step-By-Step (Part Seven)
  • Skill Sharpener
  •  Section 1.4: Advanced PivotChart Tasks
  • Creating a PivotChart Based on External Data (Part One)
  • Creating a PivotChart Based on External Data (Part Two)
  • Creating a PivotChart Based on External Data (Part Three)
  • Creating a PivotChart Based on External Data (Part Four)
  • Creating a PivotChart Based on External Data (Part Five)
  • Creating a PivotChart Based on External Data (Part Six)
  • Creating a PivotChart Based on External Data (Part Seven)
  • Creating a PivotChart Based on External Data (Part Eight)
  • Creating a Slicer (Part One)
  • Creating a Slicer (Part Two)
  • Creating a Slicer (Part Three)
  • Creating a Slicer (Part Four)
  • Creating a Slicer (Part Five)
  • Creating a PivotTable and PivotChart from a Scenario (Part One)
  • Creating a PivotTable and PivotChart from a Scenario (Part Two)
  • Creating a PivotTable and PivotChart from a Scenario (Part Three)
  • Creating a PivotTable and PivotChart from a Scenario (Part Four)
  • Creating a PivotTable and PivotChart from a Scenario (Part Five)
  • Creating a PivotTable and PivotChart from a Scenario (Part Six)
  • Creating a PivotTable and PivotChart from a Scenario (Part Seven)
  • Creating a PivotTable and PivotChart from a Scenario (Part Eight)
  • Creating a PivotTable and PivotChart from a Scenario (Part Nine)
  • Creating PivotCharts with PowerPivot Data (Part One)
  • Creating PivotCharts with PowerPivot Data (Part Two)
  • Creating PivotCharts with PowerPivot Data (Part Three)
  • Creating PivotCharts with PowerPivot Data (Part Four)
  • Creating PivotCharts with PowerPivot Data (Part Five)
  • Creating PivotCharts with PowerPivot Data (Part Six)
  • Creating PivotCharts with PowerPivot Data (Part Seven)
  • Creating PivotCharts with PowerPivot Data (Part Eight)
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Step-By-Step (Part Five)
  • Step-By-Step (Part Six)
  • Step-By-Step (Part Seven)
  • Step-By-Step (Part Eight)
  • Step-By-Step (Part Nine)
  • Skill Sharpener
  • Case Study

Advanced Excel Tasks

  • Section 1.1: Using Advanced Functions
  • Using the PMT Function (Part One)
  • Using the PMT Function (Part Two)
  • Using the PMT Function (Part Three)
  • Using the PMT Function (Part Four)
  • Using the PMT Function (Part Five)
  • Using the PMT Function (Part Six)
  • Using the FV Function (Part One)
  • Using the FV Function (Part Two)
  • Understanding Logical Functions (Part One)
  • Understanding Logical Functions (Part Two)
  • Understanding Logical Functions (Part Three)
  • Understanding Logical Functions (Part Four)
  • Understanding Logical Functions (Part Five)
  • Understanding Logical Functions (Part Six)
  • Understanding Logical Functions (Part Seven)
  • Understanding Logical Functions (Part Eight)
  • Using Logical Functions (Part One)
  • Using Logical Functions (Part Two)
  • Using Logical Functions (Part Three)
  • Using Logical Functions (Part Four)
  • Using IFERROR with Array Formulas (Part One)
  • Using IFERROR with Array Formulas (Part Two)
  • Using IFERROR with Array Formulas (Part Three)
  • Using IFERROR with Array Formulas (Part Four)
  • Using IFERROR with Array Formulas (Part Five)
  • Using IFERROR with Array Formulas (Part Six)
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Step-By-Step (Part Five)
  • Skill Sharpener
  • Section 1.2: Using the VLOOKUP Function
  • Understanding VLOOKUP and HLOOKUP
  • Using VLOOKUP to Find Data (Part One)
  • Using VLOOKUP to Find Data (Part Two)
  • Using VLOOKUP to Find Data (Part Three)
  • Using VLOOKUP to Find Data (Part Four)
  • How to Find an Exact Match with VLOOKUP (Part One)
  • How to Find an Exact Match with VLOOKUP (Part Two)
  • Finding an Approximate Match with VLOOKUP (Part One)
  • Finding an Approximate Match with VLOOKUP (Part Two)
  • Using VLOOKUP as an Array Formula (Part One)
  • Using VLOOKUP as an Array Formula (Part Two)
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Step-By-Step (Part Five)
  • Skill Sharpener
  • Section 1.3: Using Custom AutoFill Lists
  • What is an AutoFill List?
  • Creating a Custom AutoFill List (Part One)
  • Creating a Custom AutoFill List (Part Two)
  • Creating a Custom AutoFill List (Part Three)
  • Creating a Custom AutoFill List (Part Four)
  • Creating a Custom AutoFill List (Part Five)
  • Using a Custom AutoFill List
  • Modifying a Custom AutoFill List
  • Deleting a Custom AutoFill List
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Step-By-Step (Part Five)
  • Step-By-Step (Part Six)
  • Skill Sharpener
  • Section 1.4: Linking, Consolidating, and Combining Data
  • Linking Workbooks (Part One)
  • Linking Workbooks (Part Two)
  • Linking Workbooks (Part Three)
  • Consolidating Workbooks (Part One)
  • Consolidating Workbooks (Part Two)
  • Consolidating Workbooks (Part Three)
  • Consolidating Workbooks (Part Four)
  • Consolidating Workbooks (Part Five)
  • Combining Worksheets (Part One)
  • Combining Worksheets (Part Two)
  • Combining Worksheets (Part Three)
  • Pivoting Consolidated Data (Part One)
  • Pivoting Consolidated Data (Part Two)
  • Pivoting Consolidated Data (Part Three)
  • Pivoting Consolidated Data (Part Four)
  • Pivoting Consolidated Data (Part Five)
  • Pivoting Consolidated Data (Part Six)
  • Pivoting Consolidated Data (Part Seven)
  • Pivoting Consolidated Data (Part Eight)
  • Pivoting Consolidated Data (Part Nine)
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Step-By-Step (Part Five)
  • Step-By-Step (Part Six)
  • Step-By-Step (Part Seven)
  • Skill Sharpener
  • Case Study

 

Macros, Visual Basic, and Excel Programming

  • Section 1.1: Creating a Basic Macro
  • Recording a Macro (Part One)
  • Recording a Macro (Part Two)
  • Editing a Macro (Part One)
  • Editing a Macro (Part Two)
  • Running a Macro
  • Understanding Macro Security (Part One)
  • Understanding Macro Security (Part Two)
  • Understanding Macro Security (Part Three)
  • Understanding Macro Security (Part Four)
  • Understanding Macro Security (Part Five)
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Step-By-Step (Part Five)
  • Step-By-Step (Part Six)
  • Skill Sharpener
  • Section 1.2: Visual Basic and Macros
  • Opening the Visual Basic Editor (Part One)
  • Opening the Visual Basic Editor (Part Two)
  • Understanding the Visual Basic Editor (Part One)
  • Understanding the Visual Basic Editor (Part Two)
  • Adding Code to your Macro
  • Adding Comments to Visual Basic Code (Part One)
  • Adding Comments to Visual Basic Code (Part Two)
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Skill Sharpener
  • Section 1.3: More Macro Tasks
  • What are Relative References?
  • Recording a Relative Reference Macro
  • Running a Relative Reference Macro
  • Assigning a Keyboard Shortcut to a Macro (Part One)
  • Assigning a Keyboard Shortcut to a Macro (Part Two)
  • Copying a Macro from a Workbook or Template (Part One)
  • Copying a Macro from a Workbook or Template (Part Two)
  • Copying a Macro from a Workbook or Template (Part Three)
  • Copying a Macro from a Workbook or Template (Part Four)
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Step-By-Step (Part Five)
  • Step-By-Step (Part Six)
  • Skill Sharpener
  • Section 1.4: Advanced Visual Basic Tasks
  • Declaring Variables
  • Iteration Over a Range
  • Prompting for User Input
  • Prompting for User Input
  • Using If, Then, and Else Statements (Part One)
  • Using If, Then, and Else Statements (Part Two)
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Step-By-Step (Part Five)
  • Step-By-Step (Part Six)
  • Skill Sharpener
  • Case Study 

Entry requirements

Students must have basic literacy and numeracy skills.

Minimum education

Open entry. Previous schooling and academic achievements are not required for entry into this course.

Computer requirements

Students will need access to a computer and the internet.

Minimum specifications for the computer are:

Windows:

  • Microsoft Windows XP, or later
  • Modern and up to date Browser (Internet Explorer 8 or later, Firefox, Chrome, Safari)

MAC/iOS

  • OSX/iOS 6 or later
  • Modern and up to date Browser (Firefox, Chrome, Safari)

All systems

  • Internet bandwidth of 1Mb or faster
  • Flash player or a browser with HTML5 video capabilities(Currently Internet Explorer 9, Firefox, Chrome, Safari)

Students will also need access the following applications:

Adobe Acrobat Reader

1.  Who are Courses For Success?

Courses For Success is a global course platform that started in 2008 with 5 courses, since then we have grown to over 10,000 online courses. As our courses are delivered online via the internet, we sell our courses worldwide.

Our courses span across many categories including Academic, Animal, Beauty, Business, Career, Counseling, Creative & Media, Health & Therapy, Hobbies & Trades, IT, Personal Development, Sports & Fitness.

Some of the companies we work with include Groupon, Living Social, CNN, Entrepreneur, Mashable, Reed UK, Stack Social and many more.

2.  Is there a refund/cancellation policy?

Yes, we have a 7-day money-back refund guarantee. Just send us an email to email/info)(coursesforsuccess.com with the subject Courses For Success Refund so we can accommodate your request.

3.  What is the FREE Personal Success Training Program?

The Personal Success Training Program was developed by Courses For Success to help our customers achieve success. Currently, we are offering this program for FREE with every course or bundle purchase this month. This is a limited time offer! We have received thousands of reviews for this program, please see: Personal Success Training Program Reviews

4.  Are there any requirements to study this course?

No, anyone who has an interest in learning more about this subject matter is encouraged to take our course. There are no entry requirements to take this course.

5.  Do I require to have finished high school to complete this course?

No, you do not require a High School Diploma or to have finished school to study this course, this course is open to anyone who would like to take this course.

6.  What if English is not my first language?

This course is provided in English, however, due to the digital nature of our training, you can take your time studying the material and make use of tools such as google translate and Grammarly.

7.  Is this course online or conducted in person?

All our courses are accessible online on any device. You may complete them at your own pace and at your own time.

8.  How do I receive my course?

After you have completed the payment, you will receive a confirmation email and tax receipt. You will also receive an email containing your course login details (username and password), as well as instructions on how to access and log in to your course via the internet with any device, please check your junk/spam folder in the event that you do not receive the email.

9.  When does this course start?

Providing you have internet access you can start this course whenever you like, just go to the login page and insert your username and password and you can access the online material.

10.  What is online learning like?

Online learning is easy, if not easier than a traditional academic situation. By studying an online course, the usual boundaries caused by location and time constraints are eliminated, meaning you are free to study where and when you want at your own pace. Of course, you will need to be able to self-manage your time and be organized, but with our help, you’ll soon find yourself settling into a comfortable rhythm of study.

11.  What computer skills do I need for my course?

You don't need to be a computer expert to succeed with our online training, but you should be comfortable typing, using the internet and be capable of using common software (such as Microsoft word).

12.  How long will you have access to the online course?

There is no time limit for completing this course, it can be studied in your own time at your own pace. Once you have purchased this course you will have unlimited lifetime access, meaning you can access this course whenever you want.

13.  How long will my course take?

Individual courses are designed to be completed within 6-8 hours.

If you choose a course bundle, simply multiply the above hours by the number of courses included in the bundle.
For example:

  • 2 course bundle is 2 x 6-8 hours = 12-16 hours
  • 3 course bundle is 3 x 6-8 hours = 18-24 hours
  • 5 course bundle is 5 x 6-8 hours = 30-40 hours
  • 10 course bundle is 10 x 6-8 hours = 60-80 hours
14.  Do I need to buy textbooks?

All the required material for your course is included in the online system, you do not need to buy anything else.

15.  Is the course interactive?

Yes, all our courses are interactive.

16.  Is there an assessment or exam?

Yes, you will be required to complete a multiple-choice test online at the end of your course, you can do this test as many times as you require.

17.  What type of certificate will I receive?

You will receive a Certificate of Completion that is applicable worldwide, which demonstrates your commitment to learning new skills. You can share the certificate with your friends, relatives, co-workers and employers. Also, include it in your resume/CV, professional social media profiles and job applications.

Wendy Sue Hunt - 5 STAR REVIEW
"If you are considering taking any “Courses for Success”, I would highly recommend it. I have always been a firm believer it’s important to always sharpen your skills. You are never too old to learn more. I found the courses very helpful, interesting and easy to understand.
The term “Courses for Success” helped me in my current position to succeed. After completing the courses, I gave my manager the completion certificates. Recently I received a promotion too."
Valencia Marie Aviles - 5 STAR REVIEW
"I had a very good experience with my course. It has helped me to get multiple jobs and prepared me for almost everything I would need to know. The course was very informative and easy to understand and broken up perfectly to be done in a short amount of time while still learning a good amount! I would recommend Courses for Success to anyone trying to get abs certifications for job advancements, it is well worth it!"
ELENA GRIFFIN - 5 STAR REVIEW
"I have absolutely enjoyed the materials from Courses for Success. The materials are easy to understand which makes learning enjoyable. Courses for Success have great topics of interest which make you come back for more.
Thank you Courses for Success for being part of my learning journey and making education affordable!"

Our completion certificates are very valuable and will help you progress in your work environment and show employers how committed you are to learn new skills, you might even get a promotion.

18.  Will this course be credited by universities?

No, it is not equivalent to a college or university credit.

19.  Am I guaranteed to get a job with this certificate?

This course will give you the skills you need to help you obtain employment, but it’s up to you if you get the job or not.

20.  How will this course assist me with my career?

Studying and completing this course will show employers that you have the knowledge in this field, additionally you will gain more confidence in this area of expertise.

21.  How long is the certificate valid for?

The Certificates are valid for life and do not need renewing. 

22.  Can I take more than one course at a time?

Courses are studied online at your own pace and you are free to study as many or as few courses as you wish, we also offer online course bundles that allow you to save on additional courses so that you may get all the topics related to your training goals in one go.

23.  What are the Payment Methods available? Is there a payment plan?

We accept payments via PayPal, Credit Card and Bank Transfer. *For faster transaction Credit Card payments are preferred. Please purchase online via our website course product page or contact us at email/info)(coursesforsuccess.com, to pay via bank transfer.

24.  Can I purchase for multiple people?

Yes, you can do this by purchasing individually via website or send us a request via email at email/info)(coursesforsuccess.com

25.  Can I request for an invoice before purchase?

Yes, you can request for an invoice via email at email/info)(coursesforsuccess.com

26.  Purchase for a gift?

Yes, you can purchase this course as a gift, simply send an email to email/info)(coursesforsuccess.com, with the course details and we can accommodate this.

27.  Can I create my own course bundle?

Yes, you can customize your own bundle. Please send us the complete list with the exact course link of the courses you'd like to bundle up via email email/info)(coursesforsuccess.com and we will create them for you. *Each course access, time of completion and certification varies depending on the course type.

28.  How will I contact Courses For Success if I have any questions?

You can contact our support team, at any time through live chat on our website, or email at email/info)(coursesforsuccess.com, or by calling one of our phone numbers depending on which country you are in.  

We provide a 7 Day Money Back Refund on all Courses

Now Only AU$199 Save AU$70 (26%)
OFF RRP AU$269
or 4 interest-free payments of $49.75 with Learn more
Delivery Method

Online - Certificate

Get Info Pack

Special Offer

 

Receive The Personal Success Training Program FREE, When You Purchase This Course - Limited Time Remaining!  (Value $600)

 

The Personal Success Training Program Helps You Stay Focused To Achieve Your Goals!
Benefits:
  • How to layout a Success Plan.
  • Get where you want to be in life.
  • How to unclutter your mind to succeed.
  • Achieve your dreams using your imagination.
  • How to have faith in yourself.
Features:
  • 12 month online access,  24/7 anywhere.
  • Complement your individual course purchase.
  • Internationally recognized by the IAOTS.
  • Thousands of positive reviews.
  • Limited Time Offer - Ends Soon.
 

Share this course

Course Summary

Course ID: 002EX10ADOC
Delivery Mode: Online
Access: Lifetime Course Access
Time: Study at your own pace
Duration: 6 - 8 Hours
Qualification: Certificate

Learn More With Course Bundles

Popular Courses and Bundles

Get a FREE Career Planner