Jump start your experience in using Microsoft Excel 2019
Course Code: VTLOKEBX9
Duration: 2 Days (14 Hours)
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.
This course is for
Learners with zero to little knowledge of using Microsoft Excel 2019. Also suitable for those who want an update on the basic new features of Excel 2019 or to serve as a refresher of your Excel usage.
- 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
Questions to Ask Yourself
I’m very experienced in using an earlier version of Microsoft Excel; can I skip this course and join the Excel 2019 Advanced course?
Yes, you can but ONLY IF you are very familiar with the Excel 2010 2013 or 2016 user interface.
For Your DelightRefreshments are provided for morning and afternoon tea breaks.
A Certificate of Attendance will be given subject to 90% attendance.
We can tailor this course to suit your needs in terms of course dates, times and location. If you are an organisation, we can further customise the course to meet your training needs and requirements.