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
$95
Take This Course
  • Lectures 27
  • Contents Video: 2.5 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 6/2014 English

Course 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!

What are the requirements?

  • Microsoft Excel

What am I going to get from this course?

  • New Excel Tips
  • Ability To Solve Problems That Others Struggle With
  • Increased Excel Productivity

What is the target audience?

  • Employees Working With Excel
  • Entrepreneurs Working With Excel
  • Anyone Wanting To Work Faster And Smarter In Excel

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction
Saving/Opening Files & Ribbon Menu
10:23
Getting Started With Formulas
Preview
07:42
Section 2: Formulas
Formulas Introduction
10:47
Concatenate
Preview
02:52
A Common Multi Column Summation Done Very Quickly
02:28
Calculating Time Spans
Preview
02:05
vlookup Exposed (project file attached)
06:22
Phone Numbers (project file attached)
12:45
Section 3: Making Your Data Make Sense
Sorting
06:06
Removing Duplicates
Preview
03:44
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
Section 4: Productivity 10x Features
Quick Analysis
03:15
Multi-Sheet View
Preview
03:59
Freezing Panes
Preview
04:17
Section 5: Ninja Shortcuts
Power of the Alt Key
Preview
03:57
Selecting Only Relevant Data
03:46
Shortcut Keys
02:35
Locking Cells & Showing All Formulas
04:13
Section 6: Excel Overdrive
Create an Organizational Chart Fast (then add it to PowerPoint)
03:26
Building A Functional Database (project file attached)
06:42
Section 7: Customizing Your Workspace
Hiding/Unhiding Single And Multiple Columns
03:19
Coloring Tabs For Better Grouping
Preview
02:57
Section 8: Extending Excel
Solving Complex Problems Easily (project file attached)
11:23
Sourcing Data Directly From The FED Into Excel
07:07
Power Query
08:23

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

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.

Ready to start learning?
Take This Course