Your cart is currently empty!
Category: Excel
Can’t Scroll in Microsoft Excel? 5 Ways to Fix
Are you having problems scrolling through Excel spreadsheets with your mouse, touchpad, or keyboard arrow keys? Does the issue affect all or specific sheets in your workbook? Is the scroll bar missing in your worksheets? Chapters:0:00 Intro0:23 Unfreeze Panes0:45 Re-Enable the Scroll Bar1:17 Disable Scroll Lock1:36 How to Disable Scroll Lock via On-Screen Keyboard2:10 Disable… Read more
Excel File Won’t Open? 4 Fixes to Try
While the main reason you can’t open your Excel file may be that your file is corrupt, there are other causes, like the wrong extension on your file, an unresponsive external device, a problematic Excel add-in, and more. Chapters:0:00 Intro0:23 Uncheck Excel’s Dynamic Data Exchange (DDE) Option1:06 Repair Your Corrupt Excel File1:37 Use Excel’s Office… Read more
How to Show Negative Numbers as Red in Excel
I’ll show you three methods for showing negative numbers as red in Excel. Use whichever you’re most comfortable with or works best for your sheet. Chapters:0:00 Intro0:23 Format the Cells for Negative Red Numbers0:53 Create a Custom Format for Negative Red Numbers1:25 Use Conditional Formatting for Negative Red Numbers2:23 End screen What you’ll learn: 1.… Read more
How to Lock Cells in Microsoft Excel
In this tutorial, we’ll also show you how to protect sheets and entire workbooks in Excel to stop people from making changes to the entire document, as opposed to a few cells. Along with this, we’ll also cover how to unprotect sheets in Excel. Chapters:0:00 Intro0:23 How to Protect Sheet in Excel to Prevent Editing1:03… Read more
How to Compare Two Lists in Microsoft Excel
Microsoft Excel offers two different methods to help you compare two lists and highlight the missing items in each one. You can choose to highlight the missing items in both lists or in a single one. I’ll show you how. Chapters:0:00 Intro0:23 The Quick Way: Highlight Unique Cells to Compare Lists1:09 The Formula Way: Use… Read more
How to Create a Data Entry Form in Microsoft Excel
Manual data entry can be time-consuming and error prone. But if you take a few minutes to create a data entry form in Microsoft Excel, you can improve the process and reduce the risk of mistakes like missing data. Chapters:0:00 Intro0:23 Add the form option1:08 Convert your data to a table1:32 Use the data entry… Read more
How to Calculate a Moving Average in Microsoft Excel
Without equations or functions, you can calculate a moving average easily in Excel. Chapters:0:00 Intro0:23 Add date analysis tool in excel1:06 Calculate a moving average2:06 End screen What you’ll learn: 1. Add the Data Analysis Tool in Excel a. Easy way to calculate and create a line graph to display your moving average in Excel… Read more
How to Make a Checklist in Excel
This video will present how to make a checklist in Excel, plus some pointers on integrating it with other spreadsheet features. Chapters:0:00 Intro0:23 How to use checkboxes in excel1:26 How to link cells in an excel checklist3:21 Modify your excel checklist using conditional formatting4:38 How to make an interactive excel checklist5:06 End screen What you’ll… Read more
How to Separate First and Last Names in Microsoft Excel
Have you got a list of full names that need to be divided into first and last names in separate columns? It’s easy to do that, thanks to Microsoft Excel’s built-in options. We’ll show you how to perform that separation. Chapters:0:00 Intro0:23 How to split first and last names into different columns1:20 Separate and last… Read more
How to Remove Blank Rows in Excel the Easy Way
Learn how to remove blank rows in Excel with the help of the different methods Excel gives you. Chapters:0:00 Intro0:09 Remove blank rows manually0:39 The quick way to remove blank rows in excel1:23 Remove blank rows with find and replace2:10 Remove blank rows in excel with a filter3:06 Remove blank rows by sorting your data3:26… Read more