Tag: Excel

Automatically Highlight Active Row in Excel

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!

Continue reading “Automatically Highlight Active Row in Excel”

Come See Me at Summit 2019: Considering Business Central

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!

Track: Extracurriculars

Friday, October 18, 2019 | 1:15 PM – 2:15 PM

Should I be considering Dynamics 365 Business Central?

Continue reading “Come See Me at Summit 2019: Considering Business Central”

Come See Me at Summit 2019: Business Central Life Hacks

About My Session: Business Central (BCUG)

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!

Track: Get Started

Friday, October 18, 2019 | 2:30 PM – 3:30 PM

Business Central Life Hacks

Continue reading “Come See Me at Summit 2019: Business Central Life Hacks”

Come See Me at Summit 2019: Excel Shootout

About My Session: Excel Shootout (GPUG)

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!

Track: Extracurriculars

Thursday, October 17, 2019 | 1:30 PM – 2:30 PM

Excel Shootout!

Continue reading “Come See Me at Summit 2019: Excel Shootout”

Come See Me at Summit 2019: Excel Life Hacks

About My Session: Excel Life Hacks (GPUG)

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!

Track: Extracurriculars

Thursday, October 17, 2019 | 8:00 AM – 9:00 AM

Excel Life Hacks: Tips & Tricks to Save you Time!

Continue reading “Come See Me at Summit 2019: Excel Life Hacks”

Come See Me at Summit 2019: Excel Life Hacks #BCUG

About My Session: Excel Life Hacks (BCUG)

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!

Track: BC/NAV

Friday, October 18, 2019 | 9:45 AM – 10:45 AM

Excel Life Hacks – Tips and Tricks for Excel Users

Continue reading “Come See Me at Summit 2019: Excel Life Hacks #BCUG”

Come Join Me at Business Applications Summit 2019!

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!

Continue reading “Come Join Me at Business Applications Summit 2019!”

Join Me for a Webinar: Power Query in Power BI

Join me for a free webinar hosted by PBIUserGroup (PBIUserGroup.com) on April 16th, 2019 @ 12:00pm eastern!

Power Query in Power BI

Description:

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.

Continue reading “Join Me for a Webinar: Power Query in Power BI”

Jet Reports – Connecting the Data Source

Now that Jet Reports is installed, it’s time to connect to the Dynamics GP Data Source.
GP Data can be both on site (on premises) or in the cloud (Remote Data Service).
Below is a quick guide on how to connect to your data source!
Continue reading “Jet Reports – Connecting the Data Source”

Jet Reports – GP Update Utility

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.

Continue reading “Jet Reports – GP Update Utility”