Excel Training Course

Excel Training Course

Excel課程如您是沒有Excel經驗或知識的人仕,本課程便是您入門首選。本課程是從初學者的角度而設計的。 它涵蓋了最常用的功能,例如數據輸入,編寫計算程式,Excel功能表內的功能,優化報告格式,列印文件設置和圖表製作。由我們提供的練習易於練習及實用,更能實踐日常工作運作。並且我們是小班教學,令學員更有充足時間發問問題。

在課堂上,您將探索基本知識以外的Excel功能。 成功完成培訓後,您可以期望創建新的工作表更有效率。

Excel Training Course

What you’ll learn

Understanding Excel's elements

  • Workbooks, worksheets, cells, formula bar etc.

Editing techniques

  • Cells selection
  • Data entry
  • To insert a row
  • To delete a row
  • Undo
  • copying a range of cells
  • Moving a range of cells
  • Using paste special
  • Clearing cell contents

Writing formulas

  • Constructing formulas
  • Using operators (+,-,x, ¸,etc...)
  • Using references
  • Tips on entering formulas

File operations

  • Saving workbooks
  • Save as...
  • Save
  • Closing workbooks
  • Deleting workbooks

Printing worksheets

  • Using print preview
  • Page setup
  • Header and footer settings
  • Margin settings
  • Turning the gridlines on or off
  • Turn the row/column heading on or off
  • Auto scaling printout
  • Setting manual page breaks
  • Setting row or column titles
  • Setting print area

SCHEDULES
 
WEX0119 - Eng 13 Nov enrol
 
WEX01112 - 廣東話 16 Nov enrol
 
WEX01111 - 廣東話 28 Nov enrol
 
WEX01110 - 廣東話 30 Nov enrol
 
WEX01212 - 廣東話 15 Dec enrol
RELATING COURSES
  Excel VBA
  Excel Dashboards and Reports
  Excel-Advanced
  Excel-formulas & functions
  Financial Accounting with Excel
  Mastering Excel PivotTables and PivotCharts

Useful functions

  • SUM( )
  • AVERAGE( )
  • MAX( )
  • MIN( )
  • IF()
  • Count()

Tips in editing a worksheets

  • Paste insert row/column
  • Drag and drop
  • Autofill
  • Fill down
  • Fill right

Understanding address notations

  • Relative address
  • Absolute address

Polishing worksheets

  • Adding border
  • Adjusting row heights and column widths manually
  • Adjusting row heights and column widths automatically
  • Setting text alignments ( horizontal and vertical )
  • Setting text orientations
  • Shading cell background
  • Font settings

Number format

  • Adding thousand separator
  • Adding currency sign number
  • Adding decimal points
  • Creating a master spreadsheet
  • Creating document templates
  • Using document templates

Exchange files with other applications

  • Understanding various Excel file formats
  • Saving workbook for backward compatibility
  • Exporting excel workbook for other software

Styles

  • Creating styles
  • Using styles
  • Editing styles
  • Merging styles from other workbooks

Managing Records

  • Sorting Records
  • Filtering records

Drawing

  • Inserting shapes
  • Drawing lines, rectangles, ovals etc.

Charting

  • Inserting various kinds of chart – column, line, bar and pie chart
  • Adding and modifying chart’s elements
  • Chart title, Legend, Axis, Grids, Data table, Data label
  • Polishing charts
  • Adding special effects to chart elements
  • Filling charts with gradients or pictures

Creating a 3D chart

  • 3D Chart
  • Constructing 3D charts
  • Formatting 3D charts
  • Changing 3D view