Excel Shortcuts, Excel Tips, Excel Tricks - Excel Skills!

If you're anything like me, you've probably been using Microsoft Excel for a long time. And with all the features it has to offer, it's hard to believe that there are any shortcuts, tips, or tricks that we don't know about. Well, let me tell you, there are! In this course, I'll share my tips and tricks for using Excel, so that you can get the most out of it. Watch this video to learn more about this course and your instructor, Billy "Mr. Aloha" Wigley.

Let's keep on learning, and remember: Don't Get Mad...Get Skills!

Dive into the future of Excel with this cutting-edge lesson on LABS.GENERATIVEAI! This tutorial is designed for forward-thinking Excel users eager to integrate AI capabilities into their spreadsheets. You'll learn how to install the Excel Labs Add-in, generate and configure your API key, and effectively use the LABS.GENERATIVEAI function. From setting up to executing AI-assisted tasks, this lesson will transform your approach to data analysis. Get ready to enhance your Excel experience with the power of AI!

Who said keyboard shortcuts are not quick? Only the mouse dependent folks! Check out 4 quick shortcuts being implemented in less than 17 seconds. You can also feel free to download an animated GIF of the lecture to share however you wish. Plus, the worksheet used in the lecture is available for you to practice.

Sometimes you may want to quickly select a range of data, and you are working with a defective mouse, or your mouse is on a weird surface, and for whatever reason you are having a hard time selecting a range of data that you want to work with. In this mini lecture you can learn the lovely Ctrl+A.

You can also feel free to download an animated GIF of the lecture to share however you wish. Plus, the worksheet used in the lecture is available for you to practice.

Anybody ever show you Excel and ask you to click on the dialogue box launcher, or the file tab, or the formula bar? Was your answer: “Click on the duh... what?" Is it taking you forever to find answers to your Excel questions when you "Google it?" Are you wondering what that little paintbrush is called? Those days are over! In just minutes this video will have you feeling at home with the basic elements of the Excel 2013 screen. Go for it! "Don't Get Mad...Get Skills!"

You are learning on-line so you will agree that using the right words help you in your Internet searches. It is the same in Excel, knowing the proper terminology will catapult your Excel proficiency.

Learn how to use the Clear tool in the Editing group to quickly clear formatting, and Comments. You can download the spreadsheet and follow along. Keep on learning!

Here are some formatting shortcuts that are commonly used. They not only work in Excel, they work in all of your MS Office applications.

Universal shortcuts are shortcuts that can be applied in almost every software program you work in, not only Excel. These are some of the first shortcuts that we learn when we start learning how to use the software.

Many of my Data Analyst friends are always thanking me for making sure that you learn the basics of Excel, and one feature they always like for me to teach is, Format As Table. This is an excellent habit to get into and it is going to lead to better results and better relationships with your fellow analysts. Keep on learning!

Do you have a large spreadsheet and would like to have an easier way to enter the data? Maybe you are tired of having to freeze panes and scroll back and forth just to enter your data. Well in the magic Quick Access Toolbar (QAT) there is a little button that can turn your header row into a data entry form. Check it out!

It's funny when you realize that you have been pressing buttons because you know what they do, and you realize you never knew what they are called. See how much you know. :-)

Ever hear of "Secret Features" in Excel? Well, there are many "little known" tools in Excel and they can be found in this rarely explored toolbar in your Excel interface. Meet the Quick Access Toolbar (QAT). Fall in love with how easily you can customize it, and amaze people with your Camera skills.

Need to separate simple cell content, such as first names and last names, into different columns? Make it easy on yourself, forget about cutting and pasting! Learn to use the Text to Columns Tool and you can choose how to split it up: fixed width, or split at each comma, period or other character. BONUS shortcuts included, as well as the spreadsheets used in this lesson.

In the public seminar that I present across the USA, many people are unsure of the version of Microsoft Excel that they are working in. Some have multiple versions depending on what computer they are working. Even though I may be presenting an Excel 2013 seminar, there will be people that only have Excel 2007. Does it matter? Well, it depends? In this lesson, you will learn how to easily tell which version you are using.

For the longest time, I did things the hard way. Like inserting rows and columns by right-clicking - haha! Check out this lesson showing you how to instantly insert rows and columns.

Make sure you share your knowledge, and SYNERGYZE with others. That is how you will improve your skills. Feel free to share the downloadable animated GIF of the lesson to share however you wish, and the spreadsheet used in the lesson so you can practice.

Don't Get Mad...Get Skills!

Here is another quick technique for inserting blank rows in between cells. I call this simple technique "sorting them in."

Make sure to check out the downloadable resources attached to this lesson. Share your knowledge - Habit # 6 Synergize.

Here's a quick video showing you how to use shortcuts to find blank rows and delete them via the little known Go To Special. You will also learn how to use shortcuts to find a specific word, and delete the rows containing that word.

I have also included an animated gif version of this video for you to download and share.

After this lecture you are going to want to look a little more into the mysterious Go To Special tool in Excel. This little tool can change your life!

Recently, a student asked me for help improving an existing spreadsheet that they have to work with.

They wanted to speed up their data entry, They were looking for a way to improve productivity.

Most of their data entry was simple, and repetitive. When I saw the spreadsheet, I immediately thought about Data Validation, VLOOKUP, Format As Table, and the Date Stamp.

Step into this lecture and see these techniques in action, then apply them to your own workbooks.

Remember to download the Excel workbook from the Additional Resources, and follow along.

Feel to start a discussion and Synergize (Habit # 6) with the rest of the community by sharing your own Data Entry shortcuts, tips, and tricks!

This lecture was created in response to a question about moving data that is arranged vertically and displaying it horizontally. 

In Excel, this is called TRANSPOSE, and in this lecture, you will learn how to use the Transpose tool in the Paste Special menu.

Worksheet cell protection is an easy way to stop accidental changes when working with large numbers of cells in a spreadsheet. In this lecture, I will show you how to use worksheet cell protection with a simple example.

This lesson will teach you how to create a drop-down list in Excel from data on another Excel worksheet. Once you know how to do this, you can use it over and over again whenever you need to create a drop-down list in Excel.

**Make sure to download the Excel workbook from the resources, and follow along.**

In this lecture, you will learn how to make a drop-down list in Excel that displays items based on what is selected on another list.

For example, the first list contains the Lunch Type and the second list contains the Lunch Items available for that lunch type. When a Lunch Type is selected from the first list, the corresponding Lunch Items are displayed in the second list.

**Make sure to download the Excel workbook from the resources, and follow along.**

When it comes to Excel data analysis, there are few things as important as good, clean, crisp, and accurate data. However, even data that appears to be excellent can use a little “color” to make it more usable. In this lecture, you will learn how to use Excel's conditional formatting to add a little “pizazz” to your drop-down lists, and how to easily customize the colors used for different categories or values.

**Make sure to download the Excel workbook from the resources, and follow along.**

The ARRAYTOTEXT function returns an array of text values from any specified range. It passes text values unchanged and converts non-text values to text.

ARRAYTOTEXT function documentation:

https://support.microsoft.com/en-us/office/arraytotext-function-9cdcad46-2fa5-4c6b-ac92-14e7bc862b8b

Learn the basics of dynamic array formulas through simple examples using TEXTJOIN and TEXSPLIT. In this lesson, you'll explore how to enter a single formula that returns multiple results without manually copying cells.

You will also learn how the SEQUENCE function generates a numeric range with a single formula. Then watch as it dynamically spills the results across a variable cell span.

Discover how dynamic arrays intelligently "spill" results over multiple cells without additional effort. See how easy it is to split and join lists on the fly, and the spilled range operator (#) refers to an entire spilled result set at once.

By the end, you'll understand the core concepts of dynamic arrays - entering one formula that does the work of many. You'll also gain a foundation for more advanced uses through TEXTJOIN and TEXSPLIT's array capabilities.

Beginning Excel users can learn dynamic arrays from these straightforward examples. More experienced users will appreciate the time-saving benefits for list-based tasks. So join in to add dynamic arrays to your formula toolkit!

Working with text in Excel? Need to change the case of some text just like you do in Word and can't find the "change case tool?" No worries, in Excel you use TEXT functions. Here you will learn how it's easy! Just watch the video, get some skills, and practice on the downloadable spreadsheet. -- Don't Get Mad...Get Skills!

Want to combine the contents of various cells into one cell, and have them appear in the order that you need? Well, it's EASY! Just use the simple CONCATENATE function in Excel. Here is how you do it.

Use this Quiz to anchor your knowledge of TEXT functions - you are an EAGLE!

Have you ever had a list of items in your Excel spreadsheet numbered according to the row numbers of the worksheet, and when a new item is inserted the row numbers no longer match the items? Bummer, now you have to re-organize everything - WAIT!

Just use this quick lesson on organizing your data and sorting to maintain spreadsheets that work. Make sure you check out the downloadable material for you to practice your new skills on! :-)

Working with a table that has repetitive entries?

The Auto complete works great when you remember the names of all the items. What happens when you don't know or remember what all of the names are?

You think: “It would be great if Excel would just automatically make me a drop-down menu with a list of items instead of having to keep re-typing.”

Well, guess what? It does!

Let me show you – it's so easy that I better throw in a few bonus shortcuts while we work. AND – we are going to go mouseless!

When used in a cell reference F4 anchors the cell thus making it an ABSOLUTE cell reference. What's an ABSOLUTE reference? Well, it's a cell that has been anchored? What's anchored? Check out the lesson, and in less than 29 seconds you will know the answers.

Remember to check out the downloadable files to practice your skills, and share your knowledge.

Can you insert a current date and time stamp into a cell in Excel? Of course, you can! While there are many ways to accomplish this objective, this quick video will show you one way. You will learn: a date and time function, and a shortcut to turn your function into a static value.

Need to look up something in an Excel spreadsheet? Perhaps we have a spreadsheet with information on departing flights, and we want to find the departure gate of our flight. We look down the column with the flights, find our flight number, look over to the right, and find the gate number in a certain column. Simple, right? We can have Excel easily do this for us by using the VLOOKUP function. In this quick video, you will learn how to write a formula using the VLOOKUP function.

Did you know about the PivotTable Wizard? I have been using it since Excel 2007, and all the way up to 2016.

That’s right, there is a PivotTable wizard, and not many people know about it. When would you use it?

You want to consolidate multiple data ranges into one PivotTable (also known as the filter on steroids) to make dynamic reports and analyze your data, including a chart. Something like a mini-dashboard.

So what’s a quick way to build a mini-dashboard?

Let’s use the PivotTable Wizard, and consolidate our multiple ranges into one PivotTable report with a chart, and we will control it with a slicer.

Want to quickly summarize a large spreadsheet of data, and get multiple views of it? Well, learn how to use a PivotTable. In this easy lecture, you will learn how to create a slicer controlled PivotTable with a chart, in less than two minutes. You will appear to be "Genius like!"

The PivotTable is Excel's "filter on steroids" that you use when analyzing large spreadsheets. They are easy to use, and the results are a product of how you decide to organize the data to answer the questions you have.

Let this easy lecture begin your introduction to PivotTables. Stay tuned, and keep coming back as we build on this PivotTable skill!

Remember to check the downloadable files for reference materials.

Keep sharpening your FUNCTION skills by returning to this quiz as more lectures are added, and new questions appear.

There are over 500 functions in Excel, and each version has new functions. Learn how to use the IFNA function that was introduced in Excel 2013.

Keep on learning!

Use the Excel XLOOKUP function to find values in a table or range by row. For example, find an employee's name based on their employee ID. With XLOOKUP, you can look in one column for a search term, and return a result from the same row in another column, regardless of which side the return column is on.

Go ahead and download the Excel workbook from the Resources for this lecture, and follow along with hands-on.

Let's keep on learning!

The XLOOKUP function in Excel is fun to use and extremely powerful. In yesterday's live stream we got an introduction to the XLOOKUP. In this live stream, we will learn how to use the [match_mode] and the [search_mode] Arguments in XLOOKUP.

Go ahead and download the Excel workbook from the Resources for this lecture, and follow along with hands-on.

Let's keep on learning!

You'll discover how to use Excel's nested XLOOKUP function to do a vertical match (profitability) and a horizontal match (quarter). This is similar to using the INDEX and MATCH functions together, or the VLOOKUP and HLOOKUP functions.

Go ahead and download the Excel workbook from the Resources for this lecture, and follow along with hands-on.

Let's keep on learning!

Tired of struggling to find values in your Excel sheets? In this tutorial, I'll show you how to take your lookups to the next level with VLOOKUP, the newer and improved XLOOKUP function, and spilled arrays. You'll learn how to easily search columns for specific text or numbers and return matching values.

We'll cover the basics of VLOOKUP for looking up an Employee ID, Name and Department. Then upgrade to XLOOKUP for more flexibility. I'll also demonstrate how spilled arrays let you return multiple results at once without multiple formulas.

By the end, lookups will be a breeze. You'll be able to quickly find anything in your Excel data. So join me to supercharge your lookup abilities and wrap your head around these handy functions and techniques. Your Excel productivity is about to skyrocket!

In this advanced tutorial, we're supersizing your lookup skills. I'll demonstrate how to create a dynamic VLOOKUP using defined name ranges so your formula never breaks when data moves.

But wait - it gets even better! We'll nest the VLOOKUP inside an IF statement to return conditional results. You'll see how nesting formulas unlocks new possibilities in Excel.

By the end, you'll understand how named ranges make lookups flexible and adaptive. Plus learn to incorporate logic with nested IFs.

Get ready to watch your Excel wizardry rise to the next level! I'll guide you through building these pro-level techniques step-by-step using an included workbook. Your spreadsheets will never be the same after optimizing lookups like a power user. Let's do this!

Learn some shortcuts for opening a NEW workbook, and creating duplicate worksheets! There is also a BONUS piece teaching you how to have Excel open NEW workbooks with your specified number of worksheets already included.

This lecture was created in response to a question from a student. Alice asked for an easy way to "share" a workbook, and then "merge" the shared workbooks.

Remember - to easily merge workbooks make sure that you "share" them first.

This lecture is in response to the following question I received from a student in this course:

Hey, Billy. This is Debbi from your last Elk Grove, IL course. Have a workbook that two of us work on from a network folder -- the workbook is not officially "shared." A colleague made changes without "track changes" on. A second version of the file got saved. Any way to synchronize these? Or at least see what changes were made in one or the other file and then manually update the content?

Why make it hard? when creating a chart the key is your source data, remember: "Garbage in, Garbage out."

I always like to start out with my default chart and take it from there. That way I feel like I am accomplishing something right of the bat. Press F11 and bam! - there's your chart, just make sure you have all the ingredients in place before you show off your F11 and Alt+F1 skills. Or else, haha - it will be funny.

Make sure you use the downloadable files and practice. Also, feel free to begin a discussion and reach out to me when you need help.

Aloha!

With only 86,400 seconds in a day, every decision you make is an investment of your time. Learn two stress-free Excel shortcuts and one new tool that will maximize your productivity.

-Don't Get Mad...Get Skills!

There are all kinds of cool tools in Excel 2013 that, used with their corresponding shortcuts, will make your life so much easier. You will appear to be "genius-like" to those that are watching you rock at Excel.

We all like looking at a good DataBar and being able to quickly identify the most important data in an excel spreadsheet. Now let's take it to another level and add another type of conditional formatting like icons by applying this simple technique.

Want to learn more? You can always get more tips and tricks by watching my daily YouTube stream. The link to my YouTube channel in my Instructor Profile.

Keep on learning!

Here is a quick video I made to show the basic steps to recording a macro. It's in response to a question I received. Feel free to download and share the animated gif in the resources. Keep on learning!

Aloha!

Print out this PDF and feel free to distribute it. Put your own logo on it if you wish. The main objective here is to share your knowledge. Abundance Mentality!

While setting up my new studio (123 Aloha Studio of Las Vegas), and testing out some video settings to ensure future success in my video production. I was reminded of how important it is to always get back to the BASICS.

When you want your shortcuts, tips, and tricks to work well you better get it right from the start and understand how to properly build your worksheets. Here is a BONUS lecture that teaches you the 7 Steps To Worksheet Success. I made it while setting up the new studio, so the editing is limited (rough cut). Enjoy the learning!

This video is in response to this question: https://www.udemy.com/course/dontgetmadgetskills-excel-shortcuts/learn/#questions/9836702/

Aloha Friday!

Enjoy these 8 Excel Secrets that you can apply immediately and get your career rolling.

Make sure to follow along with the included Excel workbook.

Keep on learning, my friend.

Learn how to build a Summary sheet by utilizing 3D referencing. You can sum cells in multiple worksheets into one.

Make sure to follow along with the attached workbook.

Enjoy!

Let's keep on learning!

???

Thank you for taking this course

Excel Shortcuts, Excel Tips, Excel Tricks - Excel Skills!

As a part of the community, here is your BONUS lecture.