Excel is one of the most popular tools in all areas of business. Whether you work in Finance, HR, Technology or any other sector, you will most likely be using Excel spreadsheets to store, track, analyse and visualize data. This course will get you started with the essentials and help you become more efficient in your day to day tasks in Excel.

Duration: 1 day

Who is it for: This is an introductory course, suitable for anyone who is new to Excel or for current users who want to work efficiently in Excel, using shortcuts and suitable tools to manage and organize their data

Layout: 1 Day = Live classroom or virtual classroom

Objectives

• This course will teach you all the essentials to help work more effectively in Excel. You will learn how to organize large datasets with Sort and Filter and how to navigate and manage multiple worksheets, using a range of shortcuts. You will also learn formula writing essentials and how to create charts from a dataset.

Modules

Working with Data Efficiently

• Shortcuts keys, tips and tricks for editing and navigating large worksheets
• Formatting text, numbers and dates
• Using Autofill and FlashFill for quick and efficient data entry
• Using Data Validation to ensure data integrity

Organizing Data with Sort and Filter

• Sorting a large dataset (single and multiple column sort)
• Filter a large dataset using Text, Numeric and Date filters

Formula and Function Essentials

• Getting started with formula writing: tips and tricks
• Using Absolute and Relative Referencing in formula writing
• Introduction to Excel Functions (SUM, AVERAGE, MIN, MAX, COUNT)
• Exploring the Function Library with Statistical and Maths Functions (Counting and Rounding functions)

Working with Multiple Worksheets

• Moving, Copying, Hiding worksheets
• Grouping and Editing multiple worksheets
• Linking worksheets
• Consolidating worksheets
• Protecting worksheets

Creating Charts

• Creating a bar or column chart from worksheet data
• Creating a pie chart from worksheet data
• Creating a line chart from worksheet data
• Formatting charts (Titles, Legends, Axis Options)

Enquire about this course

More courses

course

Advanced Analysis and Visualisation in Excel

On this course you will learn about Advanced Filter, Custom Sort, Power Query, Advanced Function writing and What-If Analysis, all invaluable tools to help you work more extensively in Excel.

course

Data Analysis and Visualisation

This course covers the necessary skills to help you perform cleansing, analysing and visualizing large datasets. You will work with pivot tables, conditional formatting and learn how to write some of the most powerful functions in Excel such as VLOOKUP and IF Functions.

course

Introduction to XML Technology

XML is increasingly becoming a critical part of many application architectures. In this training course, we will expose you to XML and the many and various technologies that surround it, such as XML Schemas, XSLT, SAX, DOM, and XPath.

course

Data Wrangling with Python

Learn the basics of the python programming language and Jupyter notebooks. Understand and use the key Python libraries for data manipulation, analysis, and visualization, including Pandas, NumPy, and popular data visualization packages.

course

Python for Enterprise Managers

This is a short and very informative 2 hour overview on what python is and how it can be uses it in various parts of your organization. It will cover the types of roles and job functions where knowledge of python can be a benefit. It will also outline the types of functions and tasks that can be accomplished using python.

course

Python For Finance Professionals

Develop proficiency in employing advanced Python programming techniques for financial modelling, analysis, and risk management.