I believe that there is a little command that most people could use all the time but often overlook. Auto calculate in Excel. Anytime you select a group of cells if you look at the bottom right of your screen … Continued
I have been teaching Excel for close to two decades. I know one thing for sure – every time I teach these techniques people learn something new. We are creatures of habit so we often do things the way we … Continued
I have taught this tip in Excel classes since the advent of the Ribbon in Microsoft Office 2007. Screen space is a big deal when you are working with data or really anything. I know I want to be able … Continued
Did you like learning these techniques in Excel? It was full of shortcuts not to mention learning about removing duplicates, building a SUMIF, and creating a chart. If you didn’t watch it you missed how to: Create a copy of … Continued
We are so proud to share 30 days of free training through LinkedIn Learning. Start the 30 days just by clicking here.
We are dealing with large amounts of email. If you asked me to analyze a person workday that’s the first place I am looking – what’s the volume of email. What would your email data say about you? It can … Continued
If you need to import Excel files into a Database, this can show you how to automate the process. Building an import-export macro from Building Solutions Using Excel and Access 2016 Together by Robin Hunt
We all have those moments where we need to do something on our design for SharePoint Online sites. I love promoted tiles because they give us a quick easy way to navigate through the wonderful things we build in our … Continued
If you have built lists of relevant data in SharePoint that need calculations – not to worry – you can do calculations in SharePoint Online lists. Watch this quick video to get some insight to get started. It is easy … Continued
Tiles help people navigate through all the great things you created for your users. Creating a Promoted Apps list will help. Watch here for a quick demo. Building Promoted Links from SharePoint: Integrating with Access by Robin Hunt
Robin Hunt from Career Clinic: IT Insights by LinkedIn Learning Instructors
Learning data can be fun if you are doing it while your not under pressure to perform. It’s key to remember that data is just data. If you can handle one set; you can handle any set. One of my … Continued
There are few sections of this course that I just wish the whole world would watch. I think people don’t consider Microsoft Access enough. People with Database in their job titles like to use higher level technologies, and Excel users … Continued
We all get new data in Excel spreadsheets and new reporting requests all the time – if you are data person this happens all the time. I thought I would share a couple of techniques on how I start learning … Continued
We hope you have an amazing holiday and that we can see you in the New Year! Ask Robin Hunt what her favorite Christmas movie clip of any season is? She’ll tell you this one: Thanks to the … Continued