Microsoft Excel Advanced Training in Hong Kong

  • Learn via: Classroom
  • Duration: 2 Days
  • Price: Please contact for booking options
We can host this training at your preferred location. Contact us!

In this course, you will extend your knowledge into some of the more specialised and advanced capabilities of Excel by automating some common tasks, applying advanced analysis techniques to more complex data sets such as PivotTables, and importing and cleaning data.

The course emphasises hands-on experience, with a series of self-guided exercises integrated into the training.

  • Create, edit, and format spreadsheets
  • Navigate within worksheets and books
  • Use Insert Function to create built-in functions
  • Work with absolute references
  • Create named ranges
  • Create Tables within Excel
  • Sort and filter data

  • Use macros to automate repetitive tasks
  • Setup workbooks to collaborate with other users
  • Create and build PivotTables to analyse data
  • Write array and advanced lookup functions
  • Use ‘what-if’ analysis tools
  • Use data validation
  • Import external data into Excel workbooks

Module 1: Creating macros

  • Introducing macros
  • Creating macros
  • Relative and absolute macros
  • Running and editing a macro
  • Assigning shortcuts
  • Macro security

Module 2: Collaborating with others

  • Protecting data, workbook structure and files
  • Checking for collaboration issues
  • Marking workbooks as final

Module 3: PivotTables

  • What is a PivotTable?
  • Creating and modifying PivotTables
  • Calculations in PivotTables
  • Grouping fields
  • Slicers and Timelines
  • Creating PivotCharts
  • PivotTables and related sources

Module 4: Array formulas

  • What is an array?
  • Array formulas
  • Array functions
  • Single and multiple cell arrays

Module 5: Further lookup and reference functions

  • VLOOKUP and HLOOKUP
  • GETPIVOTDATA
  • MATCH and INDEX
  • XLOOKUP (Excel 365 only)

Module 6: Analysing data

  • Input data tables
  • Worksheet scenarios
  • Goal Seek
  • Consolidating data
  • Linking to external workbooks

Module 7: Data validation

  • Setting up data validation
  • Message prompts and alerts
  • Conditional data validation
  • Data validation errors

Module 8: Importing data

  • Importing delimited files
  • Importing data with a web query
  • Refreshing data

Contact us for more detail about our trainings and for all other enquiries!
Blog posts related to Microsoft Excel Advanced Training in Hong Kong

2020 PROJECT MANAGEMENT TRENDS

Are you aware of 2020's Project Management trends? If not, you are in the right place! Read our article "2020 Project Management Trends" to find out

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.

06 January 2025 (2 Days)
Hong Kong, Kowloon, Tsuen Wan
Classroom / Virtual Classroom
23 January 2025 (2 Days)
Hong Kong, Kowloon, Tsuen Wan
Classroom / Virtual Classroom
06 January 2025 (2 Days)
Hong Kong, Kowloon, Tsuen Wan
Classroom / Virtual Classroom
03 February 2025 (2 Days)
Hong Kong, Kowloon, Tsuen Wan
Classroom / Virtual Classroom
23 January 2025 (2 Days)
Hong Kong, Kowloon, Tsuen Wan
Classroom / Virtual Classroom
19 February 2025 (2 Days)
Hong Kong, Kowloon, Tsuen Wan
Classroom / Virtual Classroom
03 February 2025 (2 Days)
Hong Kong, Kowloon, Tsuen Wan
Classroom / Virtual Classroom
10 March 2025 (2 Days)
Hong Kong, Kowloon, Tsuen Wan
Classroom / Virtual Classroom
Microsoft Excel Advanced 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.

Bilginç IT Academy All Rights Reserved

By using this website you agree to let us use cookies. For further information about our use of cookies, check out our Cookie Policy.