Advanced MS Excel Overview

Powerful tools in Advanced Excel enables users to effectively analyze, arrange, and visualize huge sets of data. It minimizes mistakes and saves time. This course is ideal for professionals aiming to boost efficiency in data handling and reporting for corporate environments.

The Advanced Excel course at Datapoint Computers in Mulund West offers both in-person and online training which emphasizes hands‑on practice via assignments, delivered by faculty with over 22 years of industry and teaching experience. We offer personalized 1-on-1 training options to ensure individual attention and better understanding.

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