Banking Professional

Excel and PowerPoint for Professionals

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.

Overview of Excel and PowerPoint for Professionals

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.

Table of contents

PowerPoint for Professionals
ChapterTopics
Getting StartedA brief discussion on PowerPoint(PPT) as a tool of choice, for presentations.

Understanding the PPT interface and creating the first presentation.

Editing and Formatting TextBasic 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 IllustrationsInserting 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 AnimationsScreen 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 SkillsSetting 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.

About faculty of Excel and PowerPoint for Professionals

Arun Patro
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.

Reviews of Excel and PowerPoint for Professionals

Rating - 4.6
5 stars 0
4 stars 0
3 stars 0
2 stars 0
1 stars 0

Have you used
Excel and PowerPoint for Professionals?

Rate Now:
OR
WRITE A REVIEW
Loading
Refer Your Friends
How to refer?

1 Click link below to share on facebook

OR

2 Enter your friends email address and invite them to join cakart (comma seperated)

Buy India's Best CA, CS, CMA Faculty Video Classes only at CAKART
Set up a call back request
Let us call you back

Any Question on video classes & books for your exam?

Set up a call back request