Microsoft Office Training

Learn Microsoft Office Tips and Tricks to become 4X Faster

#AskYoda MS Office Webinar 1003 - 29nd March 2017

Here is the video of our #AskYoda webinar 1003 conducted on 29nd March 2017, our expert had answered queries related to MS Excel & Word. Here is a glimpse of queries replied to in this Webinar: Three Student questions were answered LIVE on topics like Mr Sandipan from customer...

READ MORE

#AskYoda MS Office Webinar 1002 - 22nd March 2017

Here is the video of our #AskYoda webinar 02 conducted on 22nd March 2017, our expert had answered queries related to MS Excel. Here is a glimpse of queries replied to in this Webinar: Three Student questions were answered LIVE on topics like Robin from Business Analyst background...

READ MORE

Recorded: #AskYoda Webinar Wednesday 15th March

Here is the video of our #AskYoda webinar conducted on 15th March 2017, our expert had answered queries related to MS Excel & MS Word. Here is a glimpse of queries replied to in this Webinar: Three Student questions were answered LIVE on topics like Bhanu from executive...

READ MORE

Learn how to compare two columns in Excel

Like a two-dimensional database, Excel is capable of storing many different types of data from small business contacts to personal income tax records. In both of these examples, accuracy is essential to make sure you have the information you need when you need it. In any data entry situation,...

READ MORE

Learn how to calculate ratios in Excel

Before we start learning how to calculate ratio, we must learn what is a ratio? Ratio: In simple mathematics, relationship or comparison between two more numbers is known as ratios. Ratios are normally written as ":" to show the connection between two numbers, for instance. If there are 2 red...

READ MORE

Learn how to enable or disable scroll lock in Excel

Tricks to Enable / Disable Scroll Lock in Excel Think: Imagine your report is due in an hour. You are working along in Excel, everything is going well, but suddenly you notice that you can no longer move around properly in your spreadsheet. You press the arrow keys, but instead of the cursor...

READ MORE

How to use Roundup Function in Excel

We can use a variety of formulas to round numbers in Excel depending on the situation. We have ROUND, ROUNDUP, ROUNDDOWN, MROUND, INT, TRUNC, CEILING, FLOOR, FIXED, EVEN, ODD and a few more. Here, we will learn how to Round up numbers in Excel. Before we start, we must know about Round up! What...

READ MORE

Learn how to create Scatter Plots in Excel

Choosing the right type of chart or graph can be key to convey the most important insights of your data—on sight. When you want to dig a little deeper into some data, but not quite sure how – or if – different pieces of information relate? Scatter plots are an effective way to give you a...

READ MORE

Learn how to create sparklines in Excel

Imagine you have result sheet for your students over the last 5 years and want to create a chart in Excel, which takes time. In that case you are thinking if only there were some small mini-charts in a single cell. Well here is the solution. Ever had a worksheet of data in Excel and quickly...

READ MORE

Learn how to remove blank cells in Excel

Data doesn’t always import or paste into Excel as nicely as you want. Sometimes, all the information is there, but extra blanks and spaces are carried along with the data cells. Think that if you work with a large data set in an Excel workbook, there are times you might need to delete a blank...

READ MORE