30
793 887

How to do an XLOOKUP with multiple variables / criteria

7:09

Make a Goal Tracker in Excel in 11 Minutes

12:56

Create a Dungeons and Dragons Initiative and Hit Point Tracker in Excel in Seconds

9:52

How to copy/import data from print, paper, images, or video into Excel

4:56

Excel's new text functions will save you loads of time!

8:37

Master Automated Lists in Excel in 3 Minutes!

3:01

Fix broken dates in Excel in Ten seconds

Often in Excel, formulas referencing dates don't work right.
They may give you a #VALUE error, even with the simplest of formulas.
Here is an explanation of what's going on, and quick instructions on how to easily fix the problem in just a few seconds.
Additional Resources:
Excel For Accounting course on LinkedIn Learning: www.linkedin.com/learning/excel-for-accounting
Rockstar Excel website: rockstarexcel.com/
Newsletter for free tips on using Excel to make your life easier: rockstarexcel.com/newsletter/
Book a free consultation: rockstarexcel.com/book-a-free-discovery-session/
Theme music by Michael Gordon Shapiro: mikemusic.com/

มุมมอง: 698

วีดีโอ

How to do an XLOOKUP with multiple variables / criteria

7:09

How to do an XLOOKUP with multiple variables / criteria

มุมมอง 60Kปีที่แล้ว

XLOOKUP is one of the most useful functions in Excel. But it doesn't work with multiple variables. Here I should you some workaround so that you're able to use multiple variables/criteria in your lookup. Additional Resources: How to standardize names in Excel: th-cam.com/video/OKxHcnJmTCw/w-d-xo.html Absolute and relative references Part One: th-cam.com/video/PrJF5cYKZhk/w-d-xo.html Part Two: t...

Make a Goal Tracker in Excel in 11 Minutes

12:56

Make a Goal Tracker in Excel in 11 Minutes

มุมมอง 22Kปีที่แล้ว

Want to keep track of your progress on exercise, weight loss, self-improvement, or business goals? In this tutorial I show you how to make a tracker/dashboard so you know how you're doing, a monthly summary, and whether you're on pace to meet your target. This spreadsheet will also automatically calculate what adjustments you need to make to meet your goal based on what you've done so far. Addi...

Create a Dungeons and Dragons Initiative and Hit Point Tracker in Excel in Seconds

9:52

Create a Dungeons and Dragons Initiative and Hit Point Tracker in Excel in Seconds

มุมมอง 8Kปีที่แล้ว

Tracking initiative and hit points in Dungeons and Dragons is always a pain. Here I show you how to make your life easier with a quick Excel spreadsheet that automatically puts player characters and monsters in initiative order, and keeps track of any damage and healing. Let Excel do the math, so you can focus on role-playing! Additional Resources: Make a Dungeons and Dragons Encounter Tool in ...

How to copy/import data from print, paper, images, or video into Excel

4:56

How to copy/import data from print, paper, images, or video into Excel

มุมมอง 31K2 ปีที่แล้ว

Have you ever wanted to copy or import information into Excel from a book, sheet of paper, image, or video? That used to be impossible without manually retyping it. But now you can automatically import the data in seconds with Excel's new Import from Picture feature. Additional Resources: Video that screenshot was taken from (Making a Dungeons and Dragons Encounter Tool in Excel - An XLOOKUP Tu...

Excel's new text functions will save you loads of time!

8:37

Excel's new text functions will save you loads of time!

มุมมอง 5442 ปีที่แล้ว

Microsoft recently added three new text functions to Excel: TEXTBEFORE, TEXTAFTER, AND TEXTSPLIT. These are incredibly powerful and will save you loads of time! Learn how to use them, some tips on making them even more useful, and how to add these to your version of Excel if you don't already have them. Excel Made Easy class: rockstarexcel.com/excel-made-easy/ Using tags in Excel: th-cam.com/vi...

Master Automated Lists in Excel in 3 Minutes!

3:01

Master Automated Lists in Excel in 3 Minutes!

มุมมอง 17K2 ปีที่แล้ว

Automated lists are a great way to save time in Excel. By simply dragging the fill-handle (or little green box in the lower right corner of highlighted cells), you can create lists of numbers, dates, months, or days of the week. You can also set up your own custom lists for names, departments, regions, expense categories, or anything else that you have to retype frequently. Additional Links: Ro...

Making a Dungeons and Dragons Encounter Tool in Excel - An XLOOKUP Tutorial

24:19

Making a Dungeons and Dragons Encounter Tool in Excel - An XLOOKUP Tutorial

มุมมอง 5K2 ปีที่แล้ว

Figuring out how to make encounters in Dungeons and Dragons the right amount of difficulty is a challenging task, involving a lot of trial and error and repetitive math. Here I walk you through creating an Excel spreadsheet to automate this process, starting with a blank file and ending with a fully-functional and well-polished tool. This spreadsheet relies heavily on XLOOKUP, so this tutorial ...

Don't merge cells in Excel! Center across selection instead

7:46

Don't merge cells in Excel! Center across selection instead

มุมมอง 73K2 ปีที่แล้ว

The Merge & Center feature/button in Excel may be useful in terms of formatting, but will cause all sorts of problems when trying to build formulas. Instead, use the lesser-known Center Across Selection feature, which produces results that *look* exactly the same as merged cells, but without any of the drawbacks. Additional Links: Rockstar Excel website: rockstarexcel.com/ Newsletter for free t...

Mixed relative and absolute references make powerful Excel spreadsheets easy!

8:35

Mixed relative and absolute references make powerful Excel spreadsheets easy!

มุมมอง 3502 ปีที่แล้ว

Learn how mixed relative and absolute references let you build complex spreadsheets in seconds. This is part two of my videos on relative and absolute references. You can find part one here: th-cam.com/video/PrJF5cYKZhk/w-d-xo.html This video is recorded from my Excel Made Easy class. If you want to master Excel in just four two-hour sessions - without having to learn anything hard - check out ...

How to Use Relative and Absolute References in Excel

6:32

How to Use Relative and Absolute References in Excel

มุมมอง 4032 ปีที่แล้ว

Learn how to work with relative and absolute references in Excel. This is one of the most important concepts to understand as you move up to the intermediate level in your Excel journey. This video is recorded from my Excel Made Easy class. If you want to master Excel in just four two-hour sessions - without having to learn anything hard - check out rockstarexcel.com/excel-made-easy/ Watch part...

How to get better at Excel (See my face!)

5:23

How to get better at Excel (See my face!)

มุมมอง 3383 ปีที่แล้ว

Do you want to improve your Excel skills? Here I share some of my methods for getting better at Excel over the course of your career/life. If you REALLY want to become an Excel master, check out my Excel Made Easy course, which is guaranteed to save you five hours a week, or your money back: rockstarexcel.com/register-for-the-excel-made-easy-class/ Additional Links: Rockstar Excel website: rock...

25:11

How to clean messy data in Excel

มุมมอง 17K3 ปีที่แล้ว

Cleaning messy data in Excel is both an art and a science. Often the same cells contain multiple types of information that need to be separated, you have garbage information to remove, or columns contain a mix of different things. Here I go through three examples of messy spreadsheets, showing some of the methods I use to fix them. If you have data you want me to clean in a future video, email ...

Blank cells acting weird? Here's how to fix it!

6:04

Blank cells acting weird? Here's how to fix it!

มุมมอง 27K3 ปีที่แล้ว

Are your blank cells in Excel acting weird? Is Excel not treating them as blank, or giving you weird errors? Here's I explain why it's happening and how to fix it. Resources: Learn more about filters: th-cam.com/video/-a6fEJpxm-0/w-d-xo.html Rockstar Excel website: rockstarexcel.com/ Upcoming courses: rockstarexcel.com/courses-and-consulting/ Book a free consultation to learn how we can save yo...