Advanced MS Excel Overview

Advance MS Excel, helps the user to process, analyze, format, present data, perform complex calculations and much more, with the help of features like Formulas, Pivot Table, Sorting, Filter, Subtotal, Excel Charts, Conditional Formatting,scenario,table etc. Advanced MS Excel Course allows the users to unlock the potential of their data, by using formulas across a grid of cells. Features of Advance MS Excel are highly used by Business Owners to display financial information and other data relevant to the running of the Business.

BENEFITS of MS Excel

• Creating reports In MS Excel
• Handling long database
• Very imp for corporate companies & any Business
• Using Basic & Advanced formulas in MS Excel work becomes easy
• Searching data from long database becomes easy
• Saving time & energy for formatting MS EXCEL Sheets.

CONTENT

• Introduction to Excel Worksheet, Total Rows & Columns, Worksheet & Basic Features, Cell Styles
• Editing A Worksheet, Conditional Formatting, Making Own Custom List
• Insertion Of Extra Rows, Columns, Worksheet, Hide, Unhide, Auto Fill, Flash Fill
• Charts (Types, Design, Layout, Formats)
• Use Of Hyperlinks, Smart Art Features
• Calculations Using Functions (Sum, Min, Max, Average, Count Etc)
• Using Logical Functions.(If, And, Or, Andif, Orif, Countif, SumifEtc)
• Use Of Text Functions (Upper, Lower, Concatenate, Len, Replace, Proper, Left, Right Etc)
• Lookup Functions(Hookup &Vlookup, Round, Roundup, Round Down) Advance Functions (Multiple If, Offset, Index, Match & Many More...) *Date Function * Time Function *
• Protecting A Worksheet, Workbook Use Of Scenario (CREATING REPORTS), Auditing Features, Macro ((Automate Routine Work), Goal Seek
• Database Management Using Sort (Using Levels) & Filter (Advanced Filter), Sub-Total
• Combining A Different Sheet Using Consolidate, Validation (Check Existing Data Or For New Data Entry),extracting data from other database using validation-list
• Use Of Pivot Table & Creating Reports
• Proofing, Comments & Changes, Spark Lines, Page setup for Printing
• Formula Auditing , Calculation & Link Etc
• Creating Tables Using Pmt Functions