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
 
WEX7122 - Eng 18 Dec enrol
 
WEX8013 - 廣東話 06 Jan enrol
 
WEX8014 - Eng 11 Jan enrol
 
WEX8016 - 廣東話 15 Jan enrol
 
WEX8015 - 廣東話 16 Jan 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