Excel and PowerPoint: Excel - Learn from scratch, how to use Excel and its features - manage data, use formula, and how to present data effectively through visual representations. It also covers functions like Goal seek, H-Lookup, V-Lookup, Pivot Table, which helps in data analysis and report creation. A section on Excel for Finance explains finance related functionalities of Excel like PV, FV, NPV, IRR, NPV, PMT, IPMT, PPMT, CUMPRINC etc. through real-life examples.
|Getting Started||A brief discussion on PowerPoint(PPT) as a tool of choice, for presentations.|
Understanding the PPT interface and creating the first presentation.
|Editing and Formatting Text||Basic Text edits: Adding Text. Applying - 'Cut, Copy & Paste'. Finding and replacing a text.|
Formatting: Using fonts (using a font type, changing color, bold, underline and italics. Using 'Format Painter', 'WordArt', etc.
|Designing the presentation|
Using Themes: Formatting the slide master. Creating a custom theme. Changing slide layout, background color, etc.
|Adding Visual Illustrations||Inserting Objects and Pictures: Inserting a shape/ picture, formatting them, resizing, moving and removing them.Adding Charts: Inserting a chart. Editing the data in the chart, editing chart layout and labels etc.Adding SmartArt Graphic: Inserting a SmartArt graphic, and editing its elements. Converting text to smart art.Adding Tables: Creating a table, resizing its dimensions. Formatting the table to merge and split. Selecting a table style).|
Adding Hyperlink: Hyper linking objects/ text to a slide, file or web.
|Adding Animations||Screen Transitions: Adding or modify them.Custom Animations: A brief discussion on animation categories such as - 'Entrance', 'Emphasis', 'Exit', etc. Timing the animations (on click, after previous and with previous), and changing its order.|
Finalizing the Presentation: Checking spelling and grammar. Changing the order of the screens, or hiding them. Adding notes and comments.
|Presentation Skills||Setting up the Objectives: Creating the objectives and deciding on the content.Creating Key Points and Organizing the Content:Improve the key points from simple bullet points to interesting illustrations. Organizing the content according to them.Designing the Layout: Choosing appropriate theme and colors. Font types. Customizing the Slide Master.Adding Visual Illustration to the Content: Selecting relevant pictures, tables, charts, SmartArt for data. Modifying them basis the scenarios where they are used.|
Adding Animations: Selecting proper animations and timing them.
He started his career with Godrej Consumer Products and has worked with Godrej-Hersheys, TutorVista, Manipal K-12 and FLIP. He has over 5 years of experience in teaching/ education.
Have you used
Excel and PowerPoint for Professionals?