Category: Business

Why Excel SUM is Zero #Shorts

Posted on by Annie D

Why Excel SUM is zero.
Why Excel Sum function not working.
Why Excel SUM returns 0.
Why Excel Sum is wrong.
Why Excel Sum shows 0.
Why Excel Not Showing Sum.
Why Excel Sum Formula Not working.

Do you have a column of numbers that won’t sum in Excel? It is most likely that the numbers have been stored as text. Here are two quick ways to convert those text numbers and the numbers will then sum.

One frustrating behavior when this happens: =SUM(A2:A4) is zero, but =A2+A3+A4 calculates correctly. That is because the plus sign coerces a number out of the text, but the SUM function is Continue reading “Why Excel SUM is Zero #Shorts” →

Excel Insert Blank Row After Every Two Data Rows #Shorts

Posted on by Annie D

LC has 4000 rows of Excel data. After every two rows, he wants to insert a blank row. How can he quickly insert 2000 blank rows in the data? My solution today involves a formula to create alternating cells with text and numbers. Then Home, Find & Select, Go To Special. Select all Formula cells that result in Text. This selects every other row. You can then Insert Sheet Rows and you are done in less than 60 seconds.

Excel FILTER() With Two Conditions #shorts

Posted on by Annie D

Keith wants to use the Excel FILTER function to get all names where two conditions are true: Status is A and the Project does not start with 22-05. This video shows how to combine 2 conditions in an Excel FILTER formula.

excel filter function
why excel filter not working
excel can you filter columns
excel can you filter with LEFT
excel can you filter to two conditions

How To Tune Up Your Power BI Data Model With The Best Practice Analyzer

Posted on by Annie D

Analyzing the performance of your Power BI data model is crucial to identify potential bottlenecks and optimize the model for faster data processing. It also helps to improve the user experience by reducing the query response time and increasing the overall efficiency of the Power BI reports.

How do you challenge yourself to determine if you’ve developed a good enough data model? The first thing that starts with Power BI is whether or not you built a good Star Schema. But even within the context of a Star Schema, there are better and worse ways to do things. In this video, Continue reading “How To Tune Up Your Power BI Data Model With The Best Practice Analyzer” →

Excel You CAN Change The Font Size In The Formula Bar – #shorts

Posted on by Annie D

Why is the text in the formula bar so small? If you are on a Zoom call or doing a presentation, it is impossible for the audience to see. There is an amazing trick for making the text in the Excel formula bar HUGE. Try this out.

Microsoft Excel Formula Bar Font Size

Favorite Excel Tip Double Click Fill Handle #shorts

Posted on by Annie D

Microsoft Excel Favorite Tip.
Today, October 17, 2022 is International Spreadsheet Day. Microsoft has asked a lot of creators to post their favorite Excel tips. Here is mine: Double-click the Fill Handle to copy a formula to the bottom of the data.
How to copy Excel formula to the bottom of the data set by double-clicking the Fill Handle.

Automatic Sequential Numbers Just Pop Up! SEQUENCE & IF functions. #Short Excel Magic Trick 06

Posted on by Annie D

Learn how to create sequential numbers that pop up when you type using the SEQUENCE and IF functions.
#excel #excelisfun #analytics #microsoftexcel #microsoftmvp, #short #shorts
#sequence #sequencefunction #automation #automatic #automaticnumbers #iffunction #ifformula #if #increment #excelmvp #excelformulas #excelfunctions #excelformulaforjobinterview #excelforbegginers #excelshorts #exceltutorial #exceltips #exceltipstricks #freeclass #freecourse #freeclasses #freeexcelcourse #freeexcel

Excel Add Watermark to Excel – 2581

Posted on by Annie D

How to add a watermark in Excel?

Table of Contents
(0:00) Start with a watermark image with white space above.
(0:39) Adding image to Excel header.
(1:25) Adjust Transparency.
(2:10) Using a picture as a Watermark.
(2:40) Creating a Confidential Stamp to Use in Watermark.
(4:29) Bending text in WordArt.

This video is created for these popular Search terms:
how to add image as watermark in excel
how to add watermark image in excel sheet
how to add picture watermark on excel file
how to add watermark picture in excel
how to make watermark background picture in excel
how to put watermark picture in excel
can you add a confidential watermark to excel
how to add Continue reading “Excel Add Watermark to Excel – 2581” →

Excel Too Many Fields In Pivot Table Field List To Move Around Easily #shorts

Posted on by Annie D

Colleen calls with a question today. She has a pivot table with too many fields in the Values area. She can’t easily resequence them. Is there a way to see more fields in the Pivot Table Fields pane?

Table of Contents
(0:00) Areas Section Only
(0:12) Undock & Resize Field List
(0:22) Drag line between Fields & Areas
(0:29) Re-dock pivot table fields pane
(0:39) Dragging field headings in pivot table
(0:50) Rearrange by typing