On course for success

ADVANCED MICROSOFT EXCEL

This course will guide participants through Excel’s features such as creating and editing charts; modifying chart options; working with multiple worksheets and workbooks, and use financial and logical functions. Participants will also gain hands-on experience using styles, custom formats, and conditional formatting. This course also introduces Microsoft Excel users to the advanced features of the software application. Participants will learn how to sort and manage data in lists; filter and query data; lookup and database functions, and PivotTables. In-class exercises will involve the use of data tables and scenarios to make projections about data and use Goal Seek and Solver to analyze data. Participants will also learn how to audit worksheets, protect worksheets and workbooks, create and use macros, and import and export information and documents.

 

LEARNING OUTCOME

  • Create, edit and modify charts
  • Use styles, custom formats, and conditional formatting
  • Use financial and logical functions
  • Work with multiple worksheets and workbooks
  • Manage data in lists
  • Filter and query data
  • Use data outlines on worksheets
  • Use lookup and database functions
  • Use Pivot Tables to display and chart data
  • Use data tables & scenarios to make projections
  • Analyze data and audit worksheets
  • Work with Macros to automate database functions
  • Protect data for worksheets and workbooks
  • Import and export information and documents

 

TRAINER PROFILE 

Joshua have been interested in IT since the mid-1990’s when he taught himself how to build websites. Since then he have gone on to earn an Honors degree in Information Systems from the National University of Singapore, conducted research on Information Seeking habits in Japan and started his own business in Brunei specializing in website-building and online solutions.
Over the years he have had the opportunity to conduct training workshops to impart valuable skills to Bruneians. Most of them have been IT-related but his interest in Performance, Creativity and Human Development has also allowed him to conduct workshops ranging from Improvisation to Facilitation.

IT Training Portfolio:

  • ICDL Digital Literacy – 4 Modules (Computer Essentials, Online Essentials with Internet Explorer, Word Process with Microsoft Word, Spreadsheets with Microsoft Excel) (2013, May)
  • ICDL Digital Literacy – 4 Modules (Computer Essentials, Online Essentials with Internet Explorer, Word Process with Microsoft Word, Spreadsheets with Microsoft Excel) (2013, Aug)
  • Macromedia Dreamweaver MX 2004 (2007, Sep)
  • Paintshop Pro 9 (2007, Sep)
  • SmartDraw 7 Suite (2007, Sep)
  • OmniPage Pro 14 (2007, Sep)
  • Macromedia Dreamweaver MX 2004 for Ministry of Development (2007, Jun–Aug)
  • Microsoft Excel 2003 for Ministry of Development (2007, Jun–Dec)
  • Taught CS114, Programming Project for Cosmopolitan College HND students (2007, Sep–Nov)
  • Conducted multiple training sessions for ICDL Test Centres under Bitex Sdn. Bhd. (2006-2007)
  • Conducted over 15 training sessions to teach clients how to update their websites (2010-2017)

 

Download Brochure
Location Map
▲ Top