Advanced Excel

Advance Excel


Module No. 3: Advance Excel

Microsoft Advanced Excel Course is a spreadsheet application developed by Microsoft for Microsoft Windows and Mac OS. It includes calculation tools, graphical tools, pivot tables, and a macro programming language called Visual Basic for Applications. For these platforms, especially since version 5 in 1993, it has been a very widely applied spreadsheet and has replaced Lotus 1-2-3 as the industry standard for spreadsheets. Microsoft Office is part of Excel. DGA’s Microsoft Excel Advanced Training is suitable for those who want to advance to Excel’s most complicated features and functions to enhance their Spreadsheet skills for the best corporate jobs with sound working knowledge of excel.

Advance Excel Contents
About Excel 2010/13, Tabs & Ribbons, Workbook, Workspace & Sheets.
Cell Referencing: Relative, Mix & Fix, Creating & Formatting Options.
Conditional Formatting, Data Sorting & Searching, Filter & Data Validation.
IF Conditions, Vlookup, Hlookup, Index, Match, Sumproduct, Text Functions.
What if Analysis, Text to Columns, Consolidate, Subtotal, External Data.
Freeze Panes, Print Setup, Share Workbook, Security Features etc.

Previous                                                                                                                                              Next