Advanced MS Excel Overview

Advanced MS Excel equips learners with powerful tools to analyze, organize, and visualize large volumes of data efficiently and accurately. It helps reduce errors, automate complex tasks, and save time—making it an essential skill for modern workplaces. This course is designed exclusively for students and working professionals who want to strengthen their Data Handling and Reporting capabilities for corporate environments.

The Advanced Excel Course at Datapoint Computers, Mulund West is offered through both classroom and online training modes.The program emphasizes hands-on learning through practical assignments and real-world examples,led by expert faculty with over 22 years of industry and teaching experience. To ensure maximum learning outcomes, we also provide personalized one-on-one training, allowing focused attention and better conceptual clarity.

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