Tips and Tricks in Word, Excel and PowerPoint (2010/2016) 2017-09-18T12:10:42+00:00

Project Description

Loading...
Welkin Course Code: OFT0

Course Features

Microsoft Excel, PowerPoint and Word are so commonly used that many people overlook the needs for further training in Microsoft Office usage.  You may have already grasped the basic skills using the applications, but there are always smarter solutions for the same tasks, and hidden functions and commands that enable you to work more efficiently and productively. The course enhances your Office skills with a useful variety of tips and tricks, including:

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

On course completion, you will be able to use Excel, PowerPoint and Word more efficiently and effectively.

  • Qualified and experienced instructors
  • Easy-to-follow, step-by-step instruction

Learn from the Experts

Get Professional Recognition

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 with the CEF reimbursable course Effective Use of Microsoft Office in Business.

Course Fee

$960

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
COURSE INFODATES(dd/mm)TIMEDURATIONDAY(S)AMOUNT
OFT0-17111C
 Central
 Cantonese / PC
10/11~10/11
0930-1230
1400-1700
6 hrs/
2 sessions
FRI960.00
OFT0-17121K
 Mongkok
 Cantonese / PC
19/12~19/12
0930-1230
1400-1700
6 hrs/
2 sessions
TUE960.00
Tips and Tricks in Word, Excel and PowerPoint 2010/2007
Complete your Enrol
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 various tips and tricks to make them an effective user of the Office applications. The course goes beyond the basics to include useful techniques, shortcuts and best practices that will help you work efficiently and productively in everyday’s 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