Microsoft Excel for Business Professionals
4.4 (374 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.
5,328 students enrolled
Wishlisted Wishlist

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

Add to Wishlist

Microsoft Excel for Business Professionals

Tips, Tricks, and Best Practices Straight from Corporate America
4.4 (374 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.
5,328 students enrolled
Created by Calvin Liu
Last updated 7/2016
English
Current price: $10 Original price: $200 Discount: 95% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2.5 hours on-demand video
  • 8 Articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
Analyze and Manipulate Data
Execute Beginner and Intermediate Excel Functions
Perform Business Centric Excel Formulas
Save Time and Effort in Work
Prepare Standardized/Properly Referenced Workpapers
View Curriculum
Requirements
  • Microsoft Excel 2007 or 2010
Description

In today's day and age, Microsoft Excel is fully integrated in all businesses. Mastering its functionality is not only recommended, it is required.

"Microsoft Excel For Business Professionals" is not your average Excel course. What sets this course apart is its business centric focus. Frankly- if you are looking for complex macros or building information databases- this course is not for you.

This course is specifically tailored for those working in some form of business capacity. If you want to develop Excel skills applicable to any trade/business, instantly boost your resume, and outperform your peers, then this course is for you.

My name is Calvin and I am the instructor for this course. I have been fortunate to be employed by arguably the largest professional services firm in the world with high profile clients such as Disney, Edison International, Nike, Dreamworks, and Fox- many of which I have had the opportunity to work directly with.

While these high profile clients may seem glamorous, I am down in the trenches- preparing and reviewing workpaper after workpaper, spreadsheet after spreadsheet. Naturally throughout my experience, I have seen a common thread of Excel tips, tricks, and best practices that companies across the board use. Mastering these skills is an important addition to any business professional's arsenal of skills. Through step by step guides, downloadable spreadsheet, and project based examples, this course will impart this knowledge to you.

By taking this course you will be able to:

  • Analyze and Manipulate Data
  • Execute beginner and Intermediate Excel Functions
  • Perform Business Centric Excel Formulas
  • Save Time and Effort in Your Work
  • Prepare Standardized/Properly Referenced Workpapers
  • ... Become a Better Business Professional!

So what are you waiting for? With Udemy's 30 day money back guarantee, you have nothing to lose!

---------------------------------------------------------------------------------------------------------

What Business Excel Really Means:

I've received a lot of questions on what Excel for Business really means. Using Microsoft Excel in a business setting can be boiled down to three broad categories:

Data Manipulation

How do you take large data sets and extract the information you need? Furthermore, how do you take the information you need and forecast results? Using Excel in a business setting is about taking raw data and transforming it meaningful information. Many of these functions and calculations are already baked into the Excel software.

Efficiency

When you're working with thousands of transactions and billions of dollars, Excel can perform calculations in seconds which otherwise would take hours manually. Using Excel correctly can not only save you countless number of hours, but also, can save your company countless number of dollars.

Model Building

There are three keys in building a strong model- flexibility, results, and clarity. Flexibility means that a user can change any inputs and the model will automatically calculate a new result. Whether it's forecasts or estimates, inputs are always changing. Building a model that can accommodate that is the foundation to any good model. Secondly, you must learn to present information in a clear, concise, and visually appealing manner. If someone can't understand, it won't matter how good your model is. Lastly, you must build a model that not only applies the correct logic, but can you give information that solves problems.

Who is the target audience?
  • Anyone working in a business capacity
  • Small Business Owners
  • Prospective Job Hunters
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 30 Lectures Collapse All 30 Lectures 02:21:55
+
Introduction
2 Lectures 13:26
+
Excel Functions
5 Lectures 26:01
Case Study 1: Barney's Investment Management Firm
00:02

Formulas 101
05:51

Basic Formulas
11:13

Transposition
05:04

Absolute Verse Relative
03:51
+
Data Analysis
6 Lectures 39:43
Case Study 2: Wood Floors Depot
00:02

Manipulating Data
12:49

If Analysis
06:20

Vlookup
05:46

Custom Inputs
05:53

Pivot Tables
08:53
+
Use Excel For
7 Lectures 22:40
Use Excel For..
01:04

Excel For Finance Data Set
00:02

Excel for Finance
05:29

Excel for Marketing Data Set
00:02

Excel for Marketing
09:07

Spreadsheet Download: Accounting
00:02

Excel for Accounting
06:53
+
Workpaper Preparation
6 Lectures 26:48

Continue to work with the prior section's spreadsheet, Wood Floor Depot, and follow along this section's lectures!

Case Study 3: Wood Floors Depot Part 2
00:04

Secret for Success
02:22

Formatting
06:27

Labeling
04:24

Referencing
10:20

Conditional Formatting
03:11
+
Course Wrap Up
3 Lectures 11:14
Spreadsheet Download: Excel Hacks
00:02

Excel Hacks
08:41

Conclusion
02:31
+
Take Action!
1 Lecture 02:09
Translating your skills to real life
02:09
About the Instructor
Calvin Liu
4.4 Average rating
426 Reviews
6,750 Students
2 Courses

My name is Calvin and I run TaxSavingStrategy. I am a Certified Public Accountant and work full time as a tax consultant with clients ranging from individuals to Fortune 500 companies. I graduated with both a Bachelor's in Accounting as well as a Master's in Business Taxation.

I understand that the complexities of tax law can be a daunting task especially for those who have no background. However, if you don't at least try, you will never really know. Let me illustrate with a example from my personal life. When I decided to make TaxSavingStrategy, I had to face the daunting challenge of making a website. Coming from a business background, I have zero coding knowledge so building a website seemed impossible. I took the time to learn some basic fundamentals and the site you see today was 100% built by me. It took me a couple hours to learn the basics. I'm still not an expert and I still don't know coding; but as you can see, I was able to create a full functioning website, something that I did not think was ever possible.

My point? We fear the unknown. We make things out to be much harder than they are. You are more capable than you think you are. In today's digital era, there are so many resources that can significantly reduce the learning curve. This introductory course sets out to do that. Use this as a guide to become an informed individual. No you won't be an expert, but by the end, you will be equipped with strategies that can make a difference.