40 Handy Excel Tips to make you look like a Excel Guru

Name: 40 Handy Excel Tips to make you look like a Excel Guru
Rating: 4.3 (97 reviews)

WOW colleagues and management with some slick Excel moves in 90 Minutes. Stand out at work and Impress your Colleagues.

Created bySuhas Dakhole

Last updated 4/2018

English

What you'll learn

Use the hidden features of Excel
A confidence boost by learning the way around Excel.
Know many tricks to save time while using Excel
The ability to work "smarter not harder."
Be able to teach/help others at home or work.
Get Appreciation at Work from Colleagues and Management

Course content

1 section • 11 lectures • 1h 30m total length

Introduction1:05
Begin your journey to become an Excel guru with an introduction to 40 handy Excel tips.
How to Use this Course1:59
Discover a collection of 40 handy Excel tips gathered over 50 years of experience, and learn to use the course via the lecture index, source files, and practice tasks.
Trick 1 to 56:49
Master quick Excel techniques to input data with the mouse, move and format cells, and copy data from one cell to another.
Trick 6 to 106:46
Learn practical excel tricks for sorting data left to right, selecting and filtering rows, and using special options to handle blanks and zero values for cleaner worksheets.
Trick 11 to 1510:52
Explore excel tricks 11 to 15, including using the concatenate function and data validation, to manage data, reflect changes across your worksheet, and apply practical tips for efficiency.
Trick 16 to 2011:06
Clean messy data in Excel by removing blanks and aligning rows for a neat, readable sheet. Explore data analysis, dropdown validations, and formula and image management to enhance workbooks.
Trick 21 to 2515:05
Explore trick 21 to 25 in Excel to selectively filter data, format cells, copy or transform data, and separate names with the evaluate function for complex formulas.
Trick 26 to 3012:29
Explore tricks 26 to 30 in Excel, focusing on using slicers to quickly filter records, analyze data, and compare scenarios across different units and regions.
Trick 31 to 3513:32
Explore Excel tricks from trick 31 to 35, including inserting and hiding rows, tracking and accepting changes, and using advanced filters to build database-like data analyses and visuals.
Trick 36 to 4010:16
explains using Excel to estimate a project duration with date calculations and network-like functions, and demonstrates transferring results to Word, saving files, and sharing via email.
Congratulations0:34
Master 40 handy Excel tips to look like an Excel guru with clear, practical guidance for enhancing spreadsheet efficiency.

Requirements

Basic Proficiency in Excel
A PC with Microsoft Excel Installed - 2010 and Above.
Lots of Enthusiasm and the Willingness to Stand out as Excel Expert

Description

This course is designed to help you use Excel more effectively. Learn to use Excel's Amazingly Powerful Tips and Tricks I've picked up over the past 15 years using Excel. By Adding one or more of these tricks into your repertoire, you will be able to effortlessly manage data sets, Improve Productivity and Demonstrate value. The Course has plenty of tricks and shortcuts that you can use to be get tedious, boring work done much, much faster. Be the GO TO person at Work and be looked up by Your Colleagues as an Excel Guru.

Who this course is for:

You want to have fun, and learn Excel.
If you want to stand out as an Excel Expert
Anyone who wants to boost their productivity in Excel
Anyone who wants to save time while using Excel