I use Excel… a LOT, and for a very long time! With that comes the inevitable… my eyes aren’t as young as they used to be… plus, we tend to have a TON of data in our Excel file, sometimes making it harder to know which data is on the row that I am looking at.
I know, you can use themes, or highlight the row manually, but I want something dynamic. I want to highlight the active row (the row where my cursor is)… and I am greedy, I want it to change every time I change rows.
I personally think this should be a feature built into Excel, but I cannot find it anywhere – if you know of a different way, please post a comment below.
I’ve put together a few steps to automatically highlight my active row. Read on to see these steps and maybe put it to use for you!
About My Session: Considering Business Central (GPUG)
One of my sessions, sponsored by the GP User Group, will be an interactive panel discussion about Business Central. What is it, what does it mean to GP customers, and much more! Windi Epperson, Rod O’Connor, Tanya Henderson and myself make up this panel so come join us for some open and honest discussions!
Friday, October 18, 2019 | 1:15 PM – 2:15 PM
Should I be considering Dynamics 365 Business Central?
One of my sessions, sponsored by the BC User Group, will focus on Dynamics Business Central Tips and Tricks – Life Hacks. We will cover overlooked functions, cool ways of handling certain situations, new functionality and MUCH MORE!
One of my sessions, sponsored by the GP User Group, will be a fun and interactive competition on Excel functionality! My friends, Belinda Allen and Mark Polino, and I compete to show off our best Excel skills!
One of my sessions, sponsored by the GP User Group, will focus on an Excel Tips and Tricks – Life Hacks. We will cover overlooked functions, cool ways of handling certain situations, new functionality and MUCH MORE!
One of my sessions, sponsored by the BC User Group, will focus on an Excel Tips and Tricks – Life Hacks. We will cover overlooked functions, cool ways of handling certain situations, new functionality and MUCH MORE!
Friday, October 18, 2019 | 9:45 AM – 10:45 AM
Excel Life Hacks – Tips and Tricks for Excel Users
Microsoft’s Business Applications Summit will be held at the Georgia World Congress Center in Atlanta GA. The conference will run from June 10th through June 11th, 2019.
This event is a Microsoft hosted event and is designed to provide information on what’s new and next in the Dynamics community. The event has some pre conference training available as well!
I’m very excited to announce that I will be speaking at this event for 3 sessions! There is so much content covering Dynamics 365, Excel, PowerApps and much more! Read on to learn more about my sessions and what the event has to offer!
Join me for a free webinar hosted by PBIUserGroup (PBIUserGroup.com) on April 16th, 2019 @ 12:00pm eastern!
Power Query in Power BI
Data in the real world is messy, never available in the exact form that users need for their analysis or reports. Data Analysts need to spend a significant amount of their time working on data preparation, before the data is ready to be visualized.
Jet Reports for Dynamics GP comes with a very good selection of sample reports. These sample reports are an excellent resource – not only to see what Jet Basics does, but how the reports are built!
Many of those sample reports rely on something called ‘Friendly Names’.
Friendly names are names that properly describe the content of that SQL Table, or SQL View… they are, well, friendly 🙂 Rather than your typical naming convention for GP – like GL20000.
Not only are the sample reports built using these friendly names, but it makes it much easier to use.
Also Jet Reports comes with several useful SQL Views… both the friendly names and SQL Views get installed using the GP Update Utility.
Below is a quick guide on how to use the GP Update Utility – PRO TIP! It’s ok to add this later but I 100% recommend doing this before getting started.