Month: September 2022

Can Excel Translate Languages – 2510

Posted on by Annie D

Can Excel translate languages?
Part 1:
There is a built-in Translation tool on the Review tab in Excel. It shows the answers in a task pane, but it does a bad job of getting those answers back to the Excel grid.

Five new books were published this summer. Check them out at: https://www.mrexcel.com/products/

Part 2: You can use a small bit of Power Query code from Smozgur at MrExcel to solve the problem. Get that code from: https://www.mrexcel.com/board/excel-articles/using-power-query-in-excel-to-translate-data-using-the-google-translation-api.33/

Table of Contents
(0:00) Can Excel translate languages
(0:24) Translation on Review tab
(1:15) Paste back to Excel fails
(1:47) Five new books published
(3:00) Translating Continue reading “Can Excel Translate Languages – 2510” →

Calculating Sales Financial Year To Date In Power BI With DAX [2022 Update]

Posted on by Annie D

Sam demonstrates how to get financial year to date calculations in Power BI with DAX. A simple formula that can produce great insight fast.

***** Video Details *****
00:46 Creating Total Sales Table
02:00 Calculating Sales Year To Date
03:20 Changing Calculation To Sales Financial Year To Date
04:36 Creating A Visualisation For The Existing Calculation

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE – Power BI Resources – http://www.enterprisedna.co/power-bi-resources
FREE – 60 Page DAX Reference Guide Download Continue reading “Calculating Sales Financial Year To Date In Power BI With DAX [2022 Update]” →

Date & Time Formulas & Functions in Excel Worksheet and Power Query – 365 MECS 05

Posted on by Annie D

Download Excel file: https://excelisfun.net/files/05-M365ExcelClass.xlsx
Download pdf notes: https://excelisfun.net/files/05-M365ExcelClass.pdf
Course taught by Excel MVP and Highline College Professor, Mike Girvin.
Topics in video:
1. (00:00) Introduction
2. (01:12) Fundamentals of how Date Values work in Excel, Power Query and the Data Model
3. (04:08) How Date Number Formatting Works
4. (05:38) Date Formulas to calculate the difference between two dates
5. (08:08) Count Workdays. NETWORKDAY.INTL function
6. (10:15) Add or subtract days to get a future date. WORKDAY.INTL function
7. (12:48) Month Date calculations such as determining date by adding or subtracting months with EDATE function or determining end of month by using EOMONTH Continue reading “Date & Time Formulas & Functions in Excel Worksheet and Power Query – 365 MECS 05” →

🔴 Power BI tips from the Pros – LIVE (Sept 10, 2022) (Member Chat 2nd Half)

Posted on by Annie D

Join us live as we answer your questions about Power BI!

💥 30 minutes: Open Q&A (Public)
💥 Then… Members Only Chat (Public can watch & Super Chat for Questions)

📢 RULES FOR Q&A: 📢

👉 Put a “Q:” in front of your comment to help us identify questions!
👉 Super chats take priority
👉 Do NOT re-post your questions! We’ll get to as many questions as we can.
👉 If you SPAM your question, you will be put in timeout

📢 Become a member: https://guyinacu.be/membership

*******************

Want to take your Power BI skills to the next level? We have training courses available to help you Continue reading “🔴 Power BI tips from the Pros – LIVE (Sept 10, 2022) (Member Chat 2nd Half)” →

Enterprise DNA On-Demand – Our New World Class Empowerment Platform, There’s Nothing Like It!

Posted on by Annie D

We are at an exciting juncture with Enterprise DNA.

We’ve evolved and extended the features of our learning platform so extensively that we’ve come to a point where we feel like we need to start repositioning our digital platform for the future. Create some separation between what we’ve offered in the past and what we want to be as an empowerment platform and partner moving into the future.

Our new platform that we’re calling Enterprise DNA On-demand is proving to be quite the game-changer, where you get to learn Power BI and the rest of the Power Platform on-demand. Watch as Sam gives a Continue reading “Enterprise DNA On-Demand – Our New World Class Empowerment Platform, There’s Nothing Like It!” →

Excel Sum Or Count By Color – 2508

Posted on by Annie D

Total the numbers in the red cells. Average the cells with green font. While I have previously shown how to do this with VBA, it is now possible to quickly do this using a new add-in called DOSE for Excel.

Use coupon code MrExcel25 to save 25% on DOSE. Shop at https://MRX.CL/getdose

Excel Mark Each Unique Value In A Different Color – 2508A

Posted on by Annie D

Automatically assign a cell color to each cell based on value. If there are ten unique values in a range, assign ten colors.

I had previously done this using VBA in an old video: “Assign A Unique Color Value”: Podcast #1718 from May 28, 2013.

In this video, I show how it is easier to use DOSE for Excel to color-code each name or value in a range.

Save 25% on DOSE for Excel using Coupon Code MrExcel25 at https://mrx.cl/getdose

Excel Count Words Characters Or Sheets – 2508B

Posted on by Annie D

How can you count words in Excel? Instead of copying the data to Word, use you can use the DOSE for Excel add-in. In this video, I show you how to:
Count words in a range.
Count characters in a range.
Count worksheets in a workbook.

Save 25% on DOSE for Excel using Coupon Code MrExcel25 at https://mrx.cl/getdose

Excel Date Picker & Active Cell Crosshairs – 2508C

Posted on by Annie D

Excel sorely needs a date picker. In a previous video, I showed you the add-in from Sam Rad that has a date picker. In this video, take a look at the Date Picker included with the DOSE for Excel add-in.
I also take a look at their reading view, which essentially draws crosshairs to help you find the active cell.
Save 25% on DOSE for Excel using Coupon Code MrExcel25 at https://mrx.cl/getdose

Excel Double Space Your Data By Adding Blank Rows – 2508D

Posted on by Annie D

Your manager asked you to double-space your data in Excel. In other words, he wants you to add a blank row between each row.

In a past video, I showed a Bob Umlas trick for double-spacing data.

Using the DOSE for Excel Add-In, you can double-space or triple space your data.

Save 25% on DOSE for Excel using Coupon Code MrExcel25 at https://mrx.cl/getdose

Excel Reverse Text in Excel – 2508E

Posted on by Annie D

Back in episode 2444, I had Tommy Tutone singing a crazy formula to reverse text in Excel. Today, a less musical way, but a much easier way.

Using the DOSE for Excel add-in, you can easily reverse text, making “ABCDEF” change to “FEDCBA”. However, Dose does even better, offering an option to take “Jenny Jenny I’ve Got Your Number” and changing it to “Number Your Got I’ve Jenny Jenny”.

Save 25% on DOSE for Excel using Coupon Code MrExcel25 at https://mrx.cl/getdose

Excel How to Add Checkboxes – 2508F

Posted on by Annie D

Sometimes in Excel, you need checkboxes. Many checkboxes.
If you are designing a form and need checkboxes, this video will help.
All the way back in video 1871, I showed one method for getting checkboxes in Excel.
Today, I show how you can do this quickly and easily with the DOSE for Excel add-in.

In a perfect world, those Checkboxes would be tied to a set of cells, so you could use formulas to reach which ones are checked.

Also in this video, how to convert text in cells to an option buttons – this allows people to choose exactly one option, but not Continue reading “Excel How to Add Checkboxes – 2508F” →