Microsoft Excel - Level 2 - Essentials

This course builds on the foundations to teach you how to use the essential tools in Excel.
4.2 (12 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
44 students enrolled
$20
Take This Course
  • Lectures 41
  • Contents Video: 2 hours
  • Skill Level Intermediate Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 9/2013 English

Course Description

This course builds on the Excel Level 1 foundations course to teach you how to use the essential tools in Excel. You’ll learn V and H lookup, CountIf and SumIf and database functions. You’ll work with charts, graphs, filters and lists, import different file formats (like XML data) and track changes in a spreadsheet.

What are the requirements?

  • Basic understanding of Excel

What am I going to get from this course?

  • This course provides you with solid knowledge in the most important tools in Excel. Once you have finished the course you will know more than most people who are using Excel each day. You'll have a powerful skill-set that you can use in building spreadsheets that make you even more efficient in your role.

What is the target audience?

  • If you work with Excel on a regular basis there is a huge amount to gain by being confident at this level. There are many features to learn and this course will save you hours and hours of work as you start to start make the most of the functionality of Excel.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Sharing workbooks with others
00:24

This section includes the exercise files for Excel Level 2. Please download these before you start the course.

Save and Send options
Preview
03:18
Using Comments In Excel
Preview
02:25
Using Hyperlinks
Preview
02:22
Section 2: Protecting and maintaining a workbook
Introduction
Preview
00:25
Customising advanced properties
Preview
02:50
Saving as a template
02:46
Importing and Exporting XML data
06:49
Protecting a worksheet and workbook
04:45
Section 3: Track changes
Introduction
Preview
00:19
Turning on track changes
Preview
03:21
Accept and Reject changes
02:25
Sharing workbooks
02:25
Restricting Access to a shared workbook
01:04
Section 4: Naming Cells
Introduction
Preview
00:15
Naming a cell or a range of cells
Preview
03:49
Moving to named cells
01:30
To delete or edit a named cell
02:04
Section 5: Data lists
Introduction
Preview
00:23
Adding cutsom lists
Preview
04:55
Advanced sort options
03:27
Applying conditional Formatting
04:56
Applying Filters
05:35
Applying custom filters
01:40
Subtotalling a list
03:14
Grouping and outlining data
03:02
Data validation
05:06
Drop down menus using validation lists
05:07
Creating a table to manage lists
04:19
Section 6: Advanced Formulae
Introduction
Preview
00:22
V and H lookup Functions
Preview
06:07
SUMIF Function
03:20
COUNTIF Function
01:14
Arrays
02:40
Database Functions
06:38
Section 7: Advanced Charts and Graphs
Introduction
Preview
00:16
Trendlines
Preview
02:37
Dual Axes
03:00
Saving a Chart Template
03:19
Sparklines
03:37
Advanced Sparklines options
05:39

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

eLearnExcel, Leading provider of Online Excel training

Our online eLearning courses build on 20 years experience of classroom training. Training is our business. The courses are delivered by our expert tutors and we know where topics become complex and need better explanations because we see it every day in our classrooms.

Some of the world’s most prominent businesses choose us to teach their employees Excel – including Google, Facebook, Pfizer, Zurich, Aer Lingus, Allianz, HSBC, Intel, Dell, KPMG – even Microsoft use our Excel courses to train their employees on Excel.

Ready to start learning?
Take This Course