Tutorials

Learn how to calculate ratios in Excel

Before we start learning how to calculate ratios, first 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 balls and 3 blue […]

Working with Excel Date Functions

In this article, let us learn more about Excel date functions and Excel date format. It will help you in areas of calculations such as due dates, project deadline & warranty expiry date. Here is a summary of what we will explain: 1 – How is a date stored in Excel (Hint: Every valid date […]

Create sales dashboard in excel using VBA Codes

You may have heard about (or seen) sales dashboard in excel a lot of time. When I was a beginner, I used to wonder how to create a sales dashboard in excel using your actual data. I recently helped one of the students of Excel VBA tutorial on how to build one . This can […]

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, people often transpose numbers wrongly or […]

#AskYoda MS Office Webinar 1001 – 15th March 2017

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 background asked us about the Investment related […]

#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 asked us about the monthly reporting related […]

Excel Advanced Filters to split data into separate sheets using VBA

Excel Advanced filters technique are useful when you deal with a large dataset. In this blog, we will try to cover one of Excel Advanced filter techniques to understand how to split data into a separate sheet through VBA code (it’s a part of our Excel VBA tutorial program). For instance, we have a huge list of U.S. […]

#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 service background asked us about the […]

Tricks of Text to Columns in MS Excel

One of the Advanced Excel techniques is Text to Columns. Excel’s “Text to Columns” feature is used for the following tasks: Splitting text of one cell in multiple columns (opposite of Concatenate) Changing the data format of a column (General, Text, Date) Converting numbers with trailing minus sign into negative numbers Converting invalid date formats […]

error: Content is protected !!