Excel Training Course

Excel Training Course

The Excel training course should be the first course for participants they have no prior experience or little knowledge in Excel. The course is designed from the perspective of beginners. It covers the most essential features such as data entry, building equations with Excel's functions, formatting reporting, print settings and charting. You will find our easy to follow exercises useful and also benefit from our small class size teaching approach.

In the class, you will explore Excel activities that go beyond the basic. After successful completion of the training, you can expect to have the skills required to work efficiently in an existing worksheet and to also create new worksheets from scratch.

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
 
WEX0026 - Eng 04 Feb enrol
 
WEX0027 - 廣東話 19 Feb enrol
 
WEX0038 - Eng 04 Mar enrol
 
WEX00310 - 廣東話 13 Mar enrol
 
WEX0039 - 廣東話 23 Mar enrol

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