Microsoft Excel 2019 – Basic
Do you often work with data at work or frequently extract data to create reports to update your leaders? Microsoft Excel is a powerful spreadsheet program that allows you to make quick and accurate numerical calculations. You will appear more professional when you present formulated spreadsheets to highlight your key data narratives. ‘Microsoft Excel 2019 – Basic’ is a course that suitable for you if you are new to this application or need a structured training to increase your productivity while working with data.
Why is it so important to learn Excel? It is because almost every organization across all industries are using the Excel to boost their employees’ productivity and quality of work. Many different job roles require some form of Excel knowledge as Excel is one of the most indispensable data processing tools in the working world now.
So what are some applications of Excel? For example, businesses use Excel for the creation of financial reports. Manufacturing plants use Excel for statistical analysis on their inventory. Families use Excel to help manage their family expenses, investment portfolios and retirement savings projections. As you can see, Excel is an essential skill needed by everyone not only for work but also for their personal projects.
In our 2-day ‘Microsoft Excel 2019 – Basic’ course, you will gain the essential skills needed to create, edit and use basic formulas to extract data insights and to format your spreadsheets for printing.
Course Objectives – Microsoft Excel 2019 – Basic
At the end of this course, you will be able to:
- Create simple formulas and recognize when to use absolute and relative references
- Use autofill option and functions such as Sum, Average, Min, Max and Count
- Find and replace content and formats and add cell comments
- Format text and values into different decimal places, currencies and percentages etc.
- Apply protection and print out your worksheets and workbook
- View large databases effectively by sorting and filtering records, freezing panes, and splitting and arranging windows
Participants can also consider attending our Microsoft Excel 2019 – Intermediate course to learn more advanced Excel features to get more out of your data.