Quick view of Excel RIGHT Function Explanation: In the above table, the RIGHT function is applied to the data and the results are from D25 to D32. The formula can…

Excel Home Tab: Clipboard Options and Paste Special options explained in-detail In previous post we have seen names of different tabs in Excel. Now we will explore each tab and corresponding subcategories. Start with Home tab>…

Below you can download & practice excel workbook with sample questions on conditional formatting as per your knowledge level(Like beginner, intermediate, advanced). Beginner Task List Task1: Download Task Workbook Intermediate Task…

Below are the menu options in office 365 version of Excel. These options will keep on change, nowadays all office products are frequently updated by Microsoft Corporation. Different Tabs in…

Object Model of Excel (Hierarchy) >Application >Workbook >Worksheet >Range/Charts/Shapes/Tables/Forms Excel Vocabulary Cell = Intersection of Column & Row Worksheet = Sheet = all the cells in one sheet Workbook =…

Before After Suppose we have text “Commerce and Excel hub” in Cell B3 like the example shown. Now using VBA we want to change the font to bold only for…

Some of the excel shortcuts we will use on a daily basis. Autofit columns Note: For Alt functions, we should enter keys one after not all together. Select the cells…

Below syntax of functions EOMONTH(date, default is zero)  TODAY() gives today’s date Remember this is a Volatile function which changes every day as per system dates. WORKDAY(strat_date, days, [holidays]) this will…

Excel Pivot tables Below sales data in sheet 1. We want to know how much each salesman did for the overall year 2017. Before applying the pivot table it suggested…

How to use REPT function in Excel 2016 REPT function will give us the option to repeat a particular text for the required number of times in one cell. Description…