Microsoft Office Articles on Tips and Tricks
Articles written by Analir Pisani
Covering a wide range of topics from the Microsoft Office Suite of Applications.
The content for the articles is driven by commonly asked questions by students.
Microsoft Office Suite of Applications
Excel, PowerPoint, Outlook, Word
ANALIR PISANI, DIRECTOR
Passionate about keeping the learning going. Analir is a Certified instructor with over 27 years experience in delivering Microsoft Office Courses to a wide range of audiences.
Delivers training in Excel, Word, PowerPoint, Outlook, OneNote, OneDrive, Teams and Microsoft Office 365 Suite of Applications.
Connect with Analir Pisani on LinkedIn
Office 365 Explained
With Office 365 you will alway have the latest updates and best features at your disposal.
Face-To-Face or Virtual
Consider what’s your best method of learning. What situation do you feel most comfortable, clear headed and open to learning? Other factors are cost efficiency for the organization and reduce travel time for Virtual training sessions.
Google Chrome Features
Easiest way to create a Business Statice QR Code is to use Google Chrome.
Real-Time Automatic Captions Or Subtitles
A great way to be inclusive of people with diversity is to add captions. We have seen captions easily added in a YouTube video. What about in our PowerPoint presentations.
Convert Word Doc To PowerPoint
Preparation is the key. Use styles and add a command to your Quick Access Toolbar. How to make a Word Document and PowerPoint consistent making it easy to present from and it isn't that hard to do. This article will walk you through ways to share your PowerPoint presentations and work in harmony between Word a detailed large document to PowerPoint snippets of the facts.
Why Is Excel Intermediate So Popular?
Excel Intermediate is so popular, Why?
Merge Microsoft Excel Spreadsheets
Share your Microsoft Office Excel Spreadsheet using OneDrive. Link Data from other workbooks.
Jobs Requiring Excel Skills
Excel is for everyone. An employer is looking that you can create basic spreadsheets with formatting, basic formulas and functions like SUM, AVERAGE and COUNT. For the high-end skilled jobs you'll need complex function skills.
Have Microsoft Word Read Back To You
If you struggle with Reading, Microsoft Word can help with the features of Read Aloud and the Immersive Reader.
What Every High School Student Needs To Know Using The Internet?
Show your Bookmark Bar on Google add links and create folders. In Gmail keep in mind 5 features - Starred, Mark as important, Creating labels, Mark as Read & Unread.
Design Effective PowerPoint Presentations
Design ideas feature makes presentation design easy. Reduce bullet points by converting text to SmartArt and where possible you your company corporate colour scheme. Transitions and Animations are great but don't over use them.
Simple Excel Budgeting Tool
Great Simple Excel Budgeting tool calculating Income minus Expenses with a Pivot Table to group hours worked by date.
Managing Large PowerPoint Presentations
Manage Large PowerPoint slides using Sections and importing slides. Use Outline view to re arrange PowerPoint slides.
Advanced Excel Functions
Need to cross check or copy, paste data but keep it linked. Lessons in Excel available in Sydney. Try VLOOKUP or XLOOKUP Function in Excel.
Basic Excel Formulas and Functions You need To Know
Functions are different to Formulas. Formulas use operations like + - * / where as Functions follow a structure. They both start with = A Functions has = Function Name ( in that order. There are over 300 Functions in Microsoft Excel.
Create Basic Formulas In Excel
All Formulas and Functions begin with =. Operators are + - * / and they need to be used in a specific order.
9 Excel Formatting Techniques That Will Save You Time
Formatting Excel spreadsheets made easy by using the correct tools. Most useful tools are Conditional Formatting and Format as Table features.
6 Valuable Excel Pivot Tables Ideas
Use Dynamic data to create your Excel Pivot Tables. What's beyond Pivot Tables.
9 Tools To Manipulating Data In Excel
Don't under estimate the power of basic formatting. Techniques for pulling a part data. You have used Text To Column but have you tried Flash Fill. Changing Settings to force data to perform differently.
Grow With Google Seminar
Grow With Google Free seminar, well presented and informative.
Working With Messages In Outlook
Learn to work efficiently and productively using Outlook features like flagging, conversations, what to do when Outlook goes wrong.
Time Management Techniques In Outlook
Learn great time saving features using Microsoft Outlook. Set up signatures and tame your inbox.
