Month | Date | Duration | Cost | Location | Make a Booking |
---|---|---|---|---|---|
July | 6th-10th | 5 Days | ₦ 262,500 | Lagos | Click to Book |
August | 17th-21th | 5 Days | ₦ 262,500 | Lagos | Click to Book |
September | 7th- 11th | 5 Days | ₦ 262,500 | Lagos | Click to Book |
October | 5th-9th | 5 Days | ₦ 262,500 | Lagos | Click to Book |
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
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
- Course Overview
-
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
- Learning Objectives
-
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
- Program Outline
-
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
- Target Audience
-
- Management Trainee
- Specialist Staff
- Managers
- Management Staff and Directors