Excel Advanced Essentials


Excel Advanced Essentials

Course Code EXL2013
Qualification Certificate
Payment Options Upfront & Payment Plans
Delivery Online & Correspondence
Duration 25 Hours

Excel 2013 Advanced Essentials
 

This advanced Microsoft Excel training course includes information on:

  • Advanced formulas and functions
  • Named ranges
  • Resolving formula errors
  • Consolidating data, removing duplicates, configuring data validation, and transposing data
  • Using outlining, grouping, and subtotal tools
  • Working with scenarios
  • Using data analysis tools (such as Solver and Goal Seek)
  • Creating and using PivotTables and PivotCharts
  • Using PowerPivot to integrate data from several different sources
  • Recording, editing, and using macros

Course Outline

Module 1: Advanced Formula Tasks

  • Understanding Relative and Absolute Cell References
  • Using Multiple Cell References
  • Using 3D References
  • Using Array Formulas
  • Review Questions

Module 2: Working with Named Ranges

  • Understanding Named Ranges
  • Defining Named Ranges
  • Editing Named Ranges
  • Deleting Named Ranges
  • Using Named Ranges in Formulas
  • Review Questions

Module 3: Using Advanced Functions

  • Using the PMT Function
  • Using the FV Function
  • Using VLOOKUP and HLOOKUP Functions
  • Using IF, AND, OR Functions
  • Review Questions

Module 4: Resolving Formula Errors

  • Tracing Formula Precedents and Dependents
  • Showing Formulas
  • Evaluating Formulas
  • Setting Error Checking Options
  • Using Error Option Buttons
  • Running an Error Check
  • Review Questions

Module 5: Managing Data

  • Consolidating Information
  • Removing Duplicates
  • Configuring Data Validation
  • Transposing Data
  • Converting Text to Columns
  • Review Questions

Module 6: Outlining and Grouping Data

  • Outlining Data
  • Showing and Hiding Outline Details
  • Grouping Data
  • Creating Subtotals
  • Removing Outlining and Grouping
  • Review Questions

Module 7: Working with Scenarios

  • Creating Scenarios
  • Loading Scenarios
  • Merging Scenarios
  • Editing Scenarios
  • Creating a Scenario Summary Report
  • Deleting Scenarios
  • Review Questions

Module 8: Using Solver

  • Setting up the Worksheet
  • Running Solver
  • Generating Reports and Scenarios with Solver
  • Modifying Constraints
  • Setting Solver Options
  • Review Questions

Module 9: Analyzing Data

  • Enabling the Analysis ToolPak
  • Using Data Analysis Tools
  • Using Goal Seek
  • Using Data Tables
  • Review Questions

Module 10: Advanced PivotTable Features

  • Creating a Basic PivotTable
  • Creating a Basic PivotChart
  • Using the PivotTable Fields Pane
  • Adding Calculated Fields
  • Sorting Pivoted Data
  • Filtering Pivoted Data
  • Review Questions

Module 11: Using PowerPivot

  • Enabling PowerPivot
  • Importing Access Data
  • Importing Excel Data
  • Integrating Data with Relationships
  • Creating a PivotTable with PowerPivot Data
  • Review Questions

Module 12: Using Macros

  • Recording a Macro
  • Writing a Macro using the Visual Basic Editor
  • Editing a Macro
  • Running a Macro
  • Review Questions
Student support

We live in a society where the pressures of daily living are high with financial expenses, personal and work commitments, and mortgage and rental obligations. Then there are the unexpected life challenges that also get thrown our way. With this in mind the thought of taking on study can be daunting for most people. Here at Learning Cloud we understand that life doesn’t run in a straight line it has many ups and downs.

As an enrolled student at Learning Cloud, you are entitled to access a variety of non-academic support services from the Student Services Unit. These supports are designed to walk beside you throughout your studies they will assist you in life’s ups and downs to provide you the best opportunity to successfully complete your chosen course.

STUDENT SERVICES PROGRAMS INCLUDE:

  • Careers Counselling Service
  • General Counselling Service
  • Disability Liaison Service
  • Retention & Engagement Service
  • Student Activities
  • Accommodation
  • E Counselling
  • Your-Tutor
  • Parent support
  • Reasonable Adjustment Plan (RAP)

Call our student support today on 0800 000 361 or Email Faculty

Get more information

Want more information about financial and student support? Fill out the enquiry form to the right and a study consultant will contact you with the details you need.

How will this course advance my career?

Learning Cloud programs have been developed in response to industry demand and are specifically designed to equip graduates with work-ready skills. Each participant will be trained and assessed in theory and in practical tasks and Real-world exercises are used throughout the program.

Studies prove, time and again, that college-educated workers earn more than those with only a high school qualification. College graduates often enjoy additional benefits, including greater job opportunities and promotions. Though the proof for greater earning potential exists, some might wonder whether the cost of the education warrants the overall expense in the long run.

College Graduate vs. Non-Graduate Earnings

The National Centre for Education Statistics (NCES) analyses employee earnings data biennially, according to education level. Findings indicate that workers with a qualification earn significantly more than those without. Since the mid-1980s, education has played a large part in potential wages, with bachelor's degree holders taking home an average of 66% more than those with only a high school diploma do. While college-educated workers' wages have increased over the past two decades, those with only a high school education have seen decreases in annual salaries in the same time period (nces.ed.gov).

How else will I benefit from studying with Learning Cloud?

  • Studying online or distance means you can study where you want and at your own pace.
  • Receive career-focused training with practical, hands-on learning.
  • All course materials are provided and all digital platforms are interactive, work on any device and designed to be fun.
  • Recognition of Prior Learning or Skills Recognition may be available for previous work experience, formal training or qualifications in this field.

THANK YOU