Set the Default Chart in Excel
Setting the default chart will help you in a lot of different ways in Excel. For one it helps you from having to constantly change settings if you use the F11 key shortcut. It’s easy to set the default. See … Continued
Using Auto Calculate In Excel (all versions)
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
Know Your Cursors in Excel
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
Minimize or Collapse the Ribbon in Microsoft Office
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
Excel Remove Duplicates, Add a SumIF and Create a Chart
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
30 Days of Free Training via LinkedIn Learning
We are so proud to share 30 days of free training through LinkedIn Learning. Start the 30 days just by clicking here.
Tips for the Email Hoarder
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
Import Macros In Access
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
Resize Tiles for Promoted Links List SharePoint Online
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
Calculate In SharePoint Online List
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
Create a Promoted Tiles List for SharePoint Online
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
Insights: Robin Hunt
Robin Hunt from Career Clinic: IT Insights by LinkedIn Learning Instructors
Join Types and what they impact
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
It’s like asking me to have a toolbox with no hammer – Expanded
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
Learning New Data In Excel Spreadsheets
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