We will dispatch the device containing course content within 72 Hrs of purchase. This CD/DVD/Pen drive may be used to get started and continue with the course.
Complete List of Audio Video Tutorials in HINDI for Advance Excel - Excel Tips and Tricks, Excel Formulas by Zoomla Infotech-CHECKED BY CHARTERED ACCOUNTANTS
• If,And,Or Functions
• Array Functions
• Autofill And Custom List
• Autosum With Row Reference And Column Refrence
• Concatenate
• Condition Formatting With Mod Function
• Convert Function
• Countblank And Counta Function
• Creating Combo Box
• Large And Small
• Find, Search And Mid Function
• Formula Copy Shortcut
• Hyperlink Through Drag And Drop
• Index Function
• Information Function
• Left And Right Function
• Macro In Excel
• Match And Index Function
• Match Function
• Mod Function
• More Text
• Nested If
• Proper, Upper And Lower Function
• Rank Function
• Replace And Substitute Function
• Sumif,Countif And Averageif Function
• Sumifs , Countifs, Averageifs Function
• Text Functions
• Transpose Function
• Vlookup
• Weekday
• Form Creation Using Developer Tab in MS Word
• Insert And Edit the Data in Multiple Worksheets
• Insert Watermark in Excel 2010
• Quickly Transpose Data Using Shortcut
• Turn Off And On Worksheet Tabs And Scroll Bars
Excel - Tips and Tricks
• Changing Gridline Color And Hide Or Show Formula Bar
• Cycle Font Color
• Specify The Behaviour Of Enter Key
• Changing Label Orientation
• Selecting Group Of Cells
• Changing Worksheets Orientations In One Go
• Selecting Ranges With Keyboard
• Shortcut To Viewing Formulas
• Switch Between Workbooks
• Create Button
• Manipulating Objects
• Deleting Graphics When Deleting Row
• Hide Graphics
• Change Column Label In Number Label
• Change Shape Of Comment
• Controlling Display Of The Scroll Bars
• Print Gridlines And Headings
• Print Page Number At The Bottom Of Each Page
• Print Several Portions Of A Worksheet On A Single Paper
• Printing A Draft Of A Worksheet
• Printing A Portion Of A Worksheet
• Printing Rows Conditionally
• Printing Without Opening Workbooks
• Hiding Errors On Printout
• Print Comments In Excel
• Quickly Copy Formula
• Quickly Insert Current Date And Time
• Open A Copy Of A Workbook
• Centering The Worksheet Data
• Create Bar Graph
• Applying Range Names To Formula
• Entered Values Are Divided By 100
• Share Workbook
• Split Column Data
• Trick To Change Predefined Group Name
• Trick To Create Own Tab
• Trick To Insert Picture Comment
• Trick To Open Specific Workbooks
• Unprotect Only A Portion Of An Excel Spreadsheet
To get more information, you may want to watch the video below
Learn Everything, Anywhere, Anytime
India's Largest Online Education Marketplace
