Intermediate Excel for Business
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.
33 students enrolled
Wishlisted Wishlist

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

Add to Wishlist

Intermediate Excel for Business

The premier intermediate-level Excel training course
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.
33 students enrolled
Created by NYIM Training
Last updated 7/2017
English
Price: $95
30-Day Money-Back Guarantee
Includes:
  • 2 hours on-demand video
  • 23 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Dynamically extract data from large databases, quickly organize data with Pivot Tables, navigate large databases.
View Curriculum
Requirements
  • Excel for Business or equivalent level of Excel proficiency
Description

Intermediate Excel for Business Level II is the second of a three part series that aims to tackle the most common and practical uses of Excel in business. This course is perfect for those who have either taken Level I or already have a basic working knowledge of excel and would like to improve efficiency and expand into Excel's more complex functions and data management features. By the end of this course, you will feel confident dynamically extracting data from large databases using advanced functions such as Vlookup, and quickly organizing and analyzing large amounts of raw data with Pivot Tables. The skills acquired in this course are what many employers have come to expect and look for in new applicants and existing employees.

Who is the target audience?
  • Anyone who wants to advance his/her skill level in Excel
Students Who Viewed This Course Also Viewed
Curriculum For This Course
23 Lectures
02:10:03
+
Start Here
1 Lecture 07:12
+
Worksheet Management
2 Lectures 09:07

Review keyboard shortcuts to facilitate quick and easy navigation around the worksheet

Preview 04:23

Use Paste Special to apply formats as well as perform calculations on selected cells

Paste Special
04:44
+
Text
2 Lectures 05:39

Use Text to Columns to split text into multiple cells

Preview 02:24

Join text from separate cells

Joining Text
03:15
+
Database Management
4 Lectures 27:16

Assign a name to a range of cells to reference that range in calculations

Named Ranges
03:59

Create a dropdown menu to specify the inputs in certain cells

Data Validation
09:14

Use Sort & Filter to quickly find and organize data in large databases

Preview 10:20

Use Remove Duplicates to eliminate duplicate data

Remove Duplicates
03:43
+
Database Functions
3 Lectures 12:11

Use Vlookup to find information in one column and return information from another column

Preview 06:21

Use Hlookup to find information in one row and return information from another row

Hlookup
02:13

Vlookup - Closest Match
03:37
+
Logical Functions
3 Lectures 09:33
True, False, Not
03:20

And, Or Functions
02:49

If Statements
03:24
+
Statistical Functions
3 Lectures 13:39
Rank.eq
04:22


Sumifs
04:48
+
Pivot Tables
4 Lectures 33:49
Table Review
03:30

Pivot Tables
10:18

Pivot Tables & Grouping
05:42

Multiple Pivot Tables
14:19
+
End of Class Project
1 Lecture 11:37
Project
11:37
About the Instructor
NYIM Training
4.3 Average rating
2 Reviews
91 Students
3 Courses
Computer Software Training

NYIM is the premier computer software training company in NYC, with two decades of exceptional service provided to thousands of business professionals. NYIM's courses are taught by the leading industry professionals, with an engaging and interactive teaching approach. Our curriculums have been refined over years and focus on practical and hands-on applications for day-to-day business needs.