Title:
Excel Life Hacks | Tips and Tricks for Excel Users to Save You Time!
Description:
Life Hacks are designed for the end user to save time and be more efficient. Join me for this session to learn better ways to get the job done and show off your new Excel skills back at the office! We will cover everything from formulas to charts – and we will have a blast doing it too! Join me for this fast and fun session to cover over FORTY tips and tricks for 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!
The video below may take a moment to load – give it just a minute please – for some reason, wordpress doesn’t play well with ‘Gifs’. Comment below and let me know if you like this tip!
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
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
One of my sessions, sponsored by the GP User Group, will focus on Power Query – the background engine for Power BI!
Track: BI/Reporting
Wednesday, October 16, 2019 | 12:45 PM – 1:45 PM
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
Please click the link below to download the Excel File that I used for my Excel Life Hacks Presentation.
Sorry about the multiple steps – it’s a macro file so automating the distribution took a little ‘work around’ 🙂
Continue reading “Excel Life Hacks – Sample File”