Courses / MS Excel

MS Excel Advanced

Advanced features for professionals: dynamic arrays, Power Query, dashboards and automation basics.

Instructor: Data Click | Level: Advanced | Language: Hindi | Price: Rs 1999

What you will learn

• Use dynamic array formulas
• Import and clean data with Power Query
• Build an interactive dashboard
• Record and edit simple macros

Requirements

• Good knowledge of Excel formulas and pivot tables

Course content

Advanced formulas

• Dynamic arrays
• LET and LAMBDA basics
• Array thinking

Power Query

• Import data
• Transform and merge
• Refresh reports

Dashboards

• Dashboard design
• Interactive controls
• Macros introduction

More online courses

• MS Excel for Beginners - Learn Excel from scratch: entering data, formatting, basic formulas, sorting, filtering and simple charts.
• MS Excel Intermediate: Formulas and Pivot Tables - Move beyond the basics with lookup formulas, conditional formatting, data validation and pivot tables.
• Computer Basics for Beginners - Start from zero. Learn how to use a computer, files and folders, the internet and email with simple video less
• MS Word Complete Course - Create professional documents: letters, resumes, reports, tables of contents and mail merge.
• MS PowerPoint Complete Course - Design clear, attractive presentations with layouts, animations, transitions and speaker tools.

Home | All software | All courses | About Data Click | Support