- Advanced Excel Skills to Save Time & Impress. Shortcuts, Tips & Hacks for Streamlining Your Workflow.
- Free tutorial
- Rating: 4.6 out of 54.6 (66 ratings)
- 2,208 students
- 48min of on-demand video
- Created by Inno- GEO, Kevin James S.
- English
What you’ll learn
- Increase your Productivity and be more Efficient than you ever imagined
- The ability to work “smarter not harder.”
- Improve and streamline existing spreadsheets in minutes.
- Be a Confident & Advanced Microsoft Excel user
- Learn new techniques and formulas to tackle tasks faster and better in Excel
- Automatically Pulling Data from the Web
- Improve your ability to do your work in Less Time
- Use Keyboard shortcuts that will save you hours of working by Mouse
Requirements
- Installed Excel on Windows
- A willingness to learn new Tips and reinvent your work in Excel
- You only need to have the desire make Excel easier for yourself.
Description
This Excel course is designed for those who want to take their skills to the next level. You’ll learn new tricks, tips, shortcuts, and functions that will help you become more efficient and productive in your work.
We created this course to help Excel users avoid common spreadsheet stumbling blocks and reveal ways to maximize the power of Excel.
All the knowledge included in this course and that you will acquire is just what we would have liked to have at the beginning of our time with the Excel tool in the professional environment, so we are sure that it will be beneficial to get the skills you want.
How is this course different from the others?
Basically everything. Just look at the free lessons, and you will realize this course is unique.
– Short lessons
– Downloadable resources
– Practical exercises
– and more…
Total Satisfaction Guarantee
Remember that if you don’t like the course, you get your money back within 30 days with no questions asked.
With such a guarantee, there’s no reason not to sign up now!
Important Note:
This course DOES NOT INCLUDE basic MS Excel concepts.
As a requirement, you must have a basic knowledge of MS Excel and how to interact and its typical uses.
Who this course is for:
- You want to have fun, and learn Excel.
- Excel users looking to save time
- Business people looking for tips in Excel
- You are a student, planning to take on a job that requires sound Excel knowledge
Show less
Course content
5 sections • 43 lectures • 47m total lengthCollapse all sections
The beginning – Some quick shortcuts.4 lectures • 2min
- Some quick shortcuts #100:36
- Some quick shortcuts #200:36
- Some quick shortcuts #300:28
- Some quick shortcuts #400:13
Excel tips & tricks 210 lectures • 10min
- Import data from picture01:07
- One-click email as attachment or PDF01:25
- Flash Fill01:31
- Image function00:58
- Diagonal cell formatting00:43
- Delete Blank Rows00:35
- Camera command01:28
- Remove leading zeros01:09
- Sparklines00:32
- Import data from web00:56
Excel tips & tricks 39 lectures • 16min
- Define name for cells01:32
- Absolute & relative cell references02:07
- Excel for free00:47
- Freeze panes00:41
- Define data types01:03
- Sum function01:12
- Xlookup function02:15
- Analyze data05:28
- Drag and drop to move columns01:03
New functions9 lectures • 6min
- Function #100:47
- Function #200:37
- Function #300:38
- Function #401:08
- Function #500:24
- Function #600:20
- Function #700:34
- Function #800:58
- Function #900:48
BONUS Section11 lectures • 13min
- Move & size to images into a cells00:56
- Data Bar00:55
- Skip blanks00:49
- Center across selection01:00
- ¡Automatic Borders!01:14
- AutoFit Columns with unique trick01:00
- Drop-down list00:47
- Highlight drop-down list cells01:41
- Conditional Sum with Partial Match. SUMIF Function01:40
- Prevent Duplicate Data Entries01:49
- Clean messy text in Excel01:09
