Microsoft Excel
After sorting in Excel, we will look at two great methods for separating blocks of data or showing a clean separator between our groups. Break between groups in Excel A group may be departments, states, countries, or cities. We will use the Subtotal command, and Page Breaks between Groups for
Microsoft Excel
Excel has dynamic array functions. Two of the dynamic array function are SORT and UNIQUE. I will combine SORT and UNIQUE and also combine them with COUNT and the COUNTA functions. This came from a user that asked how many unique zip codes were in a spreadsheet. **SORT and UNIQUE
Microsoft Excel
Excel allows you to pull data on a webpage into Excel. This is a great time-saving feature. Getting data from a webpage is done in Excel on the Data Tab using Get and Transform Data group, From Web command. **Excel - Data From Web** Get Started - Find a webpage
Microsoft Excel
Frequently we have data in one format but need to convert it to another. Today's example is I have a column on seconds for the length of videos. I want to show minutes and seconds with a colon in between the minutes and seconds. **Convert seconds to minutes
Microsoft Excel
Microsoft keeps rolling out awesome new features for M365 users. Many of the new features hit Excel in 2022. This video covers my top five favorite features in Excel from 2022. Navigation Pane - Top 5 of 2022 for Excel YouTube Video TOP 5 Excel Features Released in 2022 Chapters
Microsoft Excel
Filter in PivotTables only allows one filter by default. To filter by more than one field, you need to turn on Allow multiple filters per field. To turn on, Allow multiple filters per field. 1. Right-click on a column in the PivotTable 2. Click **PivotTable Options...** 3. Click the **Totals
Microsoft Excel
PivotTables are one of the best features in Excel. PivotTables allow you to summarize, analyze and chart complex data. There are 3 annoying things in PivotTables that users always ask me about. PivotTable Options - Autofit column widths on update One of them is after changing the width of a
Microsoft Excel
Combine the Geography Data type with a Chart Map. The Geography Data type is located on the Data tab, and Chart Map is on the Insert tab with the other chart types. Geography Data Type in Excel You can use the Geography data type with countries, states, and cities. There
Microsoft Excel
Have you ever copied from a website and tried to paste it into Excel? It isn't a pretty picture. Excel has a new keyboard shortcut coming out soon. Using CTRL + SHIFT + V will paste plain text. Paste with Ctrl + V Paste Values with CTRL + SHIFT + V The current
Microsoft Excel
Updated: November 1, 2022 For potential homeowners, one year makes a HUGE difference. In 2021, we saw some of the lowest mortgage rates in the last 30 years. In July 2021, the average rate on 30-Year Fixed-Rate Mortgages was 2.87% (source FreddieMac). Today, November 1, 2022, we are looking
Microsoft Excel
Excel has two new image-related features coming out. In this video, a preview of my teaching session at the ASAP (American Society of Administrative Professionals) Virtual Event in November, I walk you through these two new Excel functions. IMAGE Function in Excel The IMAGE Function inserts images into cells from
Microsoft Excel
The new Excel IMAGE function enables you to insert images into cells with a formula. This great function allows you to sort, filter, and rearrange images. Excel IMAGE function IMAGE Function syntax =IMAGE(source, [alt_text], [sizing], [height], [width]) IMAGE Function Arguments * [Required] source is the URL path of the