Computer Academy

CERTIFICATE COURSE IN MICROSOFT EXCEL

Enquire Now

Course Information

Schedules
  • 27 Apr 2021 (Tue) - 29 Apr 2021 (Thu) 10:00 AM - 5:00 PM
Registration period
20 Apr 2021 (Tue) - 26 Apr 2021 (Mon)
Price
HKD 3,260
Course Level
Study Mode
Duration
12 Hour(s)
Language
English
Location
Room 603 Dominion Centre, 43-59 Queen's Road East Wanchai, Hong Kong
10 views

Course Overview

Excel is a powerful tool used in most companies. Managements can formulate strategies and decisions on data after being processed and analyzed with Excel. It explains why most companies would like to recruit candidates with good knowledge in Excel. The course is packed with two hottest courses, Excel and Advanced Excel, that can match today's business needs.

 

What you'll learn

Excel Module

  • Understanding Excel's elements
  • Editing techniques
  • Writing formulas
  • File operations
  • Printing worksheets
  • Useful functions
  • Tips in editing a worksheets
  • Understanding address notations
  • Polishing worksheets
  • Number format
  • Exchange files with other applications
  • Styles
  • Managing Records
  • Drawing
  • Charting
  • Using Layout tab

Advanced Excel Module

  • Naming cells and ranges
  • Database
  • Advanced data sorting and subtotal
  • Using database functions
  • Managing multiple worksheets
  • Consolidation with several worksheets
  • Data table
  • Lookup table
  • Document protection
  • File linking
  • Filter and advanced filter
  • Building A Pivottable
  • Manipulating Your Pivottable
  • Conditional format
  • Data validation
  • What-If Analysis
  • Inserting a hyperlink to a workbook
  • Creating and using Macros

 



We use cookies to enhance your experience on our website. Please read and confirm your agreement to our Privacy Policy and Terms and Conditions before continue to browse our website.

Read and Agreed