Courses / MS Excel

MS Excel Intermediate: Formulas and Pivot Tables

Move beyond the basics with lookup formulas, conditional formatting, data validation and pivot tables.

Instructor: Data Click | Level: Intermediate | Language: Hindi | Price: Rs 1499

What you will learn

• Use VLOOKUP, XLOOKUP and INDEX-MATCH
• Apply conditional formatting and data validation
• Build pivot tables and pivot charts
• Clean messy data quickly

Requirements

• Comfort with Excel basics

Course content

Lookup and logic

• VLOOKUP and HLOOKUP
• XLOOKUP
• Nested IF

Data tools

• Conditional formatting
• Data validation
• Remove duplicates and text tools

Pivot tables

• Create a pivot table
• Pivot charts
• Slicers

More online courses

• MS Excel for Beginners - Learn Excel from scratch: entering data, formatting, basic formulas, sorting, filtering and simple charts.
• MS Excel Advanced - Advanced features for professionals: dynamic arrays, Power Query, dashboards and automation basics.
• 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