Excel allows users to sort and filter data, which are then displayed as visual presentation for us to analyse and generate business reports and marketing materials.
What Am I Going To Get Out Of This Course?
Microsoft Excel is one of the greatest, most powerful and most utilized software applications in the workplace. It is an essential tool used in all organisations. This course is specially tailored to meet workplace requirements on the use of Excel. This 1 day all-you-need-to-know workshop helps beginners acquire theoretical and gain hands-on experience in the key functions of Excel and apply them in the work environment, improving workplace productivity.
1. Introduction to Excel
- Navigation of Excel Spreadsheet
Microsoft Excel is a very powerful tool to manage, organize, analyze and present data in the workplace. In order to reap the maximum benefits fromExcel, user requires a good understanding of how to navigate the workbook
- Fill, Auto Fill, Referencing
Understanding the concepts of Fill, Autofill and Referencing allows users to reduce errors and time spent on the spreadsheet
- Text, Values and Formulas
Differentiating between Text, Values and Formulas allows users to select the correct for of input for each cell
2. Data Visualization Basics
- Pie, Line, Column, Bar Charts
Draw on the many different tools for creating charts and graphs, allowing you to visualize data in whatever format and style you want
- Scatter and Bubble Chart
Present your data in a way that’s easy to understand and also visually impressive
3. Common Functions
- Arithmetic Functions
The most commonly used functions in the workplace
- Conditional Functions
Associated with managing and processing of data
- Other Common Functions in the workplace
Reduce time spent on processing data with these functions!
4. Time and Date
- Time & Date Functions
Almost all projects and applications in Excel use dates and times in some way. A lack of understanding in Excel’s Time and Date functions can often lead to confusion, and it prevents users from benefiting from a whole range of useful operations and formulas involving Excel dates and times.
5. Lookup Functions
One of the most powerful functions
Allows user to sieve through large amounts of data in minutes
- Index & Match
Identify only the relevant data in a sea of data and provide further avenue for analysis on data
6. Conditional Formatting
- Conditional Formatting
Identify important data based on certain rules/criterias. Mainly used as a tracking mechanism/function to identify deadlines
Excel Benefits & Features
Microsoft Excel is an electronic spreadsheet program used to storing, organizing and manipulating data. This computer software is widely used in many workplace today. Many employer require their employees to have knowledge in this field to enter or remain in their workplace. Here we look at the top benefits and features of how Microsoft excel can help an individual stay competitive in the work field.