Excel tutorial on how to create a pivot table chart in Excel. A pivot chart is a dynamic chart used to summarize pivot tables – i.e., these charts are linked to pivot table data. In this Excel tutorial, we go over how to add a pivot table chart in Excel and then how to format […]
Excel Tutorials
Generate Random Numbers Using RAND + RANDBETWEEN functions in Excel – Tutorial
Excel tutorial on how to generate random numbers in Excel. We’ll look at 2 ways of creating random numbers. We’ll look at how to use the RANDBETWEEN function and how to use the RAND function to do this. What is the RANDBETWEEN function in Excel? Use the RANDBETWEEN formula to generate random numbers in Excel […]
Extract Data in Excel Cells When You Don’t Know the Starting Point – MID Function Excel Tutorial
Excel tutorial on how to use the MID function in Excel when you don’t know the position of the character where that data begins. The MID function in Excel lets you extract data from inside a cell in Excel, but normally you need to know in which character to start applying the function in. Take […]
How to Calculate Time in Excel – Tutorial
Excel tutorial on how to add time and subtract time in Excel. We’ll walk through examples of calculating time in Excel by creating an itinerary for a meeting and then calculating hours worked.
How to Use the FIND + SEARCH Functions in Excel – Tutorial
Excel tutorial on how to use the FIND function and SEARCH function in Excel to 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, RIGHT or MID functions.
How to Make a Word Search Puzzle in Excel (+ video tutorial)
Word search puzzles are a great idea for team-building events, work parties, family gatherings, and more. Plus, they’re pretty easy to make! Here are step-by-step instructions of how you can make a word search in Excel. Make a Word Search in Excel (easy to do!) WATCH: How to Create a Word Search Puzzle in Excel […]