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
Import Data from Web to Excel
Easily Import Data from Web to Excel (2 Practical Examples) This post will demonstrate how to import data from the Web into Excel. There are many techniques available for this task; some are better than others, depending on the dynamic/changing nature of
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
Switch Data in Columns to Rows in Excel (Unpivot in Power Query)
Switch Data in Columns to Rows Transpose or Unpivot (Some) Fields This will be another tutorial on transposing horizontal data into vertical data. But this technique has a twist. No, wait! TWO twists! Twist 1: we don’t want to change ALL the
Microsoft Excel Justify
The QUICKEST & EASIEST Way to Work with TEXT in Excel Justify Feature When creating a solution for a user, it’s a good idea to give the user an instruction sheet. This is not an issue in Word, but it can
Excel Hyperlink
ALL YOU Need to Know About Excel HYPERLINKS (Function & Feature) Hyperlinks! They’re everywhere…even in Excel! “But Excel isn’t a Web browser. How can hyperlinks be of any value?” Here are the skills we will learn to take advantage of Excel hyperlinks:
Excel Fun – Mosaic Chart
GUESS what's HIDDEN in Excel? (Cool Trick) Who says Excel can’t be fun? We will show how you can bring some fun to your next meeting or lecture using only Excel and some creative uses of Excel features. We want to play