×
×

Excel 2010 Advanced

What does this course offer you?

In this elearning course, you will learn advanced techniques for working with Excel 2010. You will import and export data and use style sheets. You will learn how to deal with filters and functions. In addition, you will deal with the topic of Pivot Tables and Pivot Charts, which allow flexible and intelligent evaluation of your data. You will find out how calculations can be visualised using professional-looking charts. In your calculations, you will draw on values from various spreadsheets. Finally, you will learn about the wide range of options for working with the date and time.

The primary subject matter of this course:

Advanced editing

  • Naming cell ranges
  • Formating cells by formula results
  • Creating user-defined cell formats
  • Conditional formatting
  • Pasting content
  • Importing or exporting files
  • Hiding and unhiding table areas
  • Calculating partial results
  • Data tables for calculations
  • Protecting workbooks

Handling data

  • User-defined sorting
  • Advanced filter techniques
  • The search filter
  • Using cell references to other sheets
  • Setting up cell references to other workbooks
  • Editing shortcuts
  • Creating and assigning styles
  • Creating sample templates
  • Creating workbooks with sample templates

Functions

  • Date and time functions
  • Creating interlaced functions
  • Mathematical functions
  • Statistical functions
  • Financial functions
  • S reference function
  • W reference function
  • Logical functions
  • Using formula auditing

Working with the date and time

  • Basic information on time calculations in Excel
  • Carrying out simple operations with time information
  • Working with date and time functions
  • Practical applications

PivotTables and Pivot Charts

  • Inserting PivotTables
  • Allocating PivotFields
  • Defining layout for PivotTables
  • Filtering PivotTables
  • Working with slicers
  • Sorting PivotTables
  • Creating a drilldown
  • Creating PivotCharts

Using special design options

  • Inserting screenshots
  • Showing formulas in text fields
  • Adding comments to tables
  • Undertaking validation formula for data entry
  • Allowing data entry from a list
  • Using hyperlinks
What does this course include?

Alongside the instructional content, practice exercises and tests are included.
Number of lessons: 54
Learning Hours: 6