Microsoft Excel Tips & How To's 2024 - Excel Semi Pro • Page 6 of 24 • How to Use Microsoft Excel. Learn Online.

How to add cells in Excel (screen shots of cell data added up via the SUM formula).

How to Add Cells in Excel to Sum Up Totals Automatically

April 30, 2023March 30, 2018

Excel’s great for displaying data and even better at crunching numbers. Here’s how to add cells in Excel to sum up totals automatically… Even when you change the numbers. A great feature that Excel has to offer is its use of formulas. Since Excel is often used to organize numerical data for a variety of …

How to merge cells in excel: Screen shot of an Excel spreadsheet with cells being merged.

How to Merge Cells in Excel (and Split Them) for Better Layouts

April 30, 2023March 28, 2018

Knowing how to merge cells in Excel is a crucial skill. Although it may not seem like necessary information, it can be more useful than you might think. Get the most out of your Excel user experience by reading on and learning more about merging and splitting your document’s cells. Why Split or Merge Cells? …

How to Use the SUMIF and SUMIFS Functions in Excel

April 30, 2023March 27, 2018

SUMIF and SUMIFS help Excel users to save time and frustration by making it easy to glean valuable information from complex datasets. You can total and analyze everything from grade values to quarterly earnings without giving yourself a massive headache. In this tutorial, we’re going to cover: The difference between SUMIF and SUMIFS functions. How to use SUMIF …

Excel for iPad – Paste as Values

April 30, 2023June 16, 2014

Being a long standing Excel user and an avid Apple products consumer, I downloaded the new Microsoft Excel iPad app in April 2014 and quickly found out that you can’t do anything of substance until you pay a subscription fee. After looking at the available options I decided to purchase the Office 365 Personal yearly …

Where is Control+Home for Excel on a Mac

April 30, 2023April 28, 2013

I wrote a post stating that I could not find the Windows Ctrl+Home keyboard shortcut equivalent on a Mac. Well I’m here to tell you that I found the keyboard shortcut combination that does the same thing on a Mac. The Excel Gods are with me. Hallelujah! Finding My Way Home The key to finding …

Excel Fractional Part: Extracting Integers and Fractions in Excel

January 8, 2024February 14, 2013

Sometimes you need to extract the integer or decimal part of a number. Sometimes the fractional part. Sometimes both. Excel makes it easy to get the integer and somewhat harder to get the fraction. If you just want the answer, skip to the technical details.

Extract Time from datetime with the MOD Function in Excel

January 18, 2024November 1, 2012

I had a reader comment on my last post about how to extract time from a date-time number using the MOD function. Simple really. The syntax is MOD(number,divisor). The MOD function returns the remainder after number is divided by divisor. A simple example is MOD(5,2), which equals one (1). It works like this: five (5) …

How to Extract Time from DateTime values in Excel

January 18, 2024October 9, 2012

Understanding the Datetime Handling in Excel In Excel, date-time values are a blend of date and time, stored as serial numbers. Excel represents dates as sequential serial numbers where each number corresponds to a specific date, starting from January 1, 1900. Time is represented as fractional parts of a day. For instance, 0.5 represents noon, …

Extract Date from DateTime Number in Excel

January 18, 2024September 15, 2012

I recently saw a spreadsheet with the following function =LEFT(A2,8) where cell A2 was equal to 08/06/12 12:23 PM. The user was trying to extract the Date from the Date-Time value. The problem for me was that the LEFT function returns a “text” value. Excel is good at recognizing text values that look like dates, …

Latest Excel Tips and Guides