Excel Productivity Hacks: How I Finish Projects In Minutes
2.8 (13 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
3,527 students enrolled

Excel Productivity Hacks: How I Finish Projects In Minutes

Go from struggle with Excel files to high productivity which will help you get a promotion or a better job. Enroll now!
2.8 (13 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
3,527 students enrolled
Created by Larissa Fontenot
Last updated 3/2014
English
English [Auto]
Current price: $30.99 Original price: $44.99 Discount: 31% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 1 hour on-demand video
  • 1 article
  • 11 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Choose the right trick to do Excel projects in minutes.
Requirements
  • A computer with Microsoft Excel installed on it
  • A set of ear phones
Description

In my course you will see how I use basic and advanced Excel functionality while working on spreadsheets, so you will learn and apply the same techniques in your work and finish projects much faster and easier - like I do. It is essential to work quickly in a fast pace business environment.

If You Use Excel At Work And Find Yourself Struggling And Hating It, This Course Is For You.

  • Learn my best tips
  • Apply to your Excel projects
  • End your struggle with Excel

Each video will address 2-3 Excel options I use every day to finish projects fast.

Ever wonder how other people always meet their Excel projects deadlines?

For $49 I will teach how to you work lightning fast in Excel in 60 minutes.

  • Here's what you need to do: find the blue button 'Take This Course' at the top on the right, click it and enroll in my course now.

There are 11 videos in this course. Each of them is a screen cast video. You will watch me perform tasks on my screen as if looking over my shoulder.

My videos are short, direct, with clear explanation of techniques. I will not explain what Excel is, or what rows, columns and cells are. You will learn the most efficient ways of doing your every day boring tasks and will become an Excel rock star.

Who this course is for:
  • This Excel course is meant for people spending hours doing work in their Excel projects manually and hating it. This course is probably not for you if you already do your work in Excel in minutes.
Course content
Expand all 13 lectures 01:02:01
+ How To Contact Me If You Wish To Talk To Me In Private
1 lecture 00:20
How To Contact Me If You Wish To Talk To Me In Private
00:20
+ Crucial For Productivity But Often Overlooked Options In Basic Excel Training
3 lectures 18:23

Like with anything on computers, there are several ways to do one and the same thing in Excel. I show you the formatting method that is not commonly used, but can be very handy.

I can recommend you Excel For Beginners so you can go in depth on basic things, if you are very new to Excel.

I see people treating Excel like it is a text processor (Microsoft Word, for instance) - but it is not. It is a numbers software. But don't worry, second part of the video will show you how to handle text in Excel without frustration.

My course is for PC users. If you are a Mac person, here's a course for you Microsoft Excel 2011 for Mac Tutorial - Learn The Easy Way

Preview 06:05

Did it ever happen to you - someone sends you an Excel file by e-mail. You open it and start entering numbers - cells look blank, so you are good to go, right? Nope, you just wiped out formulas. I made this video to help you avoid this mistake. Here's in depth course on the formula I use the most at work - saves me ton of time Vlookup secrets.

I am all about making it easy on the eyes when I work. If I can cut down on my on screen travel time and distance - I will do it. And teach you, too - that's the second part of the lecture.

I understand it if you want to learn step by step from the beginning and fast - here's a great course by one of my fellow instructors Fast Track To Microsoft Excel Beginner +Advanced

These Tips Help You Always Know Where Formulas Are & Free Up 1/3 Of Your Screen
05:55

Back in 1997 when I started working in Excel it was all about graphs. I love them! They are extremely useful. Unless you have too much data to plot. Here's Excel Charts – In depth - you will see how easy and elegant you can present your data.

I like clarity and control over my work space. Including digital work space. Seeing exactly how the document will look when your boss will print it while you are still working on it gives me peace. You'll learn to appreciate this trick.

Some people create files with tens of spreadsheets. Let me help you find your way around them quickly.

There are some changes in the latest version of Excel - you will find details here What's new in Excel 2013.

Fast Way To Analyse Excel Table. Search For Tabs You Need Quickly - No Scrolling
06:23
+ These Time Saving Tips Will Save You Hours Of Work On Your Excel Projects
5 lectures 27:02

I love this technique very much and use it very often. Here's a helpful course Ultimate Excel Shortcut Guide Become a Power User in Days! if you want to develop your Excel skills quickly.

As in most of my files, I have vlookups in this example. Here's in depth course on them for you

How To Make Exact Copy Of Your Spreadsheet In Two Clicks - No Formatting Needed
03:18

This simple technique has saved me a lot of time at work. It seems like an extra step, but I promise in a fast pace business environment, you will appreciate it.

If you use Excel in business, here's a course that will most definitely help you: Sharper skills using Microsoft Excel 2010 for business.

How To Instantly Know Where You Stopped. Work In Two Files - No Screen Flipping.
05:48

When I am at work - productivity is the key. Not working hard, working smart is my motto. And, of course, no manual work in software, if I can help it. That's what this lecture is all about.

I can suggest this great course on productivity Excel 2010 Productivity - later version of software, will help you eliminate confusion you might have.

An Easy Way To Paste Columns Into Rows. Keep Calculations Results Always Right.
05:27

From basic to advanced - all Excel options are very useful when work needs to be done quickly. I realize that you might want to go deeper into formulas before second part of the lecture becomes relevant.

Here's the course I would recommend for study Microsoft Excel – Advanced formulas and functions

Whenever possible, I have two different spreadsheets in the same file on screen side by side - makes it easy to build formulas connecting those two spreadsheets. Very useful tip in part 3 of the video. Enjoy.

Fundamentals of Excel For Business course will help you sharpen your skills.

Change Thousands of Numbers In Two Clicks. Work In Two Tabs - Easy And Fast.
07:06
What You Need To Do If Numbers You Need Excel To Calculate Are In .TXT File.
05:23
+ Excel Formulas: Your Best Tools For Productivity & Meeting Deadlines Every Time
4 lectures 16:15

I only mentioned vlookup formulas in this video. If you need a closer look - here's a course on them.

Pivot tables are great tool for me when I need to summarize and simplify my data. They are used in many more business situations - I recommend a separate course on them Microsoft Excel Pivot Table or if you want to become a pivot table pro - take a look at this one Excel Deep Dive: Pivot Tables Workshop with the Office Ninja

Easy Way To Make An Excel Summary Of Numbers From A .TXT File Or Word Document.
05:08

I give an example of how useful a simple formula can be. I am sure you want to know what other formulas can do for you. Here's in depth course you can take if you'd like Microsoft Excel – Advanced formulas and functions

Preview 04:39

There are many more formulas that can help you work your projects from a template you were handed, or start your own masterpiece - whichever the situation is you can be a hero at work. Here's a course on formulas, use them in your work creatively: Microsoft Excel – Advanced formulas and functions

How To Make Excel Add Up Cells Only In Some Rows In Your Excel Table Or Log.
05:55

When I was creating this course, my goal was to show you what's in it for you - how all this fancy (and basic) 'stuff' in Excel which you can learn in depth in other courses on the list below relates to what you need to accomplish in your work projects.

My hope is that I have stirred up your creativity while you were watching me working in my files. If you had a couple of 'a-ha' moments when you saw how you too can start working differently - with less stress and more enjoyment in Excel - then I have accomplished what I had in mind when I decided to put this course together for you.

Master Excel 2011 for the Mac

Excel 2010 - Level 1: From Zero to Hero; Beginner-Novice

Microsoft Excel - Level 2 – Essentials

Microsoft Excel - Level 3 – Advanced

Microsoft Excel 2010 in Easy Steps

Microsoft Excel 2013 Simplified

Use Excel Like A Pro. Fast. (Excel Models for Financial consultants)

How to Build a Supply Chain Model in Microsoft Excel

Preview 00:33