Microsoft Office
How to Use Microsoft PowerPoint Animations and Transitions for Creative Presentations
PowerPoint Animations are special visual effects added to a text or an object in Microsoft PowerPoint. You have to click the object and select the animations tab. They bring your text or object to life. A transition is a visual effect that occurs when you move from one slide to the next in PowerPoint. A…
Getting Started with Power Pivot: Advanced Excel
Power Pivot is a tool in Excel that enables us to create data models and perform more complex operations than the standard Pivot Tables allow. You may have seen references to the data model in Excel before when creating PivotTables – this is Power Pivot. It is also known as the data model. This article…
Advanced Word Tutorial: Tips and Tricks in MS Word – Recorded Webinar
In this 1-hour class, we look at some of the Advanced features of Microsoft Word. Microsoft Word is more powerful than you may think. In this Advanced Microsoft Word Tutorial, we take a look at some of the features that Word has that makes created awesome and professional-looking documents simple. Once again, this advanced Word…
How to Create a Contents Page in Word
This Contents Page in Word tutorial is suitable for users of Word 2010, 2013, 2016, 2019, and Word for Microsoft 365. Objective Create a Table of Contents for a Word document and update it to add new entries. Table of Contents Explained A Table of Contents page makes it easier for your readers to navigate and work with long documents. It gives documents a professional look and…
What-If Analysis in Excel – Recorded Excel Live Class
In this 1-hour class, we look at the awesome power of What-If Analysis in Excel. What If Analysis in Excel allows you to test out different scenarios without complex formulas. In this tutorial we cover Goal Seek, Scenario Manager, Data Tables, and Solver. Once again, this class was hosted by the excellent Deborah Ashby. In…
How to Print Envelopes in Microsoft Word
This How to Print Envelopes in Microsoft Word tutorial is Suitable for users of Word 2013, 2016, 2019, and Word for Microsoft 365. Objective Use the Mailings tab in Word to create and print a single envelope or multiple envelopes stored in one document. Printing Envelopes in Microsoft Word Explained The number of letters created in Word annually is phenomenal, and it stands to reason that for…
Pivot Charts in Excel Tutorial
This Pivot Charts in Excel tutorial is Suitable for users of Excel 2010/2013/2016/2019 and Microsoft 365. Objective Create an interactive Pivot Chart in Excel from a raw dataset and customize it to suit your needs. What is a Pivot Chart? Whenever I hear the word ‘Pivot’ I immediately think about that scene in ‘Friends’. Ross, Rachel and…
The Most Used Access Shortcuts – Download
If something can be done in a more efficient way, then I do it. That’s why here at Simon Sez IT, we love keyboard shortcuts in Microsoft Office applications. We especially love them in sophisticated tools like Microsoft Access. Microsoft, very kindly put together a list of the most used Microsoft Access shortcuts, and we’ve…
How to Print Labels in Word (Text + Video Tutorial)
This How to Print Labels in Word tutorial is suitable for users of Word 2013, 2016, 2019, and Word for Microsoft 365. Objective Use the Mailings tab in Word to create and print a set of address labels. Printing Labels Explained In a world where packages through the mail are becoming increasingly popular, you may find yourself having to ship items more than usual….
Microsoft Teams Tutorial – Getting Started.
This Microsoft Teams tutorial is suitable for users of Teams in Microsoft 365 and Teams Desktop App. Objective In this Microsoft Teams tutorial, we help you get started by showing you how to use the Teams dashboard, and how to create your first team and add members. Microsoft Teams Explained With a plethora of collaboration tools available…
How to Mail Merge in Word
This Mail Merge in Word tutorial is suitable for users of Word 2010, 2013, 2016, 2019, and Word for Microsoft 365. Objective Perform a Mail Merge in Word to generate letters and labels in bulk using contacts stored in an Excel spreadsheet. Mail Merge Explained Do you need to generate lots of letters, envelopes, labels, or even emails? Let the Mail Merge…
The Most Used Microsoft Word Shortcuts – Download
If the same thing can be done quicker, then I do it. That’s why here at Simon Sez IT, we love keyboard shortcuts in Microsoft Office applications. We especially love them in the tools we use every day like Microsoft Word. Microsoft put together a list of the most used Microsoft Word shortcuts, and we’ve…
