Advanced Excel Training

Advanced Microsoft Excel Training : Learn the most in-demand skill in industry. Duration: 4 weeks | Certified Training by Corporate Trainer . About Advanced Excel Training is a 4-weeks training program covering Basic plus Advanced modules of MS Excel. The main objective of this training is to make students proficient with Excel by practicing everyday industry usage of MS-Excel. During the course of this training, students will get hands-on work exposure on various live projects. Students will be presented with interesting real-life scenarios and have to use the Excel tools, functions and data visualization techniques learned to solve problems, make inferences and present data in a meaningful and effective manner using Excel.

Table of Contents

1. Getting Started: Get familiar with Excel Learn the basic operations and formulas of excel.

• Introduction to MS Excel software
• Why should we learn MS Excel?
• Orientation / Tour and features of MS Excel.
• Interface & Terminology
• Excel worksheets and workbooks
• Excel Ribbon
• Backstage View
• Quick Access Toolbar
• All Keyboard shortcuts.

2. Excel Basics: You will learn basic concepts in this module which will give you a chance to build a solid foundation.

• Cell Basics
• Modifying cells/rows/columns
• Basic Cell Formatting
• Cell Number Formats
• Cut, Copy & Paste
• Format Painter
• Personalizing Worksheets
• Multiple worksheets Linkings
• Find & Replace Option
• Sheet Protection
• Printing & Page Layout Formatings
• Assignment Work (Dashbord)

3. FORMULAS & FUNCTIONS: In-depth lessons on formulas, functions, lookup functions and data validation with Excel

• Basic Formulas
• Advanced Formulas
• Cell References
• All Excel Functions
• Date/Time Functions
• Text Formatting Functions
• All Financial Functions
• Logical Functions
• Lookup Functions
• Data Validation
• Troubleshooting
• Assignment-2 Work

4. WORKING WITH DATA: You will learn all about data organization and data visualization

• Basic tips for working with data
• Freezing panes and view options
• Data sorting and arranging.
• Error Checking and data Monitoring. 
• Data Validation with In Cell Drop Down List.
• Data filtering , Auto Filtering
• Protecting and Hiding data 
• Tables and beautiful Charts
• Assignment -3 Work Dashboard.

5. ADVANCED CONCEPTS: You will learn the skills needed to automate, analyze & present Excel data in the most effective manner

• Conditional Formatting
• What-If Analysis , COUNTIF
• If combined with AND / OR Functions
• Choose Function – Pic specific numbers
• LEN and TRIM (Remove Extra Spaces) Functions
• CELL, LEFT , MID and RIGHT text functions
• RANDBETWEEN function.
• TIME functions all.
• Mathematical Functions.
• INDEX and MATCH Functions.
• Concatenations- Joining Information from different cells. (Combination of LEFT and RIGHT fuunctions)
• Keyboard Shortcuts
• Pivot Tables Round 1
• Pivot Tables Round 2
• Advanced Pivot Tables Round 3
• Macros and VBA Programmings
• VBA Macro Walkthrough. 
• Introduction to Power Pivot.
• Assignment -4 Work