Cademy logoCademy Marketplace
  • Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

Course Images

Microsoft Excel in Depth: In-House Training

Microsoft Excel in Depth: In-House Training

By IIL Europe Ltd

  • 30 Day Money Back Guarantee
  • Completion Certificate
  • 24/7 Technical Support

Highlights

  • Delivered Online or In-Person

  • Delivered at your location

  • UK Wide

  • Full day

  • All levels

Description

Microsoft Excel® in Depth: In-House Training

The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects.

This practical course provides a solid background of the features of Excel and a deeper understanding of its features, benefits and uses. This is not a beginner's course in Excel. You will learn some advanced features such as Pivot Tables, Charting, Tables, Sorting, Filtering and Functions.

The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects.

What you Will Learn

You'll learn how to:

  • Use functions like IF, AVERAGE, SUMIF, SUMIFS, SUMPRODUCT, INDEX, MATCH, CHOOSE, DATE, and many more

  • Create meaningful charts

  • Use pivot tables

  • Use Conditional Formatting, Data Validation

  • Take advantage of using Named ranges, do sorting, filtering, tables

Getting Started

  • The building blocks of Excel, built-in functions, will be examined

  • The basics of formatting your data will be examined

  • Shortcuts and data manipulation will be explored

  • Built-in features like those mentioned in the 'What you will learn' section above will be explored in detail

Excel Functions - VLOOKUP, IF, INDEX, MATCH, CHOOSE, SUMIF, SUMIFS, SUMPRODUCT, DATE, so many more

Using Named ranges, Data Validation, Sorting, and Filtering

  • Learn the Name manager;

  • Learn the difference between local and global names;

  • Ensure correct access to linked workbooks;

  • Ensure data accuracy;

  • Learn how to use cascading data validation (for example, once a user chooses 'cars', another cell allows only Ford, Toyota, etc.);

  • Sorting by more than 3 fields;

  • Filtering by font, pattern, or value;

  • See your data based on things like dates in the 3rd quarter, or fields where quantity x price is greater than some fixed value

Conditional formatting and data formatting

  • Make relevant data stand out

  • Isolate highs and lows

  • Make error cells invisible

  • Learn about Data bars, Icon sets, and Color scales

  • Highlight differences between worksheets

  • Learn all the codes in the Format/Number list

  • Using cell Styles

  • Learn all about alignment, protection, borders, colors and more

Pivot Tables

  • Learn how to summarize large amounts of data with a few clicks

  • Learn various ways of presenting the data

  • Learn the various pivot table tools

  • Learn how to customize and format a pivot table to suit your needs

  • Learn how to group data

  • Learn how to use the various options to present your data

Charts

  • Learn how to create a chart with one keystroke!

  • Learn the 11 types of built-in charts

  • Learn how to create a chart with one keystroke!

  • Learn how to customize the charts to make the information tell the right story

  • Learn how to use the design, layout, and formatting available to charts in Excel 2007

  • Learn embedded charts versus chart sheets

  • Learn how to use modify all the pieces of a chart

Array formulas

  • Learn how to use the most powerful formulas in Excel

  • Learn how to combine many formulas into one compact array-formula

  • Learn the real power of these formulas and why regular formulas can't do the job

  • Learn how to use built-in array formulas, like TREND or TRANSPOSE

About The Provider

IIL Europe Ltd

Tags

Reviews

+ Add Review