Microsoft Office
The Most Used Microsoft Outlook Shortcuts – Download
If like me, you seem to spend your day in Microsoft Outlook, then we have something that may make your life a little easier. Here at Simon Sez IT, we love keyboard shortcuts in Microsoft Office applications. We especially love them in the tools we spend A LOT of time in, like Outlook. Microsoft, very…
The Most Used Microsoft Teams Shortcuts – Download
If you are new to Microsoft Teams you’ll be relieved to hear that Microsoft made their collaboration tool even more efficient to use by making a load of keyboard shortcuts available. Microsoft, very kindly put together a list of the most used Microsoft Teams shortcuts, and we’ve turned them into a helpful infographic that you…
The Most Used Powerpoint Shortcuts – Download
Here at Simon Sez IT, we love keyboard shortcuts in Microsoft Office applications. We especially love them in Microsoft PowerPoint! Microsoft, very kindly put together a list of the most used Microsoft Powerpoint shortcuts, and we’ve turned them into a helpful infographic that you can download/print/share with that colleague that needs a bit of Powerpoint…
Excel Mac – Free Introductory Course
Follow along with this Excel Mac tutorial and download the practice exercise files here. Microsoft Excel for Mac is getting better. Microsoft has finally added more of the functionality available to PC users. If you’re using Excel for basic to intermediate spreadsheet work, then they pretty much offer a similar experience in terms of functionality. HOWEVER, While you…
Designing Better Spreadsheets in Excel – Excel Tips & Tricks
In this 1-hour class, we look at several excellent Excel tips and tricks to help you design your spreadsheets in the right way. Good spreadsheet design is essential if your Excel workbooks are going to be used by multiple people. Once again, this class was presented by the excellent Deborah Ashby for Simon Sez IT…
Using Templates in Microsoft Access 2019
Microsoft Access is still one of the simplest to use database tools. One thing that makes MS Access such a useful tool for the novice user is templates. MS Access templates give you a head start when creating a new database, and there are lots of different options to choose from. To start using a…
Introduction to Power Pivot & Power Query in Excel
In this Power Pivot and Power Query tutorial from Simon Sez IT. Excel expert, Deb Ashby teaches you how to get started with the Power Pivot and Power Query tools in Excel In this Advanced Microsoft Excel tutorial, she looks at the following: PivotTables – a quick reminder 😉 Importing data into Excel from multiple…
Free PowerPoint Introductory Course – 2019
There’s a difference between a presentation and an effective presentation. Being able to wield Microsoft PowerPoint to have the most significant impact is often the difference between the two. In this free PowerPoint Introductory Course, we help you turn your boring slides into compelling stories. It all starts with knowing the basics of PowerPoint –…
How to Create Amazing Presentations in Microsoft PowerPoint
In this recorded webinar, PowerPoint guru, Deborah Ashby shows you some advanced PowerPoint techniques that will impress your colleagues and clients alike. Say goodbye to boring PowerPoint presentations with this 1-hour recorded live-class. This was another free live class from Simon Sez IT. Click here to see the full PowerPoint 2019 course. To access the…
VLOOKUP for Dummies (or newbies)
VLOOKUP is a powerful and handy excel function. At the same time, it is one of the least understood functions and can often break. Today we’ll try to explain VLOOKUP for newbies in the simplest possible way. We’ll also provide formula examples of the function’s most typical usage. If you want to skip the text…
Logical Functions in Excel (IF, IFS, AND, OR, COUNTIF, SUMIF)
In this Excel tutorial, we take a look at Logical Functions in Excel. That’s functions such as IF, IFS, COUNTIF and SUMIF. This is an Excel tutorial for beginners or those who need to brush up on their Excel. This was taken from a live, recorded session. You can download the Excel files that Debs…
The Most Used Excel Shortcuts
If something can be done in a more efficient way, then I do it. That’s why I love keyboard shortcuts so much and especially in Microsoft Excel. Microsoft put together a list of the most used Excel shortcuts for PC and Mac users and we’ve turned them into a nice looking cheat sheet that you…
