27 January 2019 Excel Home Tab Clipboard options in Day-4 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[….] 000000
10 January 2019 Conditional Formatting in Excel Sample Practice questions Below you can download & practice excel workbook with sample questions on conditional formatting as per your knowledge level(Like beginner,[….] 210010
22 December 2018 Excel Day 3 Introduction to different tabs Below are the menu options in office 365 version of Excel. These options will keep on change, nowadays all office[….] 300000
9 December 2018 Excel Day 2 Training Workbooks, worksheets, cells, Rows and columns Object Model of Excel (Hierarchy) >Application >Workbook >Worksheet >Range/Charts/Shapes/Tables/Forms Excel Vocabulary Cell = Intersection of Column & Row Worksheet =[….] 100000
6 December 2018 Excel VBA Code to change Font of the First 5 letters in a single cell Before After Suppose we have text “Commerce and Excel hub” in Cell B3 like the example shown. Now using VBA[….] 020000
25 November 2018 Excel tips on daily work Some of the excel shortcuts we will use on a daily basis. Autofit columns Note: For Alt functions, we should[….] 000000
25 November 2018 Excel tip on Eomonth,Today and workday function Below syntax of functions EOMONTH(date, default is zero) TODAY() gives today’s date Remember this is a Volatile function which changes every[….] 000000
25 November 2018 How to apply Pivot table in excel Excel Pivot tables Below sales data in sheet 1. We want to know how much each salesman did for the[….] 000000
25 November 2018 How to use REPT function in EXCEL 2016 How to use REPT function in Excel 2016 REPT function will give us the option to repeat a particular text[….] 000000
25 November 2018 How to Use TEXTJOIN Function in EXCEL Excel 2016 TEXTJOIN function with Delimiter option In Excel 2016 we have a new TEXT function with a delimiter option. TEXTJOIN function Description This[….] 000010