Month: April 2023

Remove Page Watermark From Excel – 2582

Posted on by Annie D

How to get rid of a watermark in Excel? There are three different types of watermarks that are common in Excel. This video discusses all three.
Table of Contents
(0:00) Remove Watermark from Excel
(0:12) Remove Page Watermark
(0:33) Removing Watermark from Header
(1:06) Visible Watermark that does not print

This video answers these common search terms:
excel how to get rid of watermarks
how do i remove a watermark in excel
how do you remove a watermark from excel?
how do you remove a watermark in excel
how do you remove watermark in excel
how to get rid of watermark excel
how to get rid of watermark in excel
how to get rid Continue reading “Remove Page Watermark From Excel – 2582” →

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 Duplicates – Mark or Remove – 5 Answers in 55 Seconds – #shorts

Posted on by Annie D

5 Excel topics in 55 seconds. In this video, I answer five common questions about duplicates in Excel. This video will address:
excel find duplicates without deleting
can excel find duplicates
excel duplicates find
can i find duplicates in excel
excel remove duplicates without losing data
excel find duplicates in a list
can excel highlight duplicates
excel duplicates highlight
can excel look for duplicates
can excel pick up duplicates
excel recognize duplicates
how to see if duplicates in excel
how to see duplicates in excel column
excel check for duplicates in a list
excel duplicate check
excel check if duplicates in range
excel for duplicates
excel duplicates in one column
excel duplicates color
excel and duplicates
excel duplicates conditional formatting
excel duplicate Continue reading “Excel Duplicates – Mark or Remove – 5 Answers in 55 Seconds – #shorts” →

How to Get the Sum At the Top of Excel #shorts

Posted on by Annie D

How to get the sum at the top of Excel?
This short video shows two methods:
Add the sum at the bottom and then Cut using Ctrl+X and paste at the top.
Or, start at the top, click AutoSum, and then select the range of numbers with the mouse.

How To Get Sum At Top Of Excel
How To Sum At The Top In Excel

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

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.

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.

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

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” →

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