Mukesh Chopra

Years of Experience in Microsoft Excel Training classes

20

Teaching Experience in detail in Microsoft Excel Training classes

Following are the topics planned to be covered: MS Excel : Overview of Basics - Introduction to MS EXCEL - MS Excel Interface Data Management - Data Creation, - Data Editing / updation - Cell Referencing (Absolute & Relative) - Data Formatting & Conditional Formatting Data Sorting & Filtering - Sorting tables - Filtering data using Auto Filter Data Validation & Forecasting - Data Validation - What if Analysis Working with Excel Functions - Mathematical Functions - Logical Functions - including Vlookup, Hlookup etc - String Functions Working with Reports - Pivot Tables - Pivot Charts - Multiple sheets Data Consolidation - Sub-Total creation in Pivots - Creation of Dashboards Time Saving techniques in Excel - Working with Ready made Excel Templates - Using Worksheet Short Cuts

Years of Experience in Microsoft PowerPoint Training classes

20

Teaching Experience in detail in Microsoft PowerPoint Training classes

Following are the topics that I shall cover in the PowerPoint Program   1. Introduction a. Getting Started with PowerPoint i. Navigate the PowerPoint Environment ii. View and Navigate a Presentation iii. Create and Save a PowerPoint Presentation iv. Use PowerPoint Help b. Developing a PowerPoint Presentation i. Select a Presentation Type ii. Edit Text iii. Build a Presentation c. Performing Advanced Text Editing Operations i. Format Characters ii. Format Paragraphs iii. Format Text Boxes 2. Intermediate a. Adding Graphical Elements to Your Presentation i. Insert Images ii. Insert Shapes iii. Create SmartArt iv. Insert Icons and 3D Models v. Arrange and Size Object b. Modifying Objects in Your Presentation i. Edit Objects ii. Format Objects iii. Format Icons iv. Format 3D Models v. Group Objects vi. Arrange Objects vii. Animate Objects viii. Customize SmartArt c. Managing Slides i. Sequencing Slides ii. Duplicating Slides iii. Deleting Slides iv. Hiding Slides 3. Advanced a. Adding Tables to Your Presentation i. Create a Table ii. Format a Table iii. Insert a Table from Other Microsoft Office Applications b. Adding Charts to Your Presentation i. Create a Chart ii. Format a Chart iii. Insert a Static Chart from Microsoft Excel iv. Insert a Live Chart from Microsoft Excel c. Applying Multimedia Effect to Your Presentation i. Apply Transitions ii. Apply Sound iii. Apply Different Animations to Individual Objects iv. Sequence & Automate Animations on Slides d. Time Saving Techniques i. Using Templates ii. Using Short-Cuts iii. Using Design Ideas e. Preparing to Deliver Your Presentation i. Review Your Presentation ii. Using the Presenter View iii. Print Your Presentation iv. Deliver Your Presentation   The course would require the following - Computer/laptop - MS PowerPoint installed on system - Dedicated Internet connection - Zoom connection This is a minimum 3-days (1-hour per day) training program for PowerPoint. You may take as many days of training that you want till you dont get confidence in the listed topics taught. I shall NOT be charging you additional fees for the additional days. After the completion of the course, I will be giving you Free lifetime support on clarification of doubts on the taught topics. In case you have specific requirements, the course content and cost can be altered / customised accordingly. Do let me know if you want any further clarification.

Years of Experience in MS Project Training

20

Years of Experience in MS Office Software Training

20

Years of Experience in MS Access Training

20

Teaching Experience in detail in MS Access Training

Following are the topics planned to be covered: MS Access: Overview of Basics - Introduction to MS Access - Introduction to the Screen / Interface Database Creation - Table creation - Primary and Foreign Key Creation - Database linkages using Keys - Data Management - Reporting Procedures - Use of Filters - Use of Group - DBMS Management using various SQL Commands - Data reporting process using SQL commands - Database and Table management processes The course would require the following - Computer/laptop - MS Accessinstalled on system - Dedicated Internet connection - Zoom connection This is a minimum 6-days (1-hour per day) training program for MS Access.

Years of Experience in MS Outlook Training

20

Years of Experience in MS Word Training

20

Teaching Experience in detail in MS Word Training

Have been using MS Word for more than 20 years specially using all the varieties of functionalities of MS Word. For the training I would be taking following topics into consideration: MS Word : Overview of Basics - Introduction to MS Word - MS Word Interface Document Creation - Document Creation - Varieties of Documents & Design - Inserting Images, Hyperlinks - Creation and formatting of Text - Creation of Static Data & Graph representation Print Document Hand-outs Working with Documents Automation - Document Dictation Time Saving techniques in MS Word - Using MS Word Short Cuts

Years of Experience in Microsoft Power BI classes

15