Excel tutorial on how to design the Comment Box in Excel. We’ll first go over how to change the color, borders and other aspects of the box and then over how to change the shape of the Comment Box.
Thanks for watching this Microsoft Excel tutorial and...

From YAcosta Solutions

Excel tutorial on how to use Subtotal in Excel. In this video, we’ll use the Subtotal button found in the Data tab and then we’ll go over how to use the SUBTOTAL function.
The SUBTOTAL function is made up of 2 things: a math calculation (in the form...

From YAcosta Solutions

Excel tutorial on how to custom sort in Excel. Doing a custom sort allows you to specify the order in which your list will be sorted in.
You may want to do a custom sort to sort items in an order that is not alphabetical or numerical. For example, if you...

From YAcosta Solutions

Excel tutorial on how to save an object in Excel as an image and how to then convert it to an image file - like a jpg or png.
Making an image can come in handy for times, like, if you want to use an Excel chart or table as a jpg or png in other programs ...

From YAcosta Solutions

Excel tutorial on how to round time in Excel.
Excel has many rounding functions, but, we'll use MROUND in this tutorial because I like how it’s able to round up or round down to whatever multiple we want to use.
There are various reasons why you may n...

From YAcosta Solutions

Excel tutorial on a few different ways to join cells in Excel. We'll do this by looking at how to use the ampersand (&) in Excel, then CONCATENATE, followed by CONCAT and, lastly, TEXTJOIN.
Ampersand and CONCATENATE are both used in Excel to combine con...

From YAcosta Solutions

Excel tutorial on how to show Fractions and use Fractions in Excel.
Depending on your project, you may want to display your numbers as fractions, instead of decimals, in your spreadsheet.
This is easy to do by using Fraction formatting!
In our fractio...

From YAcosta Solutions

Excel tutorial on how to convert time to number in Excel.
You may need to convert time to decimal number in Excel to calculate time worked or when you need to multiply total time worked by a currency to calculate pay, for example.
In this tutorial, yo...

From YAcosta Solutions

In this Excel tutorial, we’ll go over 12+ of my favorite Excel shortcuts that I use frequently - this will be done using a Windows compatible keyboard.
Using keyboard shortcuts, instead of reaching for your mouse all the time, is a great way to save ti...

From YAcosta Solutions

Excel tutorial on how to set character limits in Excel cells.
In this example, we'll limit the character length in cells that will be used for a state field. The cells will need to be restricted to entries of only 2 characters (to fit the state abbrevia...

From YAcosta Solutions

Excel tutorial on how to make a dropdown list in Excel. We'll walk through an example of how to create and then edit a dropdown list in an Excel spreadsheet.
You'll also see how you can add a custom message to the items in your drop down list and, if you...

From YAcosta Solutions

Excel tutorial on how to create a custom theme in Excel. A custom theme is useful when creating documents or presentations with specific requirements, such as branding elements you need to use.
Plus, once you create your theme, it will also be available...

From YAcosta Solutions

Excel tutorial on how to find cells used in formulas in Excel.
Sometimes spreadsheets end up with soooo many numbers and formulas that it can get confusing figuring out which formulas are affected by which cells.
Using an example, we'll go over how to ...

From YAcosta Solutions

Excel tutorial on how to use the Data Bars, Data Scales and Icon Sets options of the Conditional Formatting styling feature in Excel.
Using these to format your data can help you create a more visually interesting way to show your data and, because the c...

From YAcosta Solutions

Excel tutorial on how to use Map Charts in Excel to create a map directly in your spreadsheet. You can create a map to show values and categories by geographic area - worldwide, by country or closer!
You can make 2 types of map charts using Excel:
1. eit...

From YAcosta Solutions

Excel tutorial on how to insert a picture in a chart in Excel, i.e., how to make a pictograph in Excel.
Using a picture for symbols in Excel charts can help make your charts more personal and impactful.
In this tutorial, we walk through inserting a pi...

From YAcosta Solutions

Excel tutorial on how to use the Camera Tool in Excel. The Camera Tool lets you do dynamic screenshots that are linked to the source that you captured with it.
This means that, if the cells in your screenshot change, your screen capture will automatical...

From YAcosta Solutions

Excel tutorial on how to make angled cells in Excel. Rotated cells in Excel can help your spreadsheets look more professional.
In this tutorial, we go over how you can easily rotate cells / angle cells both by using preset degrees or to a specific degre...

From YAcosta Solutions

In this tutorial, we go over how to track hours worked in Excel. We’ll also go over how to calculate pay in Excel for the hours worked.
Useful for freelancers, independent contractors and anyone that needs to track hours for a job or create a timesheet...

From YAcosta Solutions

In this short, Excel tutorial, we’ll go over some ways to add bullets in Excel.
Useful when creating documents or presentations, knowing how to insert bullets in Excel spreadsheets can help organize important points or instructions.
Thanks for watchi...

From YAcosta Solutions

In this Excel tutorial, we’ll learn how to add a blank line, or a paragraph line, in a cell in Excel + how to change the look of the cell from seeing the blank lines to seeing the cell contents listed together.
Knowing how to add a blank paragraph lin...

From YAcosta Solutions

Excel tutorial to learn how to create a password using random letters and numbers in Excel. We’ll create a password generator file that you can save and use anytime you need a new password.
In this example, we’ll make a password that will have 7 ran...

From YAcosta Solutions

Short tutorial to learn how to create a calendar using Excel that reveals a picture in the background as the date changes.
In this example, we walk through creating a month calendar and then:
- Formatting the dates on the calendar
- Inserting an image t...

From YAcosta Solutions

Learn how to use the Goal Seek function in Excel to solve what-if scenarios. This short tutorial walks through an example of using the Excel Goal Seek feature.
What is Goal Seek in Excel?
One of Excel’s forecasting tools, Goal Seek is a feature used t...

From YAcosta Solutions

Learn how to make checkboxes in Excel! In this short tutorial, we'll go over how to add checkboxes to Excel spreadsheets. You can add checkboxes when making to-do lists, task lists, chore lists, multiple choice questions or when you want to create interac...

From YAcosta Solutions

Learn how to create a goal thermometer in Excel. A goal thermometer can be used to track fundraising donations, debt as you pay it off, weight loss and other goals that can be quantified.
In the example in this Excel tutorial we create a debt payoff the...

From YAcosta Solutions

In this Excel tutorial, we’ll go over what Excel autofill is, how to create a new Autofill list in Excel that you can reuse in different worksheets and how to modify a custom autofill list. Learning how to use autofill can help save time when working in...

From YAcosta Solutions

Learn how to use Highlight Cells Rules in Excel Conditional Formatting. In this short Excel tutorial, we’ll walk through examples using Highlight Cell Rules to learn how to highlight cells in Excel spreadsheets using Conditional Formatting.
What is Con...

From YAcosta Solutions

Learn how to format a calendar in Excel. We'll start with a month calendar in Excel and format it for the full year. In our spreadsheet, we’ll also create a conditional format to highlight the current day.
This Excel calendar will be fillable and print...

From YAcosta Solutions

Short tutorial walks through how to create a Google Map using an Excel data file. We'll go over how to format your Excel file so that it's ready for importing into Google Maps. After we import it, we'll go over some ways that you can format your Google ma...

From YAcosta Solutions

Create a Word Jumble in Excel! This short tutorial will show you how to scramble letters in words to quickly make a fun brain game in Excel. Easy to learn how to create a word scramble in a spreadsheet.
In the word jumble example in this video, we walk t...

From YAcosta Solutions

Short tutorial on how to make a table in Excel. Also, how to convert a list of data to an Excel table. Learn how to create, format and use Excel tables.
Excel tables give you more options to manipulate data than a simple list of data does. Why? Because t...

From YAcosta Solutions

Short Excel tutorial on how to use the payment function to calculate loan payment amount. Examples to walk you through how to use PMT function in Excel.
What is the payment function in Excel?
PMT, the Payment formula, is used to calculate loan payments....

From YAcosta Solutions

Crossword! Learn how to make a crossword puzzle in Excel! This way your puzzle can have the words you want, for the theme you want and formatted exactly how you like. Watch this short MS Excel tutorial to learn how to make your own crossword game using Mi...

From YAcosta Solutions

Learn how to make a chart in a pivot table in Excel! A pivot chart is a dynamic chart used to summarize pivot tables - these charts are linked to pivot table data.
In this Excel tutorial, we'll go over how to add a pivot table chart in Excel and how to ...

From YAcosta Solutions

Learn how to generate random numbers in Excel using the RAND function and the RANDBETWEEN function in Excel as a random number generator. The random number functions in Excel, both the RAND function and the RANDBETWEEN function, are used to generate rando...

From YAcosta Solutions

Calculate Time in Excel. Watch this short tutorial to learn how to add time and subtract time in Excel. Learn how to calculate time difference in Excel spreadsheets.
The TIME formula in Excel, combined with other basic functions and time formatting, can...

From YAcosta Solutions

Excel tutorial on how to use the FIND formula and SEARCH formula in Excel help you find the numerical position of a character within a cell.
These formulas are often used inside other formulas where cell position is important - for example in the LEFT, ...

From YAcosta Solutions

Create your own Word Search puzzle in Excel. This short tutorial shows you how to make a Word Search in Excel - even for Excel beginners!
Wordsearch is such a great word puzzle game for a wedding shower or bridal shower, retirement party, office party, ...

From YAcosta Solutions

Use the LEFT, RIGHT, MID and Text to Columns Functions to Pull Data from within cells in Excel. This short Excel tutorial shows examples of how to use the LEFT, RIGHT and MID functions in Microsoft Excel. We also extract data using Text to Columns.
The ...

From YAcosta Solutions