Project Description

Loading...

Welkin Course Code: OFT6, 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 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 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
Sign up for your course by clicking the Enrol button and proceed to Checkout to finish course registration.

Tips and Tricks in Word, Excel and PowerPoint 2016
Course No. 課程編號Info. 語言/系統/地點Start 開課日End 完課日Day(s) 上課日Time 上課時段Duration 課程長度Enrol 報名
OFT6-19111KCantonese / PC / MongKok19-Nov19-NovTUE0930-1230;1400-17006 hours / 2 sessions20191119

$1,100Enrol

OFT6-19121CCantonese / PC / Central12-Dec12-DecTHU0930-1230;1400-17006 hours / 2 sessions20191212

$1,100Enrol

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. You can enrol this course by our online system, or call (852) 3605 3322 for reservation.

You may also be interested in