OneNote Tips and Features
Learn how to use OneNote effectively so you can get the most out of it. OneNote is a great tool to stay organized but it has a lot of hidden features. Read the article to find out more.
Excel Cell Modes
This Excel topic is not talked about often: Excel Cell Modes. Once you know which mode you're in: Ready, Enter, Point or Edit, it will be easier to decide whether to use the arrow keys or switch your mode first.
Ideas in Excel
The "Ideas" button in Excel gives you much more than just some information about your data. It actually creates helpful reports for you using artificial intelligence.
Highlight Range with Blank Cells
You probably know the quickest way to select a column of data in Excel is with the shortcut CTRL + Shift + ⯆. But what do you do if that column includes blank cells and you'd like to highlight the entire column of data? Check out this post to find out.
Excel Printing Repeat Header Rows
As explored in a previous post (Your Excel Printing Problems, Solved!), we outlined the reasons why printing in Excel is a bit trickier than printing in Word.
Printing Tips
Your Excel Printing Problems, Solved! “Why is printing such an issue in Excel? This is one of the most common statements made by new, and veteran, Excel users. We write a document in Word, we hit “Print”, and the document comes out
Excel Advanced Filter Trick
Excel's Advanced Filter Little Known Trick This post will focus on an Excel feature that is unknown to most users, even Excel pros. The feature lies in the way we use the Advanced Filter tool. If you’re not familiar with the Advanced
Excel Flash Fill
Excel's Amazing Flash Fill Excel’s Flash Fill (introduced in Excel 2013) is one of the greatest time-saving features when it comes to fixing data. Flash Fill allows you to “fix” common data format issues like splitting text, merging text, date extraction, text
Excel Spreadsheet Design
Good Spreadsheet Design Principles There are “Dos” and “Don’ts” when creating Excel spreadsheets. These can be categorized into two main areas: Workbook Structure Visual Design of Excel Worksheets Putting into practice and making a habit of as many of the following principles