WELCOME TO
EXCEL YOGI

Simplified and Convenient

76931011.jpg

To learn more about the courses we offer, don’t hesitate to get in touch.

MICROSOFT EXCEL - BASICS TO ADVANCED

MAKE YOU BASICS STRONG

- Getting started
- Managing worksheets & workbooks
- Formatting cells
- Printing
- Basic functions
- Basics of Charts
- Find & Replace
- Sorting
- Paste Special
- Keyboard Shortcuts

ENHANCE YOUR BASICS

- Intermediate Sorting
- Text to Column
- Go to Special
- Working with Named Range
- Useful Drop Down List
- Filtering the data
- Excel Tables
- Idea Buttons
- Sparklines
- Quick Analysis Tool

- V-Lookup

- Writing formulas

LEARN ADVANCED SKILLS

- H-Lookup

- Index Match

- Subtotals

- Forms Data entry

- Conditional Formatting
- Data Validations
- Flash fills
- Slicers
- Pivot Table
- Advanced Excel formulas
- Advanced Excel Charts
- Visual Basic for Application
- Recording your first Macro
- Write a basic Macro

basics.jpg
intermediate.jpg
ExcelAsq.png

Recent Posts

Let's Connect

+91 86898-25494

Stay updated; Subscribe!
  • Facebook
  • LinkedIn

©2020 by Excel Yogi