For Whom?

Employees / Business Owners / Management Students

What is taught?

Mail Merge

  • Merging Ms. Excel with Ms. Word & OUTLOOK

Macros

  • Record & Run Macros

X-LOOKUP

  • XLOOKUP to Two-way data search & Wildcard functions

Power Query

  • Data Management using multiple tables, sheets & files

Google Forms & Sheets

  • Creating & Sharing Google Forms & Sheets

Excel and Power BI Integration

  • DAX Measures and Formula
  • Pivot tables and Slicers
  • Data objects in Power BI
  • Paginated Reports
  • Publishing Power BI reports

What is taught?

Mail Merge

Merging Ms. Excel with Ms. Word & OUTLOOK

Macros

Record & Run Macros

X-LOOKUP

XLOOKUP to Two-way data search & Wildcard functions

Power Query

Data Management using multiple tables, sheets & files

Google Forms & Sheets

Creating & Sharing Google Forms & Sheets

Excel and Power BI Integration

Importing data from Excel into Power BI and cleaning up of data

DAX Measures and Formula

Working with DAX Formulas for display of desired data in reports

Data objects in Power BI

Working with data objects such as Slicers, Textbox, Charts, Images etc in Power BI reports

Paginated Reports

Creating and formatting Paginated reports

Publishing Power BI reports

Configuration of settings to publish Power BI reports

When?

Duration:  8 hours (1 or 2 days)

How?

Physical / Online / In-house

Cost

Per Student: INR 1,000

Per Batch depending on batch size (with assured 20% discount for batch size of 20 and above)