Buying for a Team? Gift This Course
Wishlisted Wishlist

Please confirm that you want to add Excel Productivity to your Wishlist.

Add to Wishlist

Excel Productivity

Microsoft Excel Training For The Ambitious
3.8 (10 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.
1,051 students enrolled
Created by Brett Romero
Last updated 7/2014
English
$10 $95 89% off
4 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
Description

Microsoft Excel is the most in demand tool for mining and making sense of data. Anyone that can harness this power will be a sought after employee. If you are running a business, being proficient in Excel can help you see your business in a whole new light.

Leading a team? Boost their efficiency in minutes with this mega packed Excel Productivity course.

Excel Productivity shows you have to work faster and smarter in Excel. You'll pick up great tips that will make working in Excel a pleasure.

Some of the areas covered include:

  • Conditional formatting
  • Various types of sorting
  • Days and years between dates
  • Removing duplicates
  • Viewing multiple sheets in a single view
  • and more

The best part is that the above list will keep growing with great Excel insider, productivity tips for working smarter and faster.

By signing up to this course now, you'll be getting in at the lowest price. As the course grows, which it will be constantly doing, you'll get all of the new content for free!

Click to your right to sign up and I'll see you in the first lesson!

Who is the target audience?
  • Employees Working With Excel
  • Entrepreneurs Working With Excel
  • Anyone Wanting To Work Faster And Smarter In Excel
Students Who Viewed This Course Also Viewed
What Will I Learn?
New Excel Tips
Ability To Solve Problems That Others Struggle With
Increased Excel Productivity
View Curriculum
Requirements
  • Microsoft Excel
Curriculum For This Course
Expand All 27 Lectures Collapse All 27 Lectures 02:30:41
+
Introduction
2 Lectures 18:05
Saving/Opening Files & Ribbon Menu
10:23

+
Formulas
6 Lectures 37:19
Formulas Introduction
10:47


A Common Multi Column Summation Done Very Quickly
02:28


vlookup Exposed (project file attached)
06:22

Phone Numbers (project file attached)
12:45
+
Making Your Data Make Sense
5 Lectures 25:58
Sorting
06:06


Conditional Formatting
07:51

How Does Excel Know Which Data Format To Choose?
03:35

Updating an Existing Chart's Data Source (project file attached)
04:42
+
Productivity 10x Features
3 Lectures 11:31
+
Ninja Shortcuts
4 Lectures 14:31

Selecting Only Relevant Data
03:46

Shortcut Keys
02:35

Locking Cells & Showing All Formulas
04:13
+
Excel Overdrive
2 Lectures 10:08
Create an Organizational Chart Fast (then add it to PowerPoint)
03:26

Building A Functional Database (project file attached)
06:42
+
Customizing Your Workspace
2 Lectures 06:16
Hiding/Unhiding Single And Multiple Columns
03:19

+
Extending Excel
3 Lectures 26:53
Solving Complex Problems Easily (project file attached)
11:23

Sourcing Data Directly From The FED Into Excel
07:07

Power Query
08:23
About the Instructor
4.0 Average rating
233 Reviews
25,868 Students
20 Courses
Brett Romero

I'm a software engineer and entrepreneur. I've also started several businesses. Bitesize Business School is the latest, where I write about applying business principles to the real world and solving technology issues that every online business faces.

The first business I created, Cygen, was a web design consulting business. From this business, I also created my first product - A chatroom web application that was javascript based.

I've written desktop applications in languages running from Delphi to C# winforms/WPF. I've also built ASP.NET webforms and MVC based applications. When the iOS SDK was first introduced, I bought a Macbook and began building apps for the iPhone. I currently have seven apps in the iTunes App Store.

I have an MBA from ASU ('14). My undergraduate major was in mathematics. Before graduating, I decided to get a business degree. I continued taking mathematics courses at the University of Washington after completing my undergraduate degree.

Report Abuse