ADVANCED EXCEL
Advanced Excel tells you, who’s the real boss. This course trains you for enhancing competency level about advanced formulas and functions of Excel that transforms it from a basic conventional type spreadsheet into a modern, dynamic and powerful analytics tool.
This course emphasizes on the implementation of formulas on real time scenario-based problems, projects and their solutions. We train you for various ways in which these elegant formulas and functions can be applied to get the required analytical results and build robust reports.
Learning Outcomes:
By the end of the course you would be able to:
- Make Excel Dashboard to Filter, Display Summarized and Analyze Data
- Systemize and automate analytical tasks by using cell formulas and functions.
- Join datasets from multiple sources in seconds with lookup, index & match functions
- design your own formula-based formatting rules
- Handle and Manipulate times, date, texts, and arrays
- Access APIs directly to pull real-time data into Excel sheets (time, weather, stocks, direction etc.)
Who is the target audience?
- Excel users, accountants, managers, self-employed, students; who have basic skills of Excel but desire to get deep understanding of excel formulas, functions to make dashboard, and summary reports etc.
- Anyone desirous to expand his analytics skill set, work more effectively & efficiently with data, hands-on experience and highly interactive approach to Excel analytics training to take their career to a higher level.
Course Contents
- Advanced Excel Formulas
- Formula-Based Formatting, Array Formulas
- Conditional Statements & Logical Operators
- Statistical Tools & their Functions
- Lookup, Reference Functions
- Text Functions, Date & Time Functions
