PROFICIENCY IN THE USE OF MICROSOFT OFFICE SUITE: WORD, EXCEL AND POWERPOINT

Live-Online Training: N175,000
Classroom Training: N 215,000
3 - 4 participants: 5% discount
5 or more participants: 10% discount

(Available also for Customised Training by Duration, Venue & Fee)

(PARTICIPANTS MUST BE WITH THEIR COMPUTERS)

Course Contents

INTRODUCING MS WORD

• Quick Access Toolbar
• Word Wrap
• Keyboard Shortcuts
• Page Numbers
• Customise Word
• Headers and Footers
• Spelling and Grammar
• Zoom
• Save a Document
• Printing Options.

Document Presentation

• Apply font attributes
• Control word wrapping
• Apply paragraph formats
• Understand styles
• Format a graphical object
• Insert symbols into a document
• Typography
• Character Spacing
• Text Highlighting
• Set Tabs
• Leaders Characters
• Borders and Shading
• Bullets and Numbers
• Columns
• Text Alignment
• Paragraph Indents
• Line and Paragraph Spacing.

Insert a table

• Using an Excel Worksheet
• Format a table
• Sort and apply formulas to table data
• Convert text to a table
• Sort Formulas and Data.

FOUNDATION EXCEL

• Starting the Excel programme
• What is the Active Cell?
• The Excel cell referencing system
• Entering numbers and text
• Default text and number alignment
• Adding a column of numbers
• Worksheets and Workbooks
• Saving a workbook
• Closing a workbook
• Creating a new workbook
• Opening a workbook
• Switching between workbooks
• Saving a workbook using another name
• Saving a workbook using a different file type

Help

• Getting help
• Searching for Help
• The Help ‘ Table of Contents’
• Printing a Help topic
• Alt key help
• Using Excel Selection Techniques 
• Why are selection techniques important?
• Selecting a cell
• Selecting a range of connecting cells
• Selecting a range of non-connecting cells
• Selecting the entire worksheet
• Selecting a row
• Selecting a range of connecting rows
• Selecting a range of non-connected rows
• Selecting a column
• Selecting a range of connecting columns
• Selecting a range of non-connecting columns
• Manipulating Rows and Columns 
• Inserting rows into a worksheet
• Inserting columns into a worksheet
• Deleting rows within a worksheet
• Deleting columns within a worksheet
• Modifying column widths
• Modifying column widths using ‘drag and drop’
• Automatically resizing the column width to fit contents
• Modifying row heights
• Copying, Moving and Deleting 
• Copying the cell or range contents
• Deleting cell contents
• Moving the contents of a cell or range
• Editing cell content
• Undo and Redo
• AutoFill
• Sorting a cell range
• Searching and replacing data
• Worksheets 
• Manipulating Worksheets 
• Switching between worksheets
• Renaming a worksheet
• Inserting a new worksheet
• Deleting a worksheet
• A worksheet within a workbook
• Moving a worksheet within a workbook
• Copying or moving worksheets between workbooks
• Formatting 

Font Formatting

• Font type
• Font size
• Bold, italic, underline formatting
• Cell border formatting
• Formatting the background colour
• Formatting the font colour

Alignment Formatting

• Aligning contents in a cell range
• Centering a title over a cell range
• Cell orientation
• Text wrapping
• Format painter

Number Formatting 

• Number formatting
• Decimal point display
• Comma formatting
• Currency symbol
• Date styles
• Percentages
• Freezing Row and Column Titles 
• Freezing row and column titles 

Formulas and Functions

Creating formulas

• Easy way to create formulas
• formulas
• Operators
• Formula error messages
• Cell Referencing :
• Relative cell referencing within formulas
• Absolute cell referencing within formulas
• Three Dimensional referencing formulas

Functions

• What is a function?
• Common functions
• Sum function
• Average function
• Max function
• Min function
• Count Function
• What are ‘IF functions’
• Using the IF function

Using Charts

• Inserting a column chart
• Inserting a line chart
• Inserting a bar chart
• Inserting a pie chart
• Resizing a chart
• Deleting a chart
• Chart title or labels
• Chart background colour
• Changing a column, bar, line or pie slice colours
• Changing the chart type
• Modifying Charts using the Layout tab
• Copying and moving charts within a worksheet
• Copying and moving charts between worksheets
• Copying and moving charts between workbooks

Customizing Excel

• Modifying basic options
• Minimizing the Ribbon
• AutoCorrect options
• Printing

Worksheet Setup

• Worksheet margins
• Worksheet orientation
• Worksheet page size
• Headers and Footers
• Header and footer fields
• Scaling your worksheet to fit a page(s)

Preparing to Print a Worksheet

• Visually check your calculations
• Gridline display when printing
• Printing titles on every page when printing
• Printing the Excel row and column headings
• Spell checking
• Previewing a worksheet
• Comparing Workbooks side by side
• Zooming the view
• Printing options.

PROFICIENCY WITH POWERPOINT

• Choosing between using a template or starting from scratch
• The components of a PowerPoint Slide
• Title
• Content
• Image Placeholder
• Footer and Numbering
• Animation
• Using the Slide Master to customize your slides
• Inserting Shapes, Pictures and Videos
• Adding Tables, Charts and Smart Arts like organogram and process flow
• Getting to the presentation mode and using a presenter’s remote

Creating a Presentation

• Add Slides
• Enter Text
• Format Text - Font Styles and Effects
• Adding a Picture
• Adding ClipArt
• Create a Statistical Table
• Convert Statistical Table into Charts
• Slide Show Effects – Transitions

                                  – Slide Animation

                                  – Add colours

• Save a Presentation.

Powerpoint for Reporting Excel Analysis

• Linking PowerPoint Charts to Excel
• Embedding Excel sheets in PowerPoint
• Changing slide orientation Making use of the page ruler, gridlines, and guides
• Using built in arrangement options for multiple text boxes or images
• Inserting shapes and lines as design elements
• Inserting shapes and lines as design elements
• Using fill color and transparency

Copying page design for the whole report