Microsoft Excel for Beginners/Advanced Users

Microsoft Excel is the world's most widely-used spreadsheet application. It is a necessary tool for office professionals in any fields of work. It allows the easy manipulation and analysis of data, and is therefore a very useful tool in preparing financial budgets and forecasts. You can also use Excel to produce professional-looking charts and reports.

Microsoft Excel for Beginners is a 6-hour course targeting beginners as well as intermediate users. It begins with the necessary basic skills and covers a wide range of intermediate level topics. No matter you are new to Excel or you know a little bit of Excel, this is the right course for you. You may click on the Outline button for the course in the table below to understand more about the course topics.

You will Learn

  • Basic operations of workbooks, worksheets, rows, columns and cells.
  • Creating worksheets for entering and organizing data in an efficient way and to setup linkages between workbooks for co-authoring
  • Using Excel functions to summarize data
  • Formatting reports for presentation
  • Searching for information in workseets by using the sorting and filtering functions effectively
  • Creating headers and footers and customizing print setup
  • Working with multiple documents

Microsoft Excel for Advanced Users is a 6-hour course focusing on the advanced features of Excel such as data management, data analysis, macro, customization, data import/export, data protection, etc. Please take a look at the course content by clicking on the relevant Outline button in the course table below.

You will Learn

  • Advanced Excel functions to consolidate data to meet business criteria
  • Co-authoring documents by enabling document sharing and track changes
  • Searching and analyzing data with advanced criteria
  • Preparing reports by grouping and consolidation techniques
  • Advanced Data presentation by using conditional formatting and charts
  • Exchanging data between software by using plain text files
  • Allowing users to input correct data by applying validation rules
  • Protecting documents with passwords
  • An overview of task automation by using Macros

Course Outline/Schedule/Enrol

Course Title Duration Fee Outline/Schedules/Enrol
Microsoft Excel 2016 for Beginners 6 hours $960 Outline Schedules/Enrol
Microsoft Excel 2016 for Advanced Users 6 hours $960 Outline Schedules/Enrol
Microsoft Excel 2013 for Beginners 6 hours $960 Outline Schedules/Enrol
Microsoft Excel 2013 for Advanced Users 6 hours $960 Outline Schedules/Enrol
Microsoft Excel 2010/2007 for Beginners 6 hours $960 Outline Schedules/Enrol
Microsoft Excel 2010/2007 for Advanced Users 6 hours $960 Outline Schedules/Enrol

© Welkin Systems Limited. All rights reserved.