The course is a combination of Microsoft Excel Basic and Intermediate, as well as, Microsoft Powerpoint Basic and Intermediate.

Click to read more about Microsoft Excel Basic

Click to read more about Microsoft Excel Intermediate

Click to read more about Microsoft Powerpoint Basic

Click to read more about Microsoft Powerpoint Intermediate

Microsoft Excel Basic

• Indicate the names and functions of the Excel interface components
• Enter and edit data
• Format data and cells
• Construct formulas, including the use of built-in functions, and relative and absolute references
• Create and modify charts
• Preview and print worksheets
• Use the Excel online Help feature

Microsoft Excel Intermediate

• Create pivot tables and charts
• Learn to trace precedents and dependents
• Convert text and validate and consolidate data
• Collaborate with others by protecting worksheets and workbooks
• Create, use, edit, and manage macros
• Import and export data

Microsoft Powerpoint Intermediate

Upon completing this course, you will be able to create and deliver engaging multimedia presentations that convey the key points of your message through the use of text, graphics, and animations, you will:

• Identify the basic features and functions of PowerPoint
• Develop a PowerPoint presentation
• Perform advanced text editing operations
• Add graphical elements to your presentation
• Modify objects in your presentation
• Add tables to your presentation
• Add charts to your presentation
• Prepare to deliver your presentation

Microsoft Excel Basic

Intro Section:

• Workplace Intelligence
• The Benefits
• The Staff and The Workplace
• Common Mistakes
• Workplace Intelligence: An Overview.

Part One:

• Workplace Dynamics
• When You Left For Work This Morning, What Did You Leave Behind?
• Hostile Working Environment
• Four Generations At Work
• Values And Generational Feedback
• Generational Interaction In The Workplace.

Part Two:

• What Is Organizational Culture?

Exploring Excel

• Finding and using commands
• Moving around a worksheet
• Navigating the workbook

Basic Workbook Skills

• Creating a workbook
• Selecting cells and ranges
• Opening, closing and saving workbooks
• Entering data into cells
• Entering values into ranges

Creating Simple Formulas

• Writing formulas in cells
• Using the Formula Bar
• AutoSum and other basic functions
• The Paste Function tool
• Automatic calculation

Copying And Moving Data

• Copying and cutting data
• Absolute cell references
• Filling cells
• Using drag-and-drop
• Undo and Redo
• Find and Replace

Managing Worksheets

• Naming worksheets
• Copying and moving worksheets
• Grouping worksheets
• Moving data between sheets
• Adding and deleting worksheets
• Creating 3-D formulas

Printing

• Choosing what to print
• Previewing and printing
• Page Setup
• Margins and page orientation
• Headers and footers
• Repeating column/row headings
• Page Break Preview
• Printing gridlines

Formatting Data And Cells

• Formatting numbers
• Formatting text
• Colouring data and cells
• Wrapping and shrinking text
• Merging cells
• Using indents
• Applying borders to cells
• The Format Painter
• Conditional formatting

Working With Columns and Rows

• Selecting columns and rows
• Changing column width and row height
• Hiding and unhiding
• Inserting and deleting

Using Large Spreadsheets

• Changing the magnification
• Full Screen view
• Splitting the window
• Using Freeze Panes

Named Ranges

• Naming a range of cells
• Jumping to a named range
• Using range names in formulas
• Re-defining and deleting range names

Working With Data Series

• Creating a linear series
• Working with Date series
• Using Autofill

Microsoft Excel Intermediate

WORKING WITH FUNCTIONS

• Using the Paste Function tool
• Absolute and relative cell references
• Using range names in functions
• Creating nested functions
• Logical functions (SUMIF, COUNTIF)
• The IF function and nested Ifs using AND and OR conditions Using VLOOKUP
• Financial functions (PMT, NPV)

WORKING WITH DATA

• Using Excel as a database
• Sorting Data
• Custom sorts
• Filtering using AutoFilter
• The Advanced Filter tool
• Database functions
• Using the Data Form to enter data
• Creating subtotals

WORKING WITH EXTERNAL DATA

• Data consolidation
• Linking to another workbook
• Linking to an external database
• Getting data from the web

CHARTING WITH EXCEL

• Selecting the data to chart
• Creating a chart
• Choosing the right chart for the job
• Moving and re-sizing charts
• Customizing charts
• Saving and copying a chart’s design

TABLES

• Creating an Excel table
• Table formatting
• Adding rows and columns
• Automatic calculation in tables

COLLABORATION TOOLS

• Protecting a workbook
• Protecting worksheets and cells
• Adding comments to cells
• Sharing workbooks
• Tracking changes

AUDITING WORKBOOKS

• Viewing formulas
• Tracing precedents and dependents
• Error checking

Microsoft Powerpoint Basic

• Open class training with exercises
• Instructor-led Classroom Training
• Interactive Methods
• Hands-on training
• Computer-based and e-learning Training
• Video/Audio Training
• Coaching and mentoring

Microsoft Powerpoint Intermediate

Key PowerPoint Concepts

• Using PowerPoint’s different views
• Rearranging a presentation in the Slide Sorter and Normal view
• Creating slides with different layouts
• Resetting layouts
• Navigating and selecting using keyboard shortcuts

Customizing PowerPoint

• Customizing the Quick Access Toolbar and adding custom buttons
• Setting important PowerPoint options

Working with Themes

• Applying themes to presentations
• Using font, color, effect and overall themes
• Understanding the difference between themes and templates
• Importing a theme from another presentation or template
• Creating and saving custom font, color or overall themes

Creating and Editing Slide Masters and Layouts

• Editing the slide master and layouts in the Slide Master view
• Changing slide master or layout backgrounds
• Adding footers, dates, slide numbers and logos on the slide master or layouts
• Creating custom slide layouts in the Slide Master view
• Preserving the slide master
• Importing masters from other presentations or templates

Inserting and Formatting Images

• Inserting and resizing images
• Nudging images using keyboard shortcuts
• Cropping images and controlling image placement
• Changing picture brightness and contrast
• Applying a different color to a picture
• Applying special effects
• Removing backgrounds from images in different ways
• Making an image transparent
• Reducing file size by compressing images

• Management Trainee
• Specialist Staff
• Managers
• Management Staff and Directors