Learn how to compare two columns in Excel

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...
Read More

#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...
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 asked us about the monthly reporting related...
Read More

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....
Read More

#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...
Read More

Working with Excel Formula Shortcuts | Excel tips & tricks

Learn Excel Shortcuts Formulas to make your life 4x faster 4 Excel shortcuts that can save tons of your time and make you look cool. 1. How to activate the “Function Argument” dialog box after writing a function in Excel? E.g. After writing “=VLOOKUP(” – ensure bracket is open, press Ctrl + A Before:   After:...
Read More

13 Tips for making a Business Website

Your mind is set, the commitment is made, the budget has been allocated and you think that hiring a good web designer is the only next milestone you need to cross before your very own business website is up and running….. Wrong!! You are in for a big surprise as you realize that there are...
Read More