Four Trendy Ways to Improve on Microsoft Outlook tips

They will simply open their inbox, do what is required, and be done with quickly.


“Microsoft Outlook Tips, Tricks, and Productivity Tools” is the topic of a one-hour webinar that is being organized on February 5 by Compliance4All, a leading provider of professional training for all the regulatory compliance. Tom Fragale, a Microsoft Certified Trainer and a Microsoft Certified Expert in Excel, will be the speaker at this webinar.


Microsoft Outlook, the web-based webmail, contacts, tasks, and calendaring services suite, offers many benefits for office staff with its tasks, follow-ups, contacts, notes and calendar features. Yet, let us face it: its users find it ponderous and often confusing and difficult to use, despite the series of changes that Microsoft has brought into it over the years.

How does one overcome this issue? By attending this webinar. Here, Tom Fragale, who during his over 30 years of professional tenure has trained over 30,000 business people in on-line webinars, public seminars, and on-site training, will show four trendy ways to improve on Microsoft Outlook tips.

At the end of this webinar, participants will have learnt how to use Microsoft Outlook more confidently and to efficiently organize their information and commitments. Tom will show participants a series of smarter tips, tricks and systems with which they can manage their tasks, follow-ups, contacts, notes and calendar items better. Far from being a textbook handout, this session will be a thoroughly enjoyable one with lively talk and a lot of interactivity.

Participants will no longer find themselves having to sift through a stuffed inbox or having to respond to meeting requests all day. They will simply open their inbox, do what is required, and be done with quickly.

Immense uses from learning MS Outlook best practices

The MS Outlook best practices that Tom will impart at this webinar will make working on this program a lot less boring and time-consuming. He will how to optimize the uses of this versatile program, which can be immensely helpful to those who want to put it to the best use.

Tom will cover all the aspects of MS Outlook at this session. He will cover the following areas:

  • How to create and use an Outlook “To-do” list
  • How to easily build your contacts list
  • How to keep your notes and ideas in email folders
  • Tricks for automating your emails
  • Calendar tricks that save you time
  • Creating and using Folders to help you organize better
  • Creating Rules to automatically handle emails
  • Flagging Emails for Follow
  • Sorting and Filtering Emails
  • Mail Merge with your Contacts.

This webinar is of high value to those who use MS Outlook day in and day out, and these include:

  • Business Owners
  • CEO’s/CFO’s/CTO’s
  • Managers of all levels
  • Anybody who uses Excel on a regular basis, and want to be more efficient and productive
  • Administrators
  • Salespeople
  • Trainers
  • Bankers
  • Office Workers.


About the speaker:

Tom Fragale’s clients include many Fortune 500 companies, government agencies, military bases, and companies large and small across many industries, including manufacturing, banking, pharmaceutical, education, retail, etc. He is an expert at Access, Excel, Word, PowerPoint, Outlook, Crystal Reports, SQL Server, Visio, QuickBooks, and SharePoint, among others, and has even written a book on Microsoft Access.

Want an Easy Fix for Your Excel Spreadsheet [Techniques?] Read This!

It surprise that MS Excel is a superhit with a range of industries from finance and compliance and from teaching to sales?

Microsoft Excel is a wonder package, and in saying this, I am not exaggerating or taking sides with Mr. Gates’s developers. They have created a program that is so versatile and so tailor-made for just so many industries that you would wonder from where they got the idea to do this. I reckon they must have worked extensively with the industry closely in understanding its needs and implemented all the details with devilish diligence.

The MS Excel program is simply so exhaustive and comprehensive you would feel lost if you are not familiar with it. Once you gain an element of familiarity, it works wonders for most of your needs. Does it surprise that MS Excel is a superhit with a range of industries from finance and compliance and from teaching to sales? All that is needed is a bit of comfort in understanding MS Excel’s features to get to exploit the program to the limit.

So, do you want an easy fix for your MS Excel spreadsheet techniques? Read this!

Like I said, the uses of MS Excel are extremely varied and vast. So, if one were to write down want an easy fix for your MS Excel spreadsheet techniques, it would take a manual! Let me try to make your usage of MS Excel a little easier by offering you tips on a few key features of MS Excel:

Select all with one click

Often, I have noticed users finding it complicated to drag the arrow to all the areas they want to select in the Excel worksheet. I have myself sometimes lost patience with it! I discovered a very simple method of doing this (apart of course from using Control A): click on the arrow (half triangle) at the left corner of the row and you’re done!

Pivot Tables

Pivot Tables are a quick way of organizing an enormous number of varied and disparate data sets. It helps in areas such as getting to understand the exact number of units sold of a particular item in a shop and the amount earned from the sale. This feature helps to organize the data quickly, meaningfully and insightfully. All that is needed for an easy fix for your MS Excel spreadsheet techniques for Pivot Tables is this:

Report Filter: To create by rows by parameters such as, in this case, pack size, manufacturer, date of arrival of stock into the inventory and expiry date

Column Labels: Helps you give a name or label to the items

Row Labels: Enables you to supplement Report Filter by qualifying the labels from the columns and can be used in any manner that the user finds easy

Value: This is the actual calculating part of the tables. It does any kind of operation you want from it like multiplication of the values based on the units sold, minimum, maximum, average, sum and so on.

Removing duplicates

Some cells can carry duplicate content depending on what kind of data go into them. All that is needed to remove the duplicates is to go to select the row or column from which you want this done; go to Data, go to Tools and hit “Remove Duplicates”.


This is used to obtain the sum of different values in cells. Just go to the far-right corner and click on the AutoSum option. You will have the choice of sum, average, count numbers and so on. Once you set this, it will keep doing the summing up by itself.

Open many MS Excel files and shift between them

This is one hell of a feature from MS Excel! Once you have created different files in the usual file creation mode, just click on each of them and press enter. All files will open simultaneously. And then, if you want to alternate between any of them, keep hitting control tab, just like in MS Word.

Carrier with Excel If you Loose this now?

Best Ways to Create Pivot Tables and Pivot Charts

This versatile program is usually rated as Excel’s best analytical tool because it combines swiftness with amazing flexibility and dynamism. The latter of these characteristics enable alteration of the data interrelationships that are being viewed.

Microsoft Excel is a fabulously versatile program whose functions include sorting, filtering, and subtotal to manage large lists of data. It has another brilliant feature for analyzing all that data quickly: The MS Excel PivotTable. The MS Excel PivotTable is all the more useful when a compact summary report (based on lots of data) needs to be created quickly, without being required to write complex formulas or rely on lengthy techniques.


This versatile program is usually rated as Excel’s best analytical tool because it combines swiftness with amazing flexibility and dynamism. The latter of these characteristics enable alteration of the data interrelationships that are being viewed.

On top of all these, MS Excel PivotTable is practical. This enables its features to be put to real-life use by getting the user to work on it without having to go through the instructions on the printed page, which is a visually-oriented feature based on displaying fields in different locations. MS Excel PivotTable makes it possible to create a complete summary report with loads of data in very little time without the need for writing complex formulas and rely on doubtful techniques.

Get a good understanding of all the features and aspects of PivotTable

Want to gain complete understanding of the numerous PivotTable capabilities and its many tools and features and boost your work capabilities?

Pivot Charts

Simplifying PivotTable

The fastest and most optimal ways of creating PivotTables and Pivot Charts  to get all answers to get online resources:

  • How to compare two or more fields in a variety of layout styles
  • How to sort and filter results
  • How to perform ad-hoc grouping of information
  • How to use Slicers instead of filters to identify which field elements are displayed
  • How to drill down to see the details behind the summary
  • How to categorize date/time data in multiple levels
  • How to create a Pivot Chart that is in sync with a PivotTable
  • How to add calculated fields to perform additional analysis
  • How to hide/reveal detail/summary information with a simple click
  • How to deal with dynamic source data and the “refresh” concept
  • How to create a PivotTable based on data from multiple worksheets.

If after that you want to cover huge areas in MS Excel PivotTable so Join session

and Pivot Charts

  • Pre-requisites for source data – preparing data so that it can be analyzed by PivotTables
  • Creating a PivotTable with a minimum number of steps, including the Recommended PivotTables option
  • Manipulating the appearance of a PivotTable via dragging and command techniques
  • Using Slicers to accentuate fields currently being shown (and which ones are not)
  • Using the new (in Excel 2013) Timeline feature
  • Creating ad hoc and date-based groupings within a PivotTable
  • Quickly create and manipulate a Pivot Chart to accompany a PivotTable

This session is aimed at those MS Excel users who are familiar with PivotTable concepts, but need expanded techniques to analyze lists of data. In addition, it is also meant for anyone wanting to know how to create PivotTables from multiple sources and use Slicers, Timelines, Calculated Fields, and Conditional Formatting.