PROFICIENCY IN THE USE OF MICROSOFT OFFICE SUITE: WORD, EXCEL AND POWERPOINT
Live-Online Training: N188,125
Classroom Training: N 279,500
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
DAY ONE
Word Processing Proficiency
- Customise Microsoft Word
- Use features that help readability
- Check spelling and grammar
- Display a document in different views
- Modify document properties
- Quick Access Toolbar
- Keyboard Shortcuts
- Page Numbers
- Headers and Footers
- Zoom
- Save a Document
- Printing Options.
DAY TWO
Word Document Presentations
- 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.
DAY THREE
Fundamentals Of Microsoft Excel
- Defining Spreadsheet
- Understanding The Menus
- A snapshot
- Home Menu
- Insert Menu
- Page Layout Menu
- Formulas Menu
- Data Menu
- Review Menu
- View Menu
- How Excel Handles What You Type
- Data in Excel
- How Are Charts Made
- Column Chart
- Line Chart
- Pie Chart
- Bar Chart
- Sorting and Filtering for Report Making
- Sorting
- Filtering
- Freezing Panes for Report Viewing
DAY FOUR
- PivotTable
- Removing Duplicates
- Text-to-Columns
- In-built Functions Usage
- Sub Total Application
- Data Control & Manipulation
- Use Data Analysis Tool
- Sumproduct Application
- Probe Panel
- Data Validation AndVlookup Function
- If-Analysis
- What-If-Analysis
- Goal Seek
- Index and Match
DAY FIVE
Creating Great PowerPoint Slides
- 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
- Where to get images
- Flickr
- Getty Images
- Other image libraries
- Where to get high quality stunning templates
- Templates for business proposals
- Templates for marketing plans
- Templates for social media marketing
- Templates for performance reports
- Templates for Strategy presentation.