Top Excel tricks in 40 minutes - Boost your productivity!
4.6 (74 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,284 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Top Excel tricks in 40 minutes - Boost your productivity! to your Wishlist.

Add to Wishlist

Top Excel tricks in 40 minutes - Boost your productivity!

Brief introductory course with some Excel basics and tricks to improve your performance and deal with large data files!
4.6 (74 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,284 students enrolled
Created by Anne Bender
Last updated 2/2017
English
Curiosity Sale
Current price: $10 Original price: $20 Discount: 50% off
30-Day Money-Back Guarantee
Includes:
  • 40 mins on-demand video
  • 6 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Apply the most commonly used shortcuts in Excel
  • Apply the most frequently used formulas
  • Analyse data efficiently by applying filters
  • Quickly find data by using the Vlookup formula
  • Use charts in order to visualize data promptly
  • Apply Excel's powerful pivot tables in order to analyse data like a pro!
  • Make easy and effective comparisons between your data
  • Analyse large amounts of data efficiently
  • Add a professional look to your data files
  • Organize and present your data according to business standards
View Curriculum
Requirements
  • Beginner experience
  • You just need Microsoft Excel
Description

2017 is the year for improving your productivity and finally learn some basics of Microsoft Excel, along with some tricks used by pros! This brief, but useful course will show you tips and tricks for you to start taking advantage of Excel's powerful features. While I take you through, you are welcome to use the Excel materials provided.

This course has been designed for people with basic Excel knowledge, so just relax and let me take you through. From learning some of the most used shortcuts and formulas, to beautifying your files with charts; and from organising large data files by using filters, to boosting productivity and organising your data with pivot tables, the vlookup formula and conditional formatting. 

If you know that you need Excel, either because of personal or professional circumstances, this course will help you and encourage you to start using this powerful tool. You'll see how useful it is. 

Thank you and welcome to this course. It is for you!

TIME TO BE EFFICIENT :)

Who is the target audience?
  • Excel beginners who want to boost performance and productivity
  • People who want to improve their personal and professional output
  • People managing and analysing large data files who want to be more efficient
  • People who want to save time when working with data files
Students Who Viewed This Course Also Viewed
Curriculum For This Course
+
Start boosting your productivity with Excel now
9 Lectures 39:44

Before going into some powerful tricks, learn about useful shortcuts that will help you to save some of your valuable time!

Preview 01:41

Learn how to use important formulas such as SUM, IF, TRIM and PROPER that will allow you to be more efficient and professional with your file.

Preview 08:46

Sort out large amounts of data efficiently by using the filter function. Essential for managing those frustrating and massive data files!

Filters
04:51

Use the Vlookup formula when you need to find data in those massive Excel files!

Vlookup Formula
03:52

Time to beautify your data with this essential Excel tool that will add a professional look to your file.

Charts
07:11

Sumamrize and condense your data by using one of the most important Excel functions. Once you learn this, your data files will never look the same!

Pivot Tables
05:57

The last section will take you through an efficient way to visualise your data. Very useful when you need to categorise data files and highlight data that might be relevant to your project.

Conditional Formatting
05:43

Goodbye & Follow-up
00:29
About the Instructor
Anne Bender
4.6 Average rating
74 Reviews
1,284 Students
1 Course
Certified Google AdWords Specialist & Trilingual PPC Pro.

Hello! I'm Anne. Based in Manchester, UK, with 5+ years of Online Marketing and Paid Search experience. I hold a master degree in Marketing and I've been working with important media agencies in the UK as a PPC specialist. My role involved managing the PPC activity of leading brands such as P&G, Adidas, Travelex, London & Partners and Trip Advisor, but I also been helping small businesses and startups achieve their own online marketing goals. By understanding and working with high-traffic brands, diverse industries and managing six digit budgets, I've developed an strategic way of thinking when it comes to advising businesses and students.

Besides my interest and experience in online marketing, I am truly passionate about traveling, gigs and wine pairing. This year I will start creative drawing classes, so let's see how it goes!

AdWords is a fascinating tool, but first you need tailored guidance and the right tools. Sign up to my course. I will take you through and you can always contact me. I speak English, German and Spanish. I'm pretty sure that you'll get what you are looking for, otherwise you will always have a 30 day money back guarantee!

Thanks for reading me!