Microsoft Excel Intermediate
4.5 (16 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
3,312 students enrolled

Microsoft Excel Intermediate

Improving your performance by learning some of the more popular Excel features
4.5 (16 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
3,312 students enrolled
Created by ZandaX Training
Last updated 2/2019
English
English [Auto-generated]
Current price: $13.99 Original price: $19.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 3.5 hours on-demand video
  • 2 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • This hands-on one-day training course has been designed to give delegates a solid understanding of more advanced tools and concepts used in Excel 2007, 2010, 2013 or 2016, in order to increase their knowledge and productivity.
Requirements
  • Delegates should have a good working knowledge and understanding of the concepts covered in the Introduction course.
Description

MODULE 1:  Advanced File Tasks

Learning outcomes:  A look at some important administrative features which are useful for managing and controlling Excel files.

Topics covered:

  • Saving and File Management

  • Converting and Encrypting Files

  • File Properties and Digital Signatures

  • File Accessibility and Compatibility

MODULE 2:  Working with Functions and Formulas

Learning outcomes:  Some key formulas and functions essential to Excel users along with  features to help manage formulas, functions and ranges.

Topics covered:

  • Formulas with Absolute References

  • Autosum Functions (SUM & AVERAGE)

  • IF and Nested Functions

  • Working with Named Ranges

  • Array Functions (SUMIF & AVERAGEIF)

  • Formula Auditing

  • Text Functions

MODULE 3:  Managing Tables in Microsoft Excel

Learning outcomes:  Managing spreadsheet data in table format, an excellent feature to administrate large sets of data.

Topics covered:

  • Creating Excel Tables

  • Working with Records and Filters

  • Advanced Filters

MODULE 4:  Data Tools in Excel

Learning outcomes:  Features to help with managing spreadsheet data making it a less daunting and repetitive task to manage the data.

Topics covered:

  • Text to Columns

  • Flash Fill

  • Remove Duplicates

  • Data Validation

  • Consolidate

MODULE 5:  Doing More with Charts in Excel

Learning outcomes:  Developing your ability to effectively create charts and format them specific to the reader

Topics covered:

  • Trendlines

  • Error Bars

  • Working with Axis Options

  • Advanced Chart Formatting

MODULE 6:  Sparklines

Learning outcomes:  Use Sparklines to help analyse data by creating small customisable  charts within cells. Edit and format the Sparklines and data points to  help your data stand out

Topics covered:

  • Creating Sparklines

  • Editing Sparklines

Who this course is for:
  • Users with a basic understanding of Microsoft Excel 2007, 2010, 2013 or 2016 who want to take their knowledge of the basic features further in a short space of time.
Course content
Expand all 53 lectures 03:15:41
+ Advanced File Tasks
9 lectures 26:30
File Properties and Digital Signatures - Overview
00:59
File Properties and Digital Signatures
03:26
File Accessibility and Compatibility - Overview
01:51
File Accessibility and Compatibility
06:13
+ Working with Functions and Formulas
15 lectures 01:08:17
Introduction
01:56
Formulas with References - Overview
00:59
Absolute References - Overview
01:49
Formulas with Absolute References
06:25
Autosum Functions (SUM & AVERAGE) - Overview
02:56
Autosum Functions (SUM & AVERAGE)
04:43
IF and Nested Functions - Overview
02:38
IF and Nested Functions
13:10
Working with Named Ranges - Overview
01:49
Working with Named Ranges
04:39
Array Functions (SUMIF & AVERAGEIF) - Overview
02:07
Array Functions (SUMIF & AVERAGEIF)
06:50
Array Functions (SUMIF & AVERAGEIF)
08:10
Formula Auditing - Overview
01:49
Formula Auditing
08:17
+ Managing Tables in Microsoft Excel
8 lectures 29:39
Introduction
01:19
Creating Excel Tables - Overview
00:56
Creating Excel Tables
09:07
Working with Records and Filters - Overview
00:42
Working with Records and Filters
02:12
Working with Records and Filters
09:32
Advanced Filters - Overview
01:22
Advanced Filters
04:29
+ Data Tools in Excel
9 lectures 33:39
Introduction
01:54
Text to Columns - Overview
01:19
Text to Columns
05:34
Remove Duplicates - Overview
01:12
Remove Duplicates
04:44
Data Validation - Overview
01:00
Data Validation
09:53
Consolidate - Overview
01:44
Consolidate
06:19
+ Doing More with Charts in Excel
9 lectures 29:42
Introduction
01:23
Trendlines - Overview
01:00
Trendlines
04:46
Error Bars - Overview
00:39
Error Bars
04:54
Working with Axis Options - Overview
01:16
Working with Axis Options
08:36
Advanced Chart Formatting - Overview
00:54
Advanced Chart Formatting
06:14
+ Sparklines
2 lectures 06:35
Sparklines - Overview
02:01
Sparklines
04:34