The Next 7 Things To Immediately Do About Excel Data Visualization

Data visualization is the representation of numerical data in a visual format so that your audience can quickly and easily understand it and gain insight from it.


In this session, participants will learn how to visually represent your data using both traditional charts (bar charts, line charts etc.) as well as how to do the same using some of Excel’s non-charting tools.

Until a few years ago it was enough to take a set of numbers and create a bar chart or pie chart. Although in the right situation these traditional charts are still appropriate, things have moved on and we’re constantly hearing words like Data Visualization and Infographic.

It’s time to get your Excel-related business and communication skills up to date and learn how to use it to present data in the modern world. Data visualization is the representation of numerical data in a visual format so that your audience can quickly and easily understand it and gain insight from it.

Areas covered by the instructor

  • Charting 101 – create a basic chart
  • From drab to fab – enhance and customize a basic chart
  • Combination charts – line and bar in a single chart
  • Dynamic charts – automate adding new data to a chart
  • Creating in-cell Sparkline charts
  • Creating infographics with Excel
  • Using Conditional Formatting to present data visually
  • 3D Map – presenting geographic data in a visual way
  • An introduction to the Power View add-in

Important Learning Objectives you have to learn :

  • Learn how to select the most appropriate chart to convey your message
  • Learn how to create a chart from a set of data and change its appearance
  • Learn how to create Sparkline charts (really useful in dashboards)
  • Learn how to create infographic-style charts
  • Learn how to represent data in a visual way without using the charting tools

Continue to more detailed study


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?