Why this course?

Description

COURSE OVERVIEW

This course is designed for the Professionals who are expert in Excel, VBA Macros, PowerPoint who wants to build High End Automations using Excel, VBA Macros, PowerPoint and othe MS Office Applications.

DETAILED COURSE CURRICULUM

Complete usage of Dynamic Range

• Static & Dynamic Range
• Dynamic Range in UserForms
• Dynamic Range in Dependent DropDowns in UserForms
• Dynamic Range in PivotTables
• Dynamic Range in Formulas
• Dynamic Range in DropDowns
• Dynamic Range in Data Validations
• Dynamically Change Country Flags

Get PowerPoint Slides & Images in MS Excel

• Get PowerPoint Slides in MS Excel
• Get Images / Photos in MS Excel
• Create Dynamic Photo Gallery in MS Excel
• Get PowerPoint Slides Gallery in MS Excel
• Complete PowerPoint Presentation in Excel
• Create Thumbnails & Enlarge Slides / Photos in MS Excel
• Learn to Create InfoGrahpics from scratch

Complete Power Query In MS Excel

• Get Data from Various Data Sources
• Using Power Query Editor
• Data Modeling
• Merge and Append Data
• Adding Custom Columns
• Adding Conditional Columns
• Understanding Queries
• Understanding Queries and Connections

Linking MS Office Applications

• Hyperlinks to Open Files
• Attach Files as Links
• Create New Object in Excel, Word, PPT
• Insert Objects without Links
• Insert Objects with Links
• Insert Objects with Application Icons
• Export Excel Table, Charts to PPT, Word,
• Update Data in PPT Tables, Charts

Automate Export MS Excel Objects To PowePoint

• Name the Objects in PowerPoint
• Export Excel Table to PowePoint as Editable Object
• Export Excel Charts to PowePoint as Editable Object
• Export Excel Table to PowePoint as Picture
• Export Excel Charts to PowePoint as Picture
• Update Data in PowerPoint Table
• Update Data in PowerPoint Charts

File Dialog Using VBA macros

• File Dialog File Picker
• File Dialog Folder Picker
• File Dialog Open
• File Dialog SaveAs
• Get Open FileName

 WHO SHOULD TAKE UP THIS COURSE?

The following professionals can take up this Course:

• Data Analyst
• Business Analyst
• Financial Analyst
• Advanced Excel User

PRE-REQUISITES FOR THIS COURSE

1. Good Knowledge on MS Excel, VBA Macros, PowerPoint
2. Laptop or Desktop with Excel 2016 version and above installed is required to use the practice material
3.  Stable Internet Connection

COURSE DELIVERY FORMAT & CERTIFICATE

1. You will undergo self-paced learning where you will get an in-depth knowledge of various concepts that will be covered in the course.
2. You will get lifetime access to all the videos, discussion forum and other learning contents inside the Learning Management System.
3. Each module will contain case study, which can be completed before going to next module.
4. Towards the end of the course, you will be attending series of MCQ question where you are expected to implement the techniques learnt during the course to answer them.
5. You need to score atleast 70% in MCQ test to be eligible to get the Certification.

Have More Queries? - Contact us on 9066078793 or write to us on enquiry@itasinc.in

Facing Technical Issues? - WhatsApp us on 9066068793, issue will be resolved as early as possible