Microsoft Excel Essentials Training in Hong Kong

  • Learn via: Classroom
  • Duration: 1 Day
  • Level: Fundamentals
  • Price: From €728+VAT
We can host this training at your preferred location. Contact us!

In this course you’ll create and edit basic Microsoft Office Excel worksheets and workbooks. This course emphasises hands-on experience, with a series of self-guided exercises integrated into the training manual.

  • Use of mouse and keyboard
  • Ability to navigate the Windows environments
  • Open and close programs

At the end of this course, you’ll be able to:

  • Get started with Excel
  • Create calculations with formulas and functions
  • Modify a worksheet
  • Format an Excel worksheet
  • Work with Data Lists
  • Manage worksheets and workbooks
  • Print workbooks

Module 1: Getting started with Excel

  • What is Microsoft Excel?
  • Excel and the Excel environment
  • Navigating and selecting cells in worksheets
  • Creating a new workbook
  • Saving your work
  • Opening and closing workbooks
  • Using Help

Module 2: Modifying a worksheet

  • Cut, Copy and Paste commands
  • Undo and Redo commands
  • Using AutoFill
  • Working with rows and columns
  • Find and Replace
  • Performing a spell check

Module 3: Creating calculations with formulas and functions

  • Creating formulas
  • AutoCalculate
  • Inserting functions and using AutoSum
  • Using functions to round values
  • Copying a formula
  • Creating an Absolute formula
  • Dynamic array formulas

Module 4: Formatting an Excel worksheet

  • Text formatting
  • Add borders and colours to cells
  • Cell alignment
  • Number formatting
  • Format Painter
  • Cell styles and galleries

Module 5: Working with data lists

  • Creating an effective list
  • Applying basic sorting
  • Applying basic filters

Module 6: Managing worksheets and workbooks

  • Managing Worksheets
  • Freezing rows and columns
  • Splitting the screen
  • Arrange All command
  • View Side by Side

Module 7: Printing workbooks

  • Print Preview
  • Setting the Print Area
  • Repeating titles on Each Page
  • Manual page breaks
  • Page Layout View
  • Add page headers and footers



Contact us for more detail about our trainings and for all other enquiries!

Upcoming Trainings

Join our public courses in our Hong Kong facilities. Private class trainings will be organized at the location of your preference, according to your schedule.

Classroom / Virtual Classroom
28 May 2024
Hong Kong, Kowloon, Tsuen Wan
€728 +VAT Book Now
Classroom / Virtual Classroom
11 June 2024
Hong Kong, Kowloon, Tsuen Wan
1 Day
Classroom / Virtual Classroom
14 June 2024
Hong Kong, Kowloon, Tsuen Wan
€728 +VAT Book Now
Classroom / Virtual Classroom
24 June 2024
Hong Kong, Kowloon, Tsuen Wan
€728 +VAT Book Now
Classroom / Virtual Classroom
12 July 2024
Hong Kong, Kowloon, Tsuen Wan
€728 +VAT Book Now
Classroom / Virtual Classroom
25 July 2024
Hong Kong, Kowloon, Tsuen Wan
€728 +VAT Book Now
Classroom / Virtual Classroom
16 August 2024
Hong Kong, Kowloon, Tsuen Wan
€728 +VAT Book Now
Classroom / Virtual Classroom
27 August 2024
Hong Kong, Kowloon, Tsuen Wan
€728 +VAT Book Now

Related Trainings

Microsoft Excel Essentials Training Course in Hong Kong

Hong Kong is officially known as the Hong Kong Special Administrative Region of the People's Republic of China (HKSAR) and is a city and special administrative region of China on the eastern Pearl River Delta in South China. Hong Kong is one of the most densely populated places in the world, with over 7.5 million population. The official languages of the HKSAR are Chinese and English. Hong Kong is a highly developed territory and ranks fourth on the United Nations Human Development Index and the residents of Hong Kong have the highest life expectancies in the world.

The best time to visit Hong Kong is from September to December, since the temperatures, averaging between 19 to 28 degree Celsius. During this outdoor activities-friendly travelling season, you can take a walk along Victoria Harbour, visit the islands of Lantau, Lamma and Cheung Chau and participate in the Mid-Autumn Festival. Top choices of the tourists to visit in Hong Kong are Big Buddha statue, Wong Tai Sin Temple, Repulse Bay and the Beaches and Hong Kong Disneyland.

Explore our diverse range of IT courses, encompassing programming, software development, cyber security, data science, business skills, and Agile/Scrum. Wherever you are in Hong Kong, our seasoned instructors will bring practical training and expert knowledge to your preferred training venue.
By using this website you agree to let us use cookies. For further information about our use of cookies, check out our Cookie Policy.