Smart Tips: Excel

Smart Tips: Excel, available at $74.99, has an average rating of 4.6, with 54 lectures, based on 8685 reviews, and has 33585 subscribers.

You will learn about Become more productive with Microsoft Excel Master calculations in excel with a master rule for all functions Simplify formatting to quickly create professionally formatted spreadsheets Discover useful tools like autofill, sparklines, and goal seek Use charts, pivot tables, and other tools to manage lists and analyze data This course is ideal for individuals who are Designed for beginner to intermediate Excel users who want to become more productive and efficient in Excel. or Advanced Excel users may be familiar with some of the tips in this course. It is particularly useful for Designed for beginner to intermediate Excel users who want to become more productive and efficient in Excel. or Advanced Excel users may be familiar with some of the tips in this course.

Enroll now: Smart Tips: Excel

Summary

Title: Smart Tips: Excel

Price: $74.99

Average Rating: 4.6

Number of Lectures: 54

Number of Published Lectures: 54

Number of Curriculum Items: 54

Number of Published Curriculum Objects: 54

Original Price: $69.99

Quality Status: approved

Status: Live

What You Will Learn

Become more productive with Microsoft Excel
Master calculations in excel with a master rule for all functions
Simplify formatting to quickly create professionally formatted spreadsheets
Discover useful tools like autofill, sparklines, and goal seek
Use charts, pivot tables, and other tools to manage lists and analyze data

Who Should Attend

Designed for beginner to intermediate Excel users who want to become more productive and efficient in Excel.
Advanced Excel users may be familiar with some of the tips in this course.

Target Audiences

Designed for beginner to intermediate Excel users who want to become more productive and efficient in Excel.
Advanced Excel users may be familiar with some of the tips in this course.

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.

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction to Smart Tips: Excel

Chapter 2: Calculations

Lecture 1: Calculate Dates: How many DAYS old are you?

Lecture 2: The master rule for all functions

Lecture 3: Text functions: Left, Mid, and Right

Lecture 4: More Text Functions

Lecture 5: Concatenate: Put multiple values into the same cell

Lecture 6: Break up your text strings with Text to Columns

Lecture 7: What are the Dollar signs in formulas? Absolute vs. Relative References

Lecture 8: Advanced functions made easy: Nesting functions

Lecture 9: Track the variables and consequences of your formulas with arrows

Lecture 10: Find the error in your complex formula by watching each step

Lecture 11: Expose the guts of a spreadsheet and show formulas in cells

Lecture 12: Name your ranges and simplify your formulas

Lecture 13: Linking data from one place to another

Chapter 3: Formatting

Lecture 1: Customize your date format

Lecture 2: Insert Rows and Columns Properly

Lecture 3: Autofit columns, wrap and shrink text to see your data better

Lecture 4: Understand trends at a glance with Conditional Formatting

Lecture 5: Save a custom style for common formats

Lecture 6: The risks and rewards of the Merge Cells tool

Lecture 7: Fun with borders

Lecture 8: Quickly copy formatting to one or multiple cells

Chapter 4: Useful Tools

Lecture 1: Secrets of the Autofill tool

Lecture 2: MORE Secrets of the Autofill tool: Creating custom lists

Lecture 3: Rotate your data with Transpose

Lecture 4: Goal Seek: Let Excel find the optimal value

Lecture 5: Format Shortcuts to make short work of your spreadsheet

Lecture 6: Scenario manager: Save your "what if" values

Lecture 7: Data validation: Add dropdown menus and error messages to a cell

Lecture 8: Solver: The Ultimate Add-on for complex questions

Lecture 9: How Big is Excel? Journey to the edge!

Lecture 10: Add, multiply or divide a set of data without a formula

Lecture 11: Sparklines: Quick reference trendlines for your data

Lecture 12: Add a slider to control numbers on your spreadsheet

Lecture 13: Save your filters and view settings with custom views

Lecture 14: Consolidate multiple tables into one

Chapter 5: Managing Lists

Lecture 1: Why and how to format a list as a table

Lecture 2: Quickly add automatic subtotals

Lecture 3: Remove duplicates with ease

Lecture 4: What is an Advanced Filter?

Chapter 6: Setting Up a Spreadsheet

Lecture 1: Lock your headers when reading large data sets with Freeze Panes

Lecture 2: Protect your data from meddling

Lecture 3: Scroll in multiple directions at once

Lecture 4: Secrets to printing data from a spreadsheet

Chapter 7: Data Analysis

Lecture 1: 6 Minutes to Master Pivot Tables

Lecture 2: Change how a pivot table calculates data

Lecture 3: A fun way to filter: The Drill To feature in Pivot Tables

Lecture 4: 7 minutes to creating Excel charts

Lecture 5: Showing data at different scales on the same chart

Lecture 6: Fun with Pie Charts

Lecture 7: Pivot Charts – The ultimate in dynamic data analysis

Lecture 8: Use the Slicer tools for convenient Pivot Tables

Lecture 9: Create a dashboard: add multiple Pivot Tables to the same sheet

Lecture 10: Make a custom, fancy chart in one click

Instructors

Alex Mozes
Teacher and learner

Rating Distribution

1 stars: 21 votes
2 stars: 42 votes
3 stars: 583 votes
4 stars: 2963 votes
5 stars: 5076 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu