How to Repeat Column A on every Page in Excel
Need to learn how to set column A to print on every page in Excel? This feature is called Print Titles and…
-
-
How Change Case in Excel
In this blog we will cover how to change the case of your text in Excel with or without a formula. If…
-
How to set Row 1 to print on every page
Let’s look at how to set row one to print on every page of your Microsoft Excel spreadsheet. This feature is called…
-
Best Keyboard Shortcuts for Excel Beginners | Tips and Tricks
Learn the BEST Excel keyboard shortcuts. Perfect for Beginners and for those who want to save time and work smarter. It doesn’t…
-
How to Make changes to a Design Ideas Slide in PowerPoint
Let’s look at how to edit Design Ideas in PowerPoint. If you’re like me, you probably love the Design Ideas slides in…
-
Find, modify and break links to an Excel workbook
Learn how to find, modify and break links to an Excel workbook. Linking is great, until you no longer need it. Then…
-
Save an Excel workbook, including save a copy and save as PDF
Being confident in how to save an Excel workbook, including save a copy and save as PDF, is a fundamental skill in…
-
How to total a range of cells in Excel
The quickest way to total a range of cells in Excel is to use the SUM function. The Sum function is one…
-
How to Sum only visible cells in Excel when using Filter
A common question I get asked when I’m teaching people how to filter data is “how do I sum only the visible…
-
Filter data in Excel
Learning how to filter data in Excel enables you to find and work with just a subset of a larger list or…
-
Excel – Using VLOOKUP to compare two lists
If you’re using Microsoft 365, XLOOKUP is now the better and more flexible option than VLOOKUP, and I highly recommend learning it…
-
Excel – Restricting editing in worksheets and workbooks
Needing to create a single worksheet, or an entire workbook, where you do not want other users to be able to make…
