Microsoft Excel Intermediate
0.0 (0 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.
0 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft Excel Intermediate to your Wishlist.

Add to Wishlist

Microsoft Excel Intermediate

When you know the basics of Excel, but want to understand and produce more than a Sum formula!
New
0.0 (0 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.
0 students enrolled
Created by Simon Lambourne
Last updated 9/2017
English
English [Auto-generated]
Current price: $10 Original price: $95 Discount: 89% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 3.5 hours on-demand video
  • 25 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Create Advanced Formulas such as VLookup/HLookup
  • Apply Conditional Formatting to change cell colour based on High/Low Value
  • Use IF Statements to perform tests based on a condition
  • Manipulate Large Worksheets to make viewing large amounts of data easier
  • Link data between different spreadsheets
  • Use Date and Text formulas and functions for formatting and calculating dates and text
  • Use Paste Special to adjust how and what you paste. Including how to compare 2 sets of data together
View Curriculum
Requirements
  • You should have a basic knowledge of Microsoft Excel. From creating simple formulas and using AutoSum, to data entry.
  • Microsoft Excel installed (course is compatible with Excel 2007, Excel 2010, Excel 2013, or Excel 2016)
Description

This course is ideal for those who already use Excel at Introduction level and want to build on the knowledge you know. You will be introduced to a whole range of useful tools, shortcuts and functions. From managing large amounts of data to advanced functions such as VLookup, HLookup and IF Statements. Whatever you use Excel for in your work life, this course will give you the essential skills to take your Excel knowledge to the level expected in the working environment. 

Who is the target audience?
  • Anyone who wants to enhance their knowledge of Excel.
  • Users who know the basics and want to learn more advanced formulas, tools and shortcuts
Compare to Other Excel Courses
Curriculum For This Course
25 Lectures
03:33:00
+
Introduction
1 Lecture 07:02
+
Module 1 - Using Large Worksheets
3 Lectures 25:53

Freeze Panes
08:25

Group and Outline
08:20
+
Module 2 - Working with Multiple Files
2 Lectures 10:35
Arrange All - Multiple Excel Files
06:05

Multiple Sheets - New Window
04:30
+
Module 3 - Linking
1 Lecture 13:06
Linking Data
13:06
+
Module 4 - Paste Special
1 Lecture 15:31
Paste Special
15:31
+
Module 5 - Range Names and VLookup/HLookup
5 Lectures 33:31
Introduction to VLookup and HLookup
02:12

Range Names - Applying and Using
06:43

VLookup Syntax
08:53

Using VLookup
09:31

Using HLookup
06:12
+
Module 6 - IFs and Logic
5 Lectures 48:11
Introduction to IF Statements
05:27

Creating IF Statements
14:26

Using CountIF
12:37

Using SumIF
08:55

Using AverageIF
06:46
+
Module 7 - Conditional Formatting
3 Lectures 25:12
Applying Conditional Formatting
08:31

Top/Bottom Rules
05:25

Text, Duplicate and Formula Rules
11:16
+
Module 8 - Date and Text Functions
4 Lectures 33:59
TODAY, NOW and NETWORKDAYS Functions
09:46

YEARFRAC Function - Calculate number of years between dates
05:36

TEXT, LOWER, UPPER, PROPER, TRIM Functions - Great for formatting text
12:32

When you need to join 2 or more cell contents together. For Example: First Name and Surname. Or Address Line 1, Address Line 2 etc

CONCATENATE
06:05
About the Instructor
Simon Lambourne
0.0 Average rating
0 Reviews
0 Students
1 Course
Microsoft Certified Trainer

I have been an IT trainer for over 8 years and have acquired many skills in teaching different software packages to students of all abilities. I aim to build confidence in all attendees of the courses that I teach, for both large and small groups. Through my professional conduct and enthusiasm when working with learners of mixed levels, I am able to create good rapport with students, which forms a high-quality learning environment. I believe it is important to enjoy attending each training course. Therefore engaging and interacting with students on their own experiences of using the software, enables them to feel more involved in the course.