Tips and Tricks in Word, Excel and PowerPoint (2016/2010) 2018-01-19T17:37:36+00:00

Project Description

Loading...
Welkin Course Code: OFT0

Course Features

This course is designed for Microsoft Office users who know the basics of Word, Excel and PowerPoint but want to acquire useful tips and tricks to make them an effective business user of the Office applications. In the course, you will go beyond the basics and learn a variety of useful techniques, shortcuts, and best practices that will help you work smarter and increase productivity in everyday business tasks. The course covers the following features:

  • Formatting and document tricks
  • Page layout features
  • Workbook and worksheet tricks
  • Slide and presentation tricks

Knowing these features will allow you to work more efficiently and effectively with the Office applications.

  • Qualified and experienced instructors
  • Easy-to-follow, step-by-step hands-on learning approach

Learn from the Experts

Get Your Skills Certified

mos-certificate

Certify your Microsoft Office skills with Microsoft Office Specialist certification. The certification is not a requirement for course completion but we highly recommend you to get your skills professionally recognized.

Remark: The course fee does not include the certification exams.

Further Study

After completing this course you may further develop your knowledge and skills in Microsft Office with the CEF reimbursable course Effective Use of Microsoft Office in Business.

Course Fee

$1100

Course Duration

6 Hours

Course Prerequisites

Course participants should have a basic knowledge of Microsoft Office.

Title of Award

Upon successful completion of the course, students will receive a Certificate of Achievement.

Schedule & Online Enrolment
Enquiry/Booking
Tips and Tricks in Word, Excel and PowerPoint 2010/2007
COURSE INFODATES(dd/mm)TIMEDURATIONDAY(S)AMOUNT
OFT0-18081K
 Mongkok
 Cantonese / PC
22/8~22/8
0930-1230
1400-1700
6 hrs/
2 sessions
WED1,100.00
OFT0-18091C
 Central
 Cantonese / PC
18/9~18/9
0930-1230
1400-1700
6 hrs/
2 sessions
TUE1,100.00
OFT0-18101K
 Mongkok
 Cantonese / PC
18/10~18/10
0930-1230
1400-1700
6 hrs/
2 sessions
THU1,100.00
OFT0-18111K
 Mongkok
 Cantonese / PC
28/11~28/11
0930-1230
1400-1700
6 hrs/
2 sessions
WED1,100.00
OFT0-18121C
 Central
 Cantonese / PC
11/12~11/12
0930-1230
1400-1700
6 hrs/
2 sessions
TUE1,100.00
Tips and Tricks in Word, Excel and PowerPoint 2010/2007
Complete your Enrolment
How to enrol/pay online

This course is designed for Microsoft Office 2016/2010 users who know the basics of Word, Excel and PowerPoint but want to acquire useful tips and tricks to make them an effective business user of the Office applications. In the course, you will go beyond the basics and learn a variety of useful techniques, shortcuts, and best practices that will help you work smarter and increase productivity in everyday business tasks.

  1. Formatting Tricks
    • Quickly Modifying the Normal Style
    • Setting Up the Quick Style Gallery to Suit the Way You Work
    • Selecting Text with Similar Formatting
    • Copying Formatting from One Section to Another
    • Comparing the Formatting of Two Text Selections
    • Removing Formatting with Precision
    • Replacing One Style with Another
    • Applying Formatting from the Keyboard
    • Specifying a Custom Bullet Image
    • Creating an Inline Numbered List
    • Converting Uppercase Words to Another Case
    • Ensuring Consistent Document Formatting
  2. Document Tricks
    • Showing More Items on the Recent Documents List
    • Clearing the Recent Documents List
    • Locking Document Formatting
    • Viewing Two Documents Side by Side
  3. Page Layout Tricks
    • Creating a Custom Watermark
    • Displaying Text with Line Numbers
    • Using Continuous Numbers in Two Separate Numbered Lists
    • Using Multiple Page Number Formats in the Same Document
    • Making the First Page Header and Footer Unique
    • Using Different Odd and Even Page Headers
  4. Workbook and Worksheet Tricks
    • Applying Text or Formatting to Multiple Worksheets
    • Keeping Track of Worksheet Changes
    • Sharing a Workbook with Other Users
    • Preventing Users from Changing Parts of a Worksheet
    • Transposing Range Rows and Columns
  5. Data Analysis Tricks
    • Calculating Multiple Solutions to a Formula
    • Plugging Multiple Input Values into a Formula
    • Determining the Break-Even Point
    • Highlighting Cells Above or Below a Certain Value
    • Highlighting Values Below the Median
    • Analyzing Cell Values with Data Bars
    • Applying Percentile-Based Icon Sets
  1. Chart Tricks
    • Plotting the Average on the Value Axis
    • Stacking a Picture as a Bar Chart Data Marker
    • Charting a Dynamic Range
    • Automatically Expanding a Chart to Include New Data
    • Displaying a Second Vertical Axis
    • Charting Small Values with a Bar of Pie Chart
    • Creating a Scrolling Chart
    • Plotting a Best-Fit Trendline
    • Plotting Forecasted Values
  2. Slide and Presentation Tricks
    • Converting a Word Outline into a PowerPoint Presentation
    • Creating Custom Bullets
    • Replacing Fonts Throughout a Presentation
    • Recoloring a Picture to Match Your Presentation
    • Creating a Custom Slide Layout
    • Hiding a Slide Master Object on One Slide
    • Using Multiple Slide Masters
  3. Animation Tricks
    • Making Bullets Display Individually
    • Animating Chart Elements
    • Animating an Organization Chart
    • Uncovering Parts of an Image, One at a Time
    • Playing a Video to Introduce a Slide
    • Emphasizing the Current Bullet Point
  4. Slide Show Tricks
    • Adding Narration to a Slide Show
    • Setting Up an Automatic Slide Show
    • Playing CD Tracks During a Slide Show
    • Controlling a Slide Show from the Keyboard
  1. Formatting Tricks
    • Quickly Modifying the Normal Style
    • Setting Up the Quick Style Gallery to Suit the Way You Work
    • Selecting Text with Similar Formatting
    • Copying Formatting from One Section to Another
    • Comparing the Formatting of Two Text Selections
    • Removing Formatting with Precision
    • Replacing One Style with Another
    • Applying Formatting from the Keyboard
    • Specifying a Custom Bullet Image
    • Creating an Inline Numbered List
    • Converting Uppercase Words to Another Case
    • Ensuring Consistent Document Formatting
  2. Document Tricks
    • Showing More Items on the Recent Documents List
    • Clearing the Recent Documents List
    • Locking Document Formatting
    • Viewing Two Documents Side by Side
  3. Page Layout Tricks
    • Creating a Custom Watermark
    • Displaying Text with Line Numbers
    • Using Continuous Numbers in Two Separate Numbered Lists
    • Using Multiple Page Number Formats in the Same Document
    • Making the First Page Header and Footer Unique
    • Using Different Odd and Even Page Headers
  4. Workbook and Worksheet Tricks
    • Applying Text or Formatting to Multiple Worksheets
    • Keeping Track of Worksheet Changes
    • Sharing a Workbook with Other Users
    • Preventing Users from Changing Parts of a Worksheet
    • Transposing Range Rows and Columns
  5. Data Analysis Tricks
    • Calculating Multiple Solutions to a Formula
    • Plugging Multiple Input Values into a Formula
    • Determining the Break-Even Point
    • Highlighting Cells Above or Below a Certain Value
    • Highlighting Values Below the Median
    • Analyzing Cell Values with Data Bars
    • Applying Percentile-Based Icon Sets
  1. Chart Tricks
    • Plotting the Average on the Value Axis
    • Stacking a Picture as a Bar Chart Data Marker
    • Charting a Dynamic Range
    • Automatically Expanding a Chart to Include New Data
    • Displaying a Second Vertical Axis
    • Charting Small Values with a Bar of Pie Chart
    • Creating a Scrolling Chart
    • Plotting a Best-Fit Trendline
    • Plotting Forecasted Values
  2. Slide and Presentation Tricks
    • Converting a Word Outline into a PowerPoint Presentation
    • Creating Custom Bullets
    • Replacing Fonts Throughout a Presentation
    • Recoloring a Picture to Match Your Presentation
    • Creating a Custom Slide Layout
    • Hiding a Slide Master Object on One Slide
    • Using Multiple Slide Masters
  3. Animation Tricks
    • Making Bullets Display Individually
    • Animating Chart Elements
    • Animating an Organization Chart
    • Uncovering Parts of an Image, One at a Time
    • Playing a Video to Introduce a Slide
    • Emphasizing the Current Bullet Point
  4. Slide Show Tricks
    • Adding Narration to a Slide Show
    • Setting Up an Automatic Slide Show
    • Playing CD Tracks During a Slide Show
    • Controlling a Slide Show from the Keyboard
  1. Proceed with on-line registration or send the completed enrolment form (download) to us together with a cheque (made payable to Welkin Compuer Training) for the program fee.
  2. CEF applicants have to complete the CEF Application Form (download) and send it to us for certification. They will then send the form to the Office of the Continuing Education Fund, Room 916, 9/F, Kwai Hing Government Offices, 166-174 Hing Fong Road, Kwai Chung, New Territories, together with a photocopy of their HKID Card before course commencement.
  3. Applicants will receive application results from the Office of the CEF within 14 working days.

 

You may also be interested in