Current Promotions

PMP Exam Free Preview Session

May 28, 2013 - Tuesday @6:15pm and

June 11, 2013 - Tuesday @ 6:15 pm

 

 

 
 
 
 

Advanced MS Excel 2003


SDF Funding is available to Singapore Companies (For company sponsored candidates).

Course Duration :
2 days

Participants will learn to use Basic & Intermediate Functions of Excel 2003 to improve productivity, enhance spreadsheets with templates, charts, graphics, and formulas and streamline their operational work.

Learn how to automate common tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets, & leverage on Excel’s advanced functionality to streamline their work.


Course Objectives
  • Participants will learn to use Intermediate and Advanced functions of Excel® 2003  to improve productivity, enhance spreadsheets with templates, charts, graphics, and formulas and streamline their operational work.
     
  • They will apply visual elements and advanced formulas to a worksheet to display data in various formats.
     
  • Students will also learn how to automate common tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and leverage on Excel’s advanced functionality to simplify and streamline their day-to-day work.

After Course Completion:

  • After the successful completion of the Intermediate to Advanced Excel Training program, students will be able to: - calculate with advanced formulas. - organize worksheet and table data using multiple techniques. - create and modify charts & graphs. - analyze data using PivotTables and PivotCharts. - insert graphic objects. - customize and enhance workbooks and the Microsoft® Office Excel® environment.
     
  • They will know learn to deploy advanced Excel techniques to increase productivity and improve efficiency by streamlining the workflow. - collaborate with others using workbooks. - audit worksheets. - analyze data. - work with multiple workbooks. - import and export data.
Target Audience
  • This program is best suited for people who use Excel in their day-to-day work, and know the basics fairly well, but would like to extend their knowledge of the more advanced functions of Excel to become more productive and make the most of Excel 2003.
     
  • The course is designed for students would want to learn how sort and filter data, import and export data sets, and analyze data using the rich features provided in Excel. It will impart the necessary skills to create macros, collaborate with others, audit and analyze worksheet data, incorporate multiple data sources, and import and export data.
     
  • In addition, the course is also for students desiring to prepare for the Microsoft Certified Application Specialist exam in Microsoft® Office Excel® 2003, and who already have knowledge of the basics of Excel, including how to create, edit, format, and print worksheets that include charts and sorted and filtered data.
Course Outline

Day 1

Lesson 1: Calculating Data with Advanced Functions & Formulas

1.1 Manage Cell and Range Names
1.2 Calculate Data Across Worksheets
1.3

Using Special Functions like VLOOKUP

1.4

Analyze Data with Logical and Lookup Functions

Lesson 2: Organizing Worksheet and Table Data

2.1 Create and Modify Tables
2.2

Format Tables in Excel

2.3

Sort or Filter Worksheet or Table Data

 

Lesson 3: Importing and Exporting Data

3.1

Export Excel Data

3.2

Import a Delimited Text File

 

Lesson 4: Presenting Data Using Charts

4.1

Create a Chart

4.2

Modify Charts to make information more presentable

4.3

Format Charts for Clarity

Lesson 5: Analyzing Data Using PivotTables and PivotCharts

5.1

Create a PivotTable Report

5.2

Analyze Data Using PivotCharts

Day 2

Lesson 6: Collaborating with Others

6.1

Protect Files

6.2 Share a Workbook
6.3

Set Revision Tracking

6.4 Review Tracked Revisions
6.5

Merge Multiple Workbooks

6.6

Restrict Document Access

Lesson 7: Auditing Worksheets

7.1

Trace Cells

7.2

Troubleshoot Errors in Formulas

7.3

Troubleshoot Invalid Data and Formulas

7.4

Watch and Evaluate Formulas

7.5

Create a Data List Outline

Lesson 8: Working with Multiple Workbooks

8.1

Create a Workspace

8.2

Consolidate Data

8.3

Link Cells in Different Workbooks

8.4

Edit Links

Lesson 9: Streamlining Workflow

9.1

Create a Macro

9.2

Edit a Macro

9.3

Apply Conditional Formatting in Excel

9.4

Update a Workbook's Properties

9.5

Modify Excel's Default Settings


How to Register

To claim SDF Funding of $32 for this training, you must register for the training at the SkillsConnect website. This SDF funding is available to ALL companies registered in Singapore. The funding is not available to individuals - only available if you apply through your company.

Simply Register Online, and book your seat today. Or send an online enquiry if you have any questions. You can call us at (65) 6296-2995.

Call Kamini at (65) 9066-9991 or email to training@intellisoft.com.sg for any questions, or to register for the upcoming Advanced Excel 2003 class.

Intellisoft System Facebook Link Intellisoft System Linkedin Link Intellisoft System Youtube Link Intellisoft System Twitter Link Intellisoft System Blog Link

Course Enquiry

Select Your Course *
Course Date*
Sponsored*
Full Name*
Address*
Telephone*
Fax
Email*  
Pass Type
No. of Participants*
Our Clients
Mindef Singapore Ministry of Manpower Nanyang Polytechnic National Heart Center Singapore National University Hospital NUS PSB Academy Richemont Standard Chartered Bank Singapore Polytechnic Singapore Land Authority StatsChipPac ST Electronics The RITZ Carlton At Sunrice AXA BNY Mellon Guthre HDB Johnson Control JTC Marina Bay Sands National Park Paypal Semdcorp Vodaphone Xilinx

 

Excel Training Testimonials

I learnt many new tips and techniques to cut down my time in using Excel - Manager, Diethelm Travel

 

Thanks for the excellent training material and step-by-step instructions. The trainer was very knowledgeable about Excel and answered all my questions patiently. - Sentosa Leisure Group.

The greatest strength of this workshop is the handson approach, and a bubbly trainer, which makes the training session much more enjoyable - Changi Airport Group.

Able to apply VLookup, Macros and Pivot Tables easily - M1

Improved my job productivity by 75% - ITE

Exercises and examples to help us understand the functions of Excel, and the pace is good - not too fast and not too slow - Vestas