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!
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.
3,524 students enrolled
$45
Take This Course
  • Lectures 13
  • Contents Video: 1 hour
    Other: 0 mins
  • Skill Level Intermediate Level
  • 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 1/2014 English

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

What are the requirements?

  • A computer with Microsoft Excel installed on it
  • A set of ear phones

What am I going to get from this course?

  • Choose the right trick to do Excel projects in minutes.

What is the target audience?

  • 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.

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

How To Contact Me If You Wish To Talk To Me In Private
Article
Section 1: Crucial For Productivity But Often Overlooked Options In Basic Excel Training
06:05

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

05:55

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

06:23

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.

Section 2: These Time Saving Tips Will Save You Hours Of Work On Your Excel Projects
03:18

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

05:48

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.

05:27

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.

07:06

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.

What You Need To Do If Numbers You Need Excel To Calculate Are In .TXT File.
05:23
Section 3: Excel Formulas: Your Best Tools For Productivity & Meeting Deadlines Every Time
05:08

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

04:39

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

05:55

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

00:33

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

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Larissa Fontenot, US Tax Advisor, Excel Productivity Trainer, Udemy Instructor

First of all, let me acknowledge you for looking online trying to learn things which will improve your life. So many people just spend their time in front on TV, but not you. You are searching for the ways to make your life better.

I am Larissa Fontenot. I am originally from Russia, moved to the US in 2000.

I have 4 years of experience doing taxes for clients who are self employed, with home ownership, purchase, or sale, real estate rentals or vacation homes, ITIN (Individual Taxpayer Identification Number) application, health care expenses (e.g. medical, dental), charitable giving, military, investment/stock options,clergy, tax planning.

After having done hundreds of returns in the retail office at a big household name company and additional 173 hours of continues training (63 hours of which were in class), I have created US Taxes courses to help you see the forest behind the trees – the big picture that comes together like a puzzle out of all details of your financial situation.

As complicated as tax code is, I still can explain fundamental concepts to you in layperson language, so you can learn to confidently do your taxes yourself.

I can promise you, that it is quite possible to understand what goes into the calculation of your tax liability and take the mystery out of tax preparation: short 7 years ago I decided to make some extra money doing tax returns from people because I'd just gone through a divorce and had never done my taxes myself, as I am originally from Russia, and my American husband always took our tax paperwork to H & R Block. That's exactly why I looked into this company for extra work - little did I know, they had training available! So I successfully graduated from that training course after over 130 hours in class training and dozens of practice case studies done.

I am positive, I can teach you how to do your own taxes yourself correctly too. Thank you for checking out my courses!

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

I also enjoy teaching Excel productivity hacks. At my job they call me 'Excel Queen'.

I learned everything I know in Excel while working on projects for my jobs since September 1997. From creating graphs for engineers back in Russia, to doing sales analysis for a Consumer Packaged Goods company in the US - I enjoy my Excel projects as they provide challenge to learn more and improve my skills.

The more I learned Excel, the better paying jobs I had. The company I work for regularly sends me to run Excel training sessions in different parts of Southeast US for groups of sales managers. Now I conduct Excel training for the company in class and via webinars.

Teaching is the second nature to me as I graduated from Perm State Humanitarian Pedagogical University (PSHPU) in Russia, which trains students how to be teachers.

I enjoy showing people how they can do the same amount of work in Excel they spend hours, and sometimes days doing, in just minutes. My Excel course came to life because I want more people to work in Excel more efficiently, be less tired at the end of the day so that their families can enjoy them, and they too can enjoy spending time with their loved ones and not be tired of fighting with software which in fact, can be their friend and do their work for them.

I am looking forward to answering the questions you have in discussion forum.

Your success is my goal!

Ready to start learning?
Take This Course