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
Videos
Books
Notes
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
Watch best faculty demo video classes

These top faculty video lectures will
help u prepare like nothing else can.