Description

Looking to learn the Advanced Excel! If you already have a solid foundation in Excel and want to unlock the full potential of this powerful tool, you're in the right place. This course is specifically designed to help you become an expert user and leverage advanced features to streamline your workflow, analyze data effectively, and make informed decisions.

In this comprehensive course, we will cover a wide range of advanced topics and techniques that will elevate your Excel skills to new heights. We will explore complex functions, advanced data analysis tools, automation through macros, and much more. By the end of this course, you will have the confidence and proficiency to tackle even the most challenging Excel tasks.

Here's an overview of what you'll learn:

  1. Advanced Functions: Unleash the full potential of Excel by mastering advanced functions such as VLOOKUP, HLOOKUP, INDEX, MATCH, SUMIFS, COUNTIFS, and more. Learn how to combine functions and use them in practical scenarios.
  2. Data Analysis Tools: Dive deep into data analysis using Excel's powerful tools. Explore features like PivotTables, Power Query, and Power Pivot to transform and manipulate data, generate insightful reports, and uncover hidden trends and patterns.
  3. Advanced Charting and Visualization: Create visually appealing charts and graphs that effectively communicate your data. Discover advanced charting techniques, including dynamic charts, trendlines, sparklines, and conditional formatting.
  4. Data Validation and Protection: Ensure data accuracy and integrity by implementing data validation rules and using Excel's built-in protection features. Learn how to secure your workbooks with passwords and permissions.
  5. Automation with Macros: Automate repetitive tasks using Excel macros. Learn how to record and edit macros, assign them to buttons, and streamline your workflow by automating complex processes.
  6. Advanced Formulas and Array Functions: Harness the power of array formulas to perform complex calculations on multiple data sets. Explore advanced formula techniques, including IF statements, nested functions, and array manipulation.
  7. Collaboration and Integration: Discover how to collaborate with others using Excel's sharing and tracking features. Learn how to import and export data from external sources, link workbooks, and leverage Excel's integration with other applications.

Throughout the course, you'll engage in hands-on exercises and real-world examples to reinforce your learning.

Whether you're a business professional, analyst, accountant, or anyone working with data, this course will equip you with the skills to excel in your role. Join us on this exciting journey to become an advanced Excel user and unlock the full potential of this indispensable tool. Enroll now and take your Excel skills to the next level!

Course Content

Total: 54 lectures
  • Introduction
  • Structure of the course
  • Function Library Part 1
  • Function Library Part 2
  • AutoSum
  • How Date and Time Works
  • Basic Date and Time Functions
  • Complex Date and Time Functions
  • Text Functions Part 1
  • Text Functions Part 2
  • Logical Functions
  • Logical Functions Exercise
  • HLOOKUP
  • VLOOKUP
  • Lookup Functions Exercise
  • Financial Functions and Terminology
  • Personal Financial Functions
  • Professional Financial Functions
  • Depreciation
  • Financial Functions Exercise
  • Statistical Functions for Description Part 1 and Part 2
  • Statistical Functions for Forecasting Part 1 and Part 2
  • One Click Forcasting
  • Statistical Functions for Inference
  • Statistical Functions Exercise
  • Connect To Other Workbooks
  • Connect To Access Database
  • Connect To Web Data Sources
  • Get and Transform
  • External Data Exercise
  • Tables
  • Work With Tables
  • Table Reference
  • Table Styles
  • Tables Exercise
  • Pivot Tables
  • Work With Pivot Tables
  • Filters and Slicers
  • Pivot Charts
  • Pivot Tables Exercise
  • What If Analysis
  • Scenario Manager
  • Goal Seek
  • Solver
  • Data Analysis Exercise
  • Area Charts
  • Surface Charts
  • Radar Charts
  • Bubble Charts
  • Sparklines
  • Stock Charts
  • Graphs and Charts Exercise
  • Excel Web App
  • Use Excel Web App

Reviews

Please login or register to review

Related Courses

BCC - Basic Computer Course

beginner

BCC - Basic Computer Course

4.4 (20)
₹1,534 ₹2,545
CCA - Certificate in Computer Application

beginner

CCA - Certificate in Computer Application

4.4 (20)
₹2,065 ₹2,675
Microsoft Excel

beginner

Microsoft Excel

4.4 (20)
₹1,500 ₹3,000
Data Analysts Toolbox - Excel, Python, Power BI

beginner

Data Analysts Toolbox - Excel, Python, Power BI

4.4 (20)
₹799 ₹30,000