Essential Excel Spreadsheet Skills (IT008C)

by The Institute of Singapore Chartered Accountants Claim Listing

It has been said that the 95/5 rule applies in the Excel spreadsheet world. 95% of the users used only 5% of its power. Most users realized that they could further harness the power of Excel if they could have a better handle of its structure, formulas and functions.

S$822.96

Contact the Institutes

Fill this form

Advertisement

The Institute of Singapore Chartered Accountants Logo

img Duration

Please Enquire

Course Details

It has been said that the 95/5 rule applies in the Excel spreadsheet world. 95% of the users used only 5% of its power. Most users realized that they could further harness the power of Excel if they could have a better handle of its structure, formulas and functions. This is much complicated by the incomprehensive jargon and procedures.

Nothing is more powerful than having clear and accurate data to make meaningful and useful decisions about your company, business units, product cycles, sales projections and operating requirements in order to forecast your business futures. This programme is directed at the businessperson who needs to use Excel in their everyday job to improve decision-making and productivity.

 

Programme Outline:

  • Spreadsheet Concept & Structure
  • Effective spreadsheet structure
  • Designing input & output areas
  • Macro designing & the use of subroutines
  • Setting up data test plan Building Basic Formulas
  • Understanding formula basics
  • Controlling the order of precedence
  • Controlling worksheet calculation
  • Working with range names & links in formulas Creating Advanced Formulas
  • Working with arrays
  • Applying data validation rules to cells
  • Using dialog box controls on a worksheet Spreadsheet Calculation Techniques
  • Working with Excel’s functions
  • Building megaformulas with function nesting
  • Using Lookup tables & the If functions
  • Understanding & using NPV, IRR, SPB, DPB, NFV, MIRR, etc
  • Solving circular references Spreadsheet Consolidation & Linking
  • Linking data between worksheets
  • Working with Consolidate interface
  • Interfacing with other applications
  • Working with Pivot Tables & Scenarios Charting Techniques & Presentation
  • Representing data in charts
  • Plotting data interactively
  • Controlling graphic objects Auditing & Debugging
  • Understanding Error values
  • Testing the cell logic
  • Auditing a worksheet
  • Central Branch

    60 Cecil Street, Central

Check out more MS Excel courses in Singapore

St.Hua Private School Logo

Microsoft Excel Essentials

Microsoft Excel is a powerful yet user-friendly spreadsheet software. In this course, you will learn how to input and organize data, use functions to perform calculations, format the appearance of your data and cells, and build stunning charts and PivotTables.

by St.Hua Private School [Claim Listing ]
New Horizons Singapore Logo

Microsoft Word Training

Mastering Microsoft Word is a useful skill for all business professionals. Your Microsoft Word training will also prepare you for a Microsoft Office Specialist certification.

by New Horizons Singapore [Claim Listing ]
James Cook Institute Logo

MS Excel

Understand the concept of spreadsheets and demonstrate the ability to use a spreadsheet application. Our core commitment lies in providing excellent training to unlock our learners’ vast potential, ensuring personal and professional growth.

by James Cook Institute [Claim Listing ]
Intellisoft Logo

Microsoft Word 2016 Course (Basic)

At Intellisoft Training, an Approved Training Provides by SSG (formerly WDA Singapore), and a premium partner of ICDL Asia, we take pride in providing you with Quality WSQ Certifications in Microsoft Office – Word, Excel, PowerPoint Training Courses in Singapore.

by Intellisoft
Oaks Training Logo

Microsoft Office 365 PowerPoint

Microsoft Office 365 PowerPoint is the tool you need. PowerPoint is easy to use and equipped with many friendly ready to use features to make you presentation faster and easier, enabling you to be more productive and effective in meetings.

by Oaks Training [Claim Listing ]

© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy