Microsoft Excel 2019 (Basic To Intermediate)

by Oaks Training Claim Listing

This 2-days hands-on course covers all the essential basics you will need to enter data and build organized spreadsheets. It also provides guidance on how to create a proper database, organizing your data such that it can be used to work with multiple worksheets.

S$353.1

Contact the Institutes

Fill this form

Advertisement

Oaks Training Logo

img Duration

2 Days

Course Details

This 2-days hands-on course covers all the essential basics you will need to enter data and build organized spreadsheets. It also provides guidance on how to create a proper database, organizing your data such that it can be used to work with multiple worksheets. You will also learn how to format your data appearance, create cell referencing between cells in different worksheets or workbooks.

You will also get to learn the effectiveness of Excel in applying and deriving mathematical results quickly and easily in many day-to-day calculations for reports. This will enable you to be more productive at work through the use of formulas and basic Excel functions to perform many of your routine and mundane calculations. You will also be taught how to use the "Do Things Quickly" feature and discover new chart types in Excel 2019.

A hands-on based course coupled with many hands-on practice opportunities will enforce and enhance your understanding of Microsoft Excel and experience Excel’s automatic updates capabilities to increase your level productivity and accuracy at work.

 

Course Outline:

  • Introduction to Excel 2019
  • Excel 2019 Interface
  • New Feature: Do Things Quickly, New Chart Types
  • Understanding the different types of data
  • Manipulating worksheets
  • Different ways of viewing large amount of data
  • Different types of data formatting
  • How to apply formatting on data based on condition(s) set
  • Different types of calculation operators
  • Create formula to automate work and solve problems
  • Create Excel basic functions
  • Create different types of hyperlink
  • Prepare the worksheet for printing
  • Apply worksheets and workbook protection
  • Excel 2019 Charts
  • Central Branch

    1 Coleman Street #07-11, The Adelphi, Central

Check out more MS Excel courses in Singapore

New Horizons Singapore Logo

Microsoft Visio

Microsoft Visio is an intelligent diagramming and vector graphics application. Visio helps simplify information communication with data-driven visual information including,

by New Horizons Singapore [Claim Listing ]
Aventis Learning Group (ALG) Logo

Microsoft Word Course

MS Words continue to play a prominent Role in people’s Professional & Personal lives. Having the skills to create amazing reports, edit perfectly, format & finalize impressive documents will improve your droductivity & will allow you to produce professional & polished documents.

by Aventis Learning Group (ALG) [Claim Listing ]
Intellisoft Logo

Microsoft PowerPoint 2019 (Basic)

The PowerPoint Training at Intellisoft is very practical, hands-on, and to the point. The PowerPoint trainer will show you how to use the most important features of Microsoft PowerPoint 2019 / 365, and how to apply them to make an impressive presentation.

by Intellisoft
Olygen Logo

Advanced Powerpoint Infographics Masterclass

Many people present assuming attention from the audience. However, in this age of information explosion, audience attention does not come automatically, but needs to be captured & maintained. You cannot just tell what you know, but what is of value to your audience.

by Olygen [Claim Listing ]
Inspigenius Logo

Excel Course For Kids

In this course your child clear the fundamentals of Excel, like, excel interface, creating spreadsheets, entering/editing data, working with formulas, formatting data, excel print options, common excel shortcuts, and visualize data with charts.

by Inspigenius [Claim Listing ]

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