Excel for Business
4.3 (2 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.
89 students enrolled
Wishlisted Wishlist

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

Add to Wishlist

Excel for Business

The Premier Entry-Level Excel Course for Business Professionals
4.3 (2 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.
89 students enrolled
Created by NYIM Training
Last updated 6/2017
English
Price: $95
30-Day Money-Back Guarantee
Includes:
  • 2 hours on-demand video
  • 22 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Students will feel confident navigating through Excel worksheets and working with formulas, databases, charts, formatting, shortcuts and printing.
View Curriculum
Requirements
  • This beginner-level Excel course will provide you with all the prerequisite knowledge for the course.
Description

Excel for Business Level I is the first of a three part series that aims to tackle the most common and practical uses of Excel in business. This is the perfect course for those who are either new to Excel or would like to improve their understanding and efficiency of its applications in business. By the end of this course, you will feel confident navigating through worksheets and working with formulas, databases, charts, formatting, shortcuts and printing. The skills you take away from this course will prove crucial to building a strong resumé and boosting your job performance. 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 is the perfect course for those who are either new to excel or would like to improve their understanding and efficiency of its applications in business.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
22 Lectures
02:12:46
+
Excel Basics
4 Lectures 23:49

What is Excel and what can it be used for?

Preview 07:55

Provides a brief description of the user interface for Microsoft Excel

Interface
06:23

Examines and describes multiple means of entering data

Data Entry
07:07

Explores Excel's amazing ability to predict and extrapolate patterns

Preview 02:24
+
Formulas
5 Lectures 27:34

Perform mathematical expressions and review the Order of Operations rule

Calculations
04:38

Review the five key functions: Sum, Average, Max, Min, and Count

Preview 09:00

Introduces functions used to modify text in Excel

Text Functions
02:29

More advanced functions that require more than one input

Multi-Input Functions
07:12

Changing a cell reference into a constant, which is necessary in certain calculations

Absolute Cell References
04:15
+
Formatting
4 Lectures 34:34

The addition of effects to an excel document to provide visual instruction

Formatting
13:48

Formatting Exercise
05:55

Use the Format Painer to copy format a from one cell (or range of cells) to another

Preview 04:40

Create rules that govern specific cell ranges and apply a predetermined format when those rules are triggered

Conditional Formatting
10:11
+
Charts & Tables
4 Lectures 25:15

Create a Line chart and Spark lines to visually examine data

Preview 05:43

Create a Column chart to visually examine data

Column Chart
10:08

Create a Pie chart to visually examine data

Pie Chart
03:22

Explores the special functionality created when data is converted to a Table

Tables
06:02
+
Workbook Management
4 Lectures 17:01

Rules and strategies to make printing easy

Printing
07:21

Insert, move, copy and delete worksheets

Worksheets
03:43

Insert, hide, group and freeze rows and columns

Preview 03:53

Save, close and email your finished product

Save & Close
02:04
+
End of Class Project
1 Lecture 04:33

End of class project to review key concepts from the class

Project
04:33
About the Instructor
NYIM Training
4.6 Average rating
4 Reviews
127 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.