Excel Productivity Hacks: How I Finish Projects In Minutes
- 1 hour on-demand video
- 1 article
- 11 downloadable resources
- Full lifetime access
- Access on mobile and TV
- Certificate of Completion
Get your team access to 4,000+ top Udemy courses anytime, anywhere.Try Udemy for Business
- Choose the right trick to do Excel projects in minutes.
- A computer with Microsoft Excel installed on it
- A set of ear phones
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.
- 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.
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
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
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.
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
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.
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.
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.
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
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
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
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.