Home All Courses Excel Courses 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.

Enrolment Schedules

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

WEX41013 - 廣東話

24 Oct

WEX41016 - 廣東話

25 Oct

WEX41114 - Eng

04 Nov

WEX41115 - 廣東話

12 Nov

WEX41116 - 廣東話

20 Nov


RELATING COURSES


		Excel VBA X ChatGPT/GPT

		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