Advanced 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.
9 students enrolled
Wishlisted Wishlist

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

Add to Wishlist

Advanced Excel for Business

The Premier Advanced Excel Course for Business Professionals
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.
9 students enrolled
Created by NYIM Training
Last updated 7/2017
English
Price: $95
30-Day Money-Back Guarantee
Includes:
  • 2 hours on-demand video
  • 21 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • By the end of this course, you will feel confident using advanced formatting techniques, multi-input and conditional functions and recording basic macros. Additionally, you will gain experience will advanced excel features and plug-ins such as scenario management and solver.
View Curriculum
Requirements
  • Intermediate Excel course or equivalent knowledge.
Description

Advanced Excel for Business Level III is the last 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 II or already have a strong working knowledge of excel and would like to take their skills and efficiency to an advanced level. By the end of this course, you will feel confident using advanced formatting techniques, multi-input and conditional functions and recording basic macros. Additionally, you will gain experience will advanced excel features and plug-ins such as scenario management and solver. Your peers, colleagues and employers will be impressed with you ability to tackle complex problems in excel dynamically and efficiently after you take this course. The course comes with a revolutionary video tutorial suite, and is taught by engaging instructors with several years of in-field and training experience. 

Who is the target audience?
  • This course is perfect for those who have either taken Level II or already have a strong working knowledge of excel and would like to take their skills and efficiency to an advanced level.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
21 Lectures
01:45:52
+
Special Formatting
4 Lectures 20:11


Text Function
04:47

Date Functions
04:06
+
Cell Management
5 Lectures 26:16
Advanced Cell Locking
03:01

Cell Auditing
06:36

Offset Function
06:36

Nested If Statements
06:06

If with And & Or
03:57
+
What If Analysis
3 Lectures 10:24
Goal Seek
04:02

Scenario Manager
04:03

+
Advanced Analytical Tools
3 Lectures 14:56
Data Consolidation
03:07

Conditional Sumproduct
02:52

Advanced Pivots
08:57
+
Advanced Database Functions
4 Lectures 18:38
Match Function
02:16

Vlookup-Match Function
06:55

Index-Match Function
03:26

Index-Double Match Function
06:01
+
Introduction to Macros
2 Lectures 15:27
Recording Macros
06:50

Relative Reference Macros
08: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.