How to Make a Chart or Graph in Excel

While making a presentation to your clients or group of people, only presenting texts and figures aren’t attractive. Texts are necessary but visual representations make it even better. Microsoft Excel has pictorial representations like Chart or Graphs. They are excellent for statistical presentations which have a great recall value than mere statistical figures.

 

(more…)

28 Must Know Excel Keyboard Shortcuts – Tutorial 2018

For those of you who are required to work on Microsoft Excel spreadsheets on a daily basis, a list of Excel shortcuts can save you around 2 seconds per minute(8 working days per year). Yes, you heard it right!!
While every new version of Excel comes with new shortcuts, there are only about 20 – 30 keyboard shortcuts usually needed to sufficing everyday office work. Rests are typically used for advanced tasks.

(more…)

11 Excel 2016 Easy Tips and Tricks That You Should Know!

Microsoft Excel, Microsoft Word, and Microsoft Outlook are the heavyweights in the suite of Microsoft Office. It is no secret that Microsoft Office and especially Excel is a boon to all entrepreneurs and data entry professionals whose sole job is to keep the data and information stored in an organized manner online. It is a standard spreadsheet tool that is needed in most industries these days. (more…)

Using Get & Transform in Microsoft Excel 2016

Get & Transform is a powerful data analysis tool in Microsoft Excel that allows you to import, refine and work with data from a range of sources, including files saved to your computer and web pages on the internet. You can shape data in order to display the details relevant to your purposes and hide information that is not required, without making permanent and irreversible changes to the data. (more…)