About Advanced Level Microsoft Excel Course

This is an expert level excel course designed for advanced users of excel who are regular excel users understanding excel basics and intermediate functions. This course contains advanced level excel functions that are used for complex data analytics which will enable you to become an excel power user. Intricate details with precise examples have been well put in order to help you in the journey of becoming an advanced excel user.

Course Content

Let’s take a brief tour of what we shall be learning throughout this course.

1. Introduction & Scope

(About the course and the coverage during the course)

2. Advanced Excel Functions

(Learning Advanced Excel Functions and its detailed application)

3. Lookup Functions

(A bird’s eye view of Lookup Functions)

4. Working with Pivot Tables & Pivot Charts

(All there is to know about Pivot Table & Pivot Charts and beyond)

5. Power Query & Connecting to External Data Sets

(Unleashing the power of Power Query for messy data sets and automated calculations)

6. Automation Using Macros

(Understanding what macros are and how regular tasks can be automated using macros)

7. Understanding the Form Controls

(Understanding form controls)

8. Advanced Formulas – The New Age

(Understanding the various new formulas introduced and why these formulas will change your Excel experience)

9. Course Completion

(Course completion and knowing the next journey)

Note: Real world examples would be used throughout the course and the course is designed as to have a practical impact in your work life

Know Your Tutors

The trainers are senior members from Arthabrikshya Management Nepal Pvt. Ltd. Arthabrikshya is a team of professionals engaged in various training, workshops, financial and managerial consulting.

The team encompasses a combined experience of more than 12 years in data analytics and processing via spreadsheets including Microsoft - Excel. The team has already provided various Excel-related training to Multinational Companies, versatile industries and individuals positions from its very inception. This training has covered a wider range of areas both in terms of its scope and participation.

Tutor's Statement

“We believe that the practical know-how of Excel will guide you through the necessary functions and formulae in every difficult situation adding more value to your work. Hence in the course, we shall be relying on real-world data and its practical solutions to develop your Excel learning. Hope you enjoy the session with us. Happy Learning !!” – Arthabrikshya Team