Tutorials

Percent of Total in Excel – 3 SIMPLE METHODS (PLUS PIVOT TABLES)

Ever wondered how much each piece of your data contributes to the whole? Calculating a percent of total is a quick way to figure...

How to Use Focus Cell in Microsoft Excel

If you've ever lost track of your active cell in Excel while working with massive spreadsheets, you're definitely not alone. Microsoft just rolled out...

How to Create a Dynamic Data Entry Form in Excel

Data entry in Excel can be tedious, especially when you're manually entering rows of information. Fortunately, there's a way to streamline that process, creating...

How to Join or Split Data in Microsoft Excel

If you've ever struggled with joining or combining data into a single cell or splitting it across multiple cells in Microsoft Excel, you're in...

How to Find Unknown Goal Data in Excel with Goal Seek

Have you ever needed to figure out the missing numbers in a spreadsheet? Whether you’re trying to hit a sales target, balance student grades,...

How to Pull Live Data from Stock Market in Excel

Do you feel like you're constantly checking stock prices, looking at the highs and lows, analyzing the percentage changes, or maybe just tracking your...

Boost Productivity with Excel’s New Checkboxes

Microsoft has finally made checkboxes easier to use in Excel, and it’s a major change for anyone into task management or tracking progress. If...

How to Combine Multiple Columns or Rows into One List in Excel

Managing data in Excel can quickly become overwhelming, especially when you're dealing with multiple columns or rows and need them in one list. If...

How to Create a Customized Tab in Microsoft Excel

Do you use the same tools over and over in Microsoft Excel? If you’re constantly clicking around to find them, there’s a better way....