Description
We have covered the subjects to EXPERT LEVELS. Due to space constraint we are unable to show full contents here. Please have a look on the total duration and total number of tutorials in each subject given below, you will have a feel how much we have covered. Advance Excel Formulas Video Tutorials Total 75 Tutorials and Total 5 HoursLearning Tutorials for 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 Autosum With Row Reference And Column Refrence Concatenate Condition Formatting With Mod Function Convert Function Countblank And Counta Function Creating Combo Box Formula Copy Shortcut Hyperlink Through Drag And Drop Macro In Excel Mod Function More Text Rank 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 Watermark in Excel 2010 Quickly Transpose Data Using Shortcut Turn Off And On Worksheet Tabs And Scroll BarsExcel – Tips and Tricks 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 Create Button Manipulating Objects Deleting Graphics When Deleting Row Change Column Label In Number Label Change Shape Of Comment Print Page Number At The Bottom Of Each Page Print Several Portions Of A Worksheet On A Single Paper Printing A Portion Of A Worksheet Printing Rows Conditionally Quickly Insert Current Date And Time Open A Copy Of A Workbook Centering The Worksheet Data Create Bar Graph Applying Range Names To Formula Trick To Change Predefined Group Name Trick To Insert Picture Comment Trick To Open Specific Workbooks Unprotect Only A Portion Of An Excel SpreadsheetAnd many more Tutorials _____Total 5 hours duration______.
Reviews
There are no reviews yet.