Excel Smart Tips: 54 Ways to Supercharge your Sheets

A collection of 54 micro-lessons to help you: Master functions, format your spreadsheets, and analyze data with ease

Udemy's "Smart Tips" is the ultimate micro-learning series. Short, standalone lectures let you learn new skills at your own pace, anytime, anywhere. Find what you need, when you need it. Elevate your learning with Smart Tips!

Have you ever needed to remove duplicate records in a list that’s hundreds of rows long, and gone cross-eyed trying to find all of them on your own? Or maybe you’ve needed to get just the first name from a list of full names and wasted hours manually copying them. I’m here to tell you there’s a better way for these and so many more of your real world struggles in Excel.

Welcome to Smart Tips: Excel! In this course I’ll provide short lectures to help you do something new - fast, so that you can immediately apply it to your work or life. The videos in this course are standalone. That means you don’t have to watch in any particular order. If you’re searching for a specific skill or topic that’s relevant for you, take a look through the available tips to find the knowledge you need when you need it.

My name is Alex Mozes, and I’m Director of Business Operations at Udemy. Before joining Udemy, I was a Microsoft Certified Master Instructor, and spent my time teaching people around Silicon Valley the secrets of Excel. In this course, I share some of my best tips to help you become more productive and efficient with your spreadsheets. I’ll teach you things like how to calculate dates, the master rule for all Excel functions, and how to teach the autofill tool common patterns you use in your business. We’ll cover tips in calculations, formatting, Excel tools, setting up spreadsheets, managing lists, data analysis and more.

All of these tips are designed to help you increase your productivity and become an Excel whiz. And, if there’s a time consuming activity in Excel you struggle with, let me know in the Q&A section.