Microsoft Excel

Excel Navigation tips

This #TipTuesday post is tips for Excel users around navigating within the application.

Excel's hidden gem - IFERROR

This #TipTuesday post explains the fantastic formula IFERROR and how it can help return meaningful data to users.

Excel VLOOKUP - numbers as text & vice versa

This #TipTuesday is about looking up numbers in text and text in numbers when the data types are not matching.

Excel tip - "corner" copy

This #TipTuesday post is about one of my favourite shortcuts in Excel: "Corner Copy".

Excel Paste Special - Operations

This #TipTuesday post is how to Paste Special with a multiply or divide operation to quickly change the sign on a set of data.

Excel tip - copy & paste unique values

This #TipTuesday is for Excel users, and it is a tip about how to copy and paste only the unique values from a list.

Flash Fill in Excel

This #TipTuesday is about the Flash Fill feature in Microsoft Excel, and how to use it.

Upload Pending issue in Excel with OneDrive

This post is about the annoying "upload pending" issue in Excel with OneDrive.

Cool Excel Tip - dates without holidays included

This is an Excel tip about the WORKDAY function which has an attribute for comparing dates against a holiday list to increment dates based on what defines a business/work day in a given organization.
You've successfully subscribed to JenKuntz.ca
Great! Next, complete checkout to get full access to all premium content.
Welcome back! You've successfully signed in.
Unable to sign you in. Please try again.
Success! Your account is fully activated, you now have access to all content.
Error! Stripe checkout failed.
Success! Your billing info is updated.
Error! Billing info update failed.