COURSE 1: MS EXCEL Training for General/ Beginners
Embedded Files
Broad Training Outline
Introducing Excel Create a Chart Conditional summing formulas using
Introducing Excel with a quick hands-on 3-Dimensional charts multiple criteria
session Add Adding and removing data sets Formulas for performing common summing
Navigating Excel worksheets Adding unattached text tasks
Understanding what Excel is used for Breaking axis Information on counting and summing cells
Using Excel menus, toolbars, Changing the chart type Using Conditional Formatting
and dialog boxes. Creating charts using the Chart Wizard An overview of Excel’s conditional formatting features
Introducing Formulas and Functions Mixed Chart (combining two types of chart) Printing Your Work
Entering formulas and functions into Plotting non-adjacent cells Using Custom Number Formats
your worksheets Resizing charts and chart objects Working with Cells and Ranges
Understanding formula basics The series function. Working with Dates and Times
Creating Formulas That Manipulate Text Modifying Chart Option Worksheet Formatting
Examples of advanced text formulas Changing axis unit value and position
Excel’s worksheet functions that handle text Formatting the chart area
How Excel handles text entered into cells. Formatting the data series
Entering and Editing Worksheet Data Plotting error bars
Entering dates and times into Using a secondary axis
your worksheets Using Trendlines in a chart
Entering text and values into Pie Chart
your worksheets Exploding Pie Chart
Modifying and editing information Pie of Pie Chart (Second Pie).
Understanding the types of data you can use Creating Formulas for Financial
Using built-in number formats Applications
Essential Worksheet Operations A brief overview of the Excel functions that
Controlling your views deal with the time value of money
Manipulating the rows and columns An overview of Excel’s depreciation
Understanding Excel worksheet essentials functions
Performing Spreadsheet What-If Analysis Formulas that perform various types of
A what-if example investment calculations
Manual what-if analysis Formulas that perform various types of
Types of what-if analysis loan calculations
Basics of Chart Creating Formulas That Count and Sum
Change the default chart format, Advanced counting formulas
Chart types, Chart terms Basic counting formulas
Choosing an appropriate chart type Conditional summing formulas using a single criterion
COURSE 2: MS Excel Advanced
Analyzing Data Using Goal Seek and Solver Creating Formulas That Look Up Values Introducing Formulas and Functions
Analyzing Data with Pivot Table Basic lookup formulas Modifying Chart Option
Create your Own Chart Data Validation Performing Spreadsheet What-If
Example of User defined Chart Basic of Template Analysis Advance
Using Conditional Formatting
Working with Lists
COURSE 3: Mastering PowerPoint
PowerPoint Training [click to see the outline]
PowerPoint Training [click to see the outline]
Chapter 1: SEEING POWERPOINT WITH NEW EYES Chapter 8: CREATING TABLES & CHARTS
1. Navigating the Ribbon 1. Creating a Table
2. The Quick Access Toolbar 2. Formatting a Table
3. The Office Button 3. Creating a Chart
4. PowerPoint Options 4. Adjusting the Design & Layout of a Chart
5. Examining the Different Views 5. Additional Formatting Layout of a Chart
Chapter 2: UNDERSTANDING THE BASICS Chapter 9: USING ANIMATION
1. Built-in Themes 1. Types of Animations
2. Creating Color Schemes 2. Animating Text
3. Specifying Theme Fonts & Effects 3. Animating AutoShapes
4. Modifying Slide Masters & Layouts 4. Animating Charts
5. Choosing Background Styles 5. Animating Tables
6. Creating Custom Slide Layouts 6. Animating SmartArt
Chapter 3: STARTING YOUR PRESENTATION 7. Combining Animations
1. Starting the Presentation 8. Creating Trigger Animations
2. Adding Slides 9. Applying Slide Transitions
3. Working with the Outline Pane Chapter 10: ADDING MULTIMEDIA
4. Adding Slides from Text Files 1. Adding Sound to a Presentation
5. The Reuse Slides Pane 2. Playing Sound across Slides
6. Editing Slides Using Copy & Paste 3. Adding Video to the Presentation
Chapter 4: FORMATTING TEXT Chapter 11: MAKING YOUR PRESENTATION
1. The Font Dialog Box 1. Opening in Slide Show View
2. Applying Text Fills & Effects 2. Navigating with the Keyboard
3. Paragraph Settings 3. Using Presenter View
4. Using Tabs & Indent Markers 4. Printing Handouts & Speaker Notes
Chapter 5: USING DRAWING TOOLS Chapter 12: SHARING YOUR PRESENTATION
1. Inserting & Modifying Shapes 1. Adding Action Buttons & Links
2. Using the Picture Fill 2. Recording Narrations
3. Using the Gradient Fill 3. Checking Compatibility
4. Applying Shape Effects 4. Using the File Inspector
5. Arranging Your Shapes Chapter 13: TIPS & TRICKS
Chapter 6: USING PICTURES 1. Pinning Files to the Open Panel
1. Inserting Pictures 2. Using Connectors & Edit Points
2. Using the Clip Art Pane 3. Using the Freeform, Scribble & Curve Tools
3. Formatting & Arranging Images 4. Animating Master Slides
4. Creating a Photo Album 5. Exploring the Save As Options
Chapter 7: WORKING WITH SMARTART
1. Converting Text to SmartArt
2. Formatting SmartArt Diagrams
3. Modifying SmartArt Diagrams
COURSE 4: Marketing of Apps/Software
Training Duration: 1 day/2 days.
BRIEF OUTLINE
Tips and tricks of marketing Apps/Software
Understanding the Marketing basic theories
Dos and Don'ts in App marketing
Preparing marketing plan for a new App or an existing App
Finding out actual customers
Targeting customers
Ways and means to reach the customers.
Training Methodology
PowerPoint presentation
Hands on exercise
Group discussion & presentation,
COURSE 5: Social Media Marketing
COURSE 5: Social Media Marketing
Social Media Marketing (SMM)_What it is.
How Social Media works
Opportunities in SMM
Reasons of Content becoming Viral/Popular?
Tools and Resources
Audience Research
Facebook Advertisement Basic
Business Manager Account Creation and Ad Account Set up
Pixel Setup
Ad Creation
Tools and Resource
COURSE 6: Freelancing
COURSE 6: Freelancing
Contents:
Freelancing market places
Basics of Freelancing
Scope of earning money from Freelancing
Marketing of own freelancing page
Preparing gigs
Dos and Don'ts of preparing gigs
Better time to surf for clients around the world
How to write a Proposal against a Job Posting
Setting up of account
Setting up the money matter with local bank
Withdrawing money of the work your client has sent.
Page updated
Google Sites
Report abuse