Course Details

Home
Course Details

(0) Rating

Advanced Excel techniques

Advanced Excel techniques include PivotTables, VLOOKUP, INDEX/MATCH, macros, conditional formatting, and data validation for powerful data analysis and automation.

Robert Smith

Advanced

ORGANISATIONAL DATA LITERACY

Course Overview

Advanced Excel techniques include PivotTables, VLOOKUP, INDEX/MATCH, macros, conditional formatting, and data validation for powerful data analysis and automation.

Learning Outcomes

Course Requirements

Course FAQS

Course Curriculum

Advanced Formulas: INDEX-MATCH, OFFSET, INDIRECT

0 Lesson

Working with Named Ranges

0 Lesson

Macros and Automation (Introduction to VBA)

0 Lesson

Creating Dynamic Charts & Dashboards

0 Lesson

Power Query Basics for Data Transformation

0 Lesson

Introduction to Power Pivot

0 Lesson

Course Instructor

Robert Smith

Senior Web Developer

instructor@gmail.com

Hi, I’m Robert, a passionate UI/UX designer with a keen eye for creating intuitive, user-centric designs. I specialize in crafting seamless digital experiences that not only look great, but are also functional and accessible. With a strong background in design principles and a love of innovation, I strive to deliver interfaces that solve problems while providing delightful user interactions. Whether it’s designing mobile apps, websites, or complex software, my goal is always to improve usability and ensure a seamless journey for the end user.