Excel 2010: Advanced
Course
Online
*Indicative price
Original amount in USD:
$ 47
Description
-
Type
Course
-
Level
Intermediate
-
Methodology
Online
-
Duration
Flexible
-
Start date
Different dates available
Microsoft Excel is a mainstay for many Office users. This series will allow you to advance your basic skills to the next level so you can transform everyday spreadsheets into elegant and powerful business assets.
Facilities
Location
Start date
Start date
About this course
In this Excel 2010: Advanced series, new and longtime Excel users will learn how to take core skills to the next level by exploring advanced functions and chart features, connecting to external data, utilizing data tools, leveraging auditing features, and gaining insight with what-if features. You’ll also learn how to create macros and work with basic VBA code to customize and automate your work. Does EVERY Excel user need to know these skills? No, but if you want to use Excel beyond simple data entry and calculations, to its fullest potential and therefore be able to reach your own full potential, this series will help get you there.
Reviews
Subjects
- MS Excel
- Excel
- Conditional Formatting
- Data tables
- Pivot tables
- Advanced Formulas
- Tables & Formatting
- Advanced Charting
- Pivot Reporting
- VBA & Macros
- Simulations & Solver
- Advanced calculation
- Excel Productivity
Teachers and trainers (1)
Name Name
Teacher
Course programme
- Using Lookup Functions
- Using Text Functions
- Breaking Apart Text Entries
- Using Date & Time Functions
- Using the Net Workdays Function
- Using Logical Functions & Fixing Errors
- Using Text in Calculations
- Using Financial Functions
- Using the Cumulative Interest Payment Function
- Using Aggregate vs. Math Functions
- Creating Subtotals
- Working with Outlined Data
- Manually Creating Subtotals & Outlines
- Creating Custom Views
- Constructing PivotTables
- Modifying PivotTable Calculations
- Setting PivotTable Properties
- Using Filters & Slicers in the PivotTable
- Using the Report Filter & Updating Data
- Working with PivotTable Data in Formulas & PivotCharts
- Adding a Secondary Chart Axis
- Working with a Scatter Chart
- Hidden & Empty Cell Settings, Formatting Error Bars
- Adding a Trendline
- Importing Data & Adding Hyperlinks
- Converting Text to Columns
- Linking to Databases & Removing Duplicate Records
- Consolidating Data
- Validating & Protecting Data
- Working with Circular References
- Tracing Precedents & Dependents
- Evaluating Formulas
- Using the Watch Window
- Error Checking
- Finding an Input Value with Goal Seek
- Displaying Options via Scenarios
- Including Variable Values through Data Tables
- Macro Concepts
- Creating a Basic Macro
- Manipulating Cell & Range References
- A Brief Introduction to VBA
- Viewing & Editing VBA in Excel
- Making Macros Accessible
- Applying Security Settings
- Credits
Additional information
Take basic Excel skills to the next level by integrating and extending basic skills to create elegant solutions
See how advanced functions and data tools automate routine tasks and provide easy answers to not-so-easy questions
Discover the power of simplifying complex data through advanced charts and pivot tables
Audit calculations, manage errors and ask find answer to your what if…questions
Import & connect to external data
Create macros and make simple edits using VBA to automate routine tasks
LENGTH
Total Run Time: 6 hrs
Excel 2010: Advanced
*Indicative price
Original amount in USD:
$ 47