Intermediate Microsoft Excel Tips & How To's 2024 • Page 5 of 10 • Excel Semi Pro

Fixing the F4 Button in Excel for Mac

May 3, 2018January 5, 2011

The F4 key in Excel for Windows is normally a shortcut key to Repeat the last command. In Excel for Mac the F4 key is assigned to the Paste command, which is driving me crazy so I decided to do something about it. Default Excel F4 Keyboard Assignment in Excel for Mac There are four …

The TRIM Function in Excel and VBA

May 16, 2018December 29, 2010

Excel’s TRIM Function is a great way to remove extra spaces before, after, and within text in a spreadsheet. However, if you think the identically named VBA function does the same thing you’d be sadly mistaken, as I was once upon a time. Here’s a normal sentence. Here’s a sentence with extra spaces – two …

VLOOKUP Function in Excel: The Essential Guide

January 23, 2024December 20, 2010

Introduction VLOOKUP, standing for ‘Vertical Lookup,’ is a powerhouse in Microsoft Excel’s suite of functions. At its core, VLOOKUP is designed to search for specific data located in a column and return a value from a different column in the same row. This functionality is paramount for data analysis, allowing users to efficiently sift through …

VBA Help System Lacking in Excel 2011

December 14, 2013December 14, 2010

Since never using the VBA Editor in Excel 2011 for Mac was a slight embarrassment, I thought to give it a whirl with a half-written function that was started in Excel 2010. I quickly found out the Editor’s windows have more of a free-floating style, but the programming looked to be quite the same. Until …

Excel ISNUMBER or IsNumeric Function

May 3, 2018December 13, 2010

I don’t like it when Excel worksheet functions are different from their VBA counterparts. Makes for some aggravation. For example, I have a user generated data range that’s supposed to be made up of either numbers or empty cells. However, Excel users sometimes bump their keyboards inadvertently (when you hit the space bar) and things …

Converting Pace in Minutes per Mile to MPH and Back Again in Excel

January 8, 2024November 24, 2010

Excel is a great tool for figuring stuff out, like conversions that aren’t easy to do in your head. Here I’m converting minutes per mile to MPH and then reversing the process, converting MPH to minutes per mile, to create a conversion chart.

3 Proven Formulas to Calculate Letter Grades in Excel

January 8, 2024November 20, 2010

In the educational landscape, accurately calculating and managing student grades is a task of paramount importance. It not only reflects a student’s performance but also guides future teaching strategies. This article is designed to guide educators and academic professionals through the process of efficiently calculating student grades in Excel.