Excel Digest: September 12th

Sponsored by Elevate Excel?

Happy Tuesday!?

Today I'm sharing some of?my favorite Excel-related content from the last week. Have any questions or Excel discoveries to share? Share them in the comments section below our post.? Have a great week! -?Jon Acampora (Microsoft MVP)

But first...

Struggling with which Excel tools to use when?

Build your own blueprint?and boost your skills in our Excel Blueprint Training Session!

Date: Daily this week?(including weekends!)

Time: AM/PM slots available

Location: Online

Learn:

• Data analysis tools like Power Query, Power Pivot, Power BI, pivot tables, macros & more.?
• What these tools do
• How they can save you tons of time by automating processes

Don't miss out—secure your spot now!

Register:?excelcampus.com/blueprint

SOCIAL Here's what you may have missed across our channels:?

• Excel Bad Habit #3 In this quick Instagram Reel, we're diving into a common task: copying worksheets in Excel.
• ?Build a Gauge Chart (YouTube link) Enjoy bite-sized Excel knowledge with accompanying articles.

ELEVATE A collaborative effort from our Elevate Excel community :

A user asked...

• I’ve been using a spreadsheet to create dashboards for management that display metrics for our timesheet entries. I decided that I would try to move all that information to PBI.Every Monday, I delete all the rows from the spreadsheet for the current month. I then download all the data for the current month from the timesheet application.?Will the refresh function in PBI compare and only add the new data to the table, or will I get dupe values for the current month’s entries already in the table?

The community answered...

• It depends on what your source (data) is and if you are making changes to that source. For example, like with Power Query, if you are deleting the old data from the source, and then refreshing the connection to that source in Power BI, the deleted data from that source will no longer appear in Power BI. If you are concerned about what is going to happen on the next load, it would be good to test it out first. Consider changing a few of the rows of the current source data and add another two rows of fake data – changes that you can easily track and change back should something not go as desired. Refresh in Power BI, and check the output to see what changed (and what did not change) compared to what you expected.

Already a member? Join the conversation!?

WHAT TO LEARN THIS WEEK:? Trending Excel content on the blog:?

• 3 Ways to Fill Down Blank Cells in Excel
• 12 Keyboard Shortcuts for Windows File Explorer

• How to Change Date Formatting for Grouped Pivot Table Fields

Thanks again and have a great week!

Jon Acampora

Microsoft MVP?