Complete Excel Tutorial: Beginner To Expert

Course details

We have carefully combined our three best courses into one bundle - Complete Excel Tutorial: Beginner To Expert, making it easy for you to learn Excel. You won't find a great deal like this anywhere else at this price.
Microsoft Excel is one of the most widely used programs in the world for visualising and analysing data created so far. This useful software is used for personal use in households as well as in almost every industry these days. Business owners use Excel to track hours, finances, and statements, data analysis, visualise data and other countless tasks. Whether you are a beginner, have a little training and knowledge of the software or haven’t used Excel in years and require a significant refresher, and take your skill to an advanced level, then this Complete Excel Tutorial: Beginner To Expert can benefit you a lot. Once you have finished this course, you will be an expert user in Excel.
This course is designed to be easy to follow and flexible to fit your schedule. Learn at your own pace and revisit topics as needed. You'll have access to downloadable resources and practice exercises to reinforce your learning.
Don't miss out on this opportunity to learn Excel in a fun and effective way. Enrol in this course today and become an Excel expert in no time.

Course Curriculum

• Microsoft Excel 2019 New Features
• Getting Started with Microsoft Office Excel 2016
• Performing Calculations
• Modifying a Worksheet
• Formatting a Worksheet
• Printing Workbooks
• Managing Workbooks
• Working with Functions
• Working with Lists
• Analyzing Data
• Visualizing Data with Charts
• Using PivotTables and PivotCharts
• Working with Multiple Worksheets and Workbooks
• Using Lookup Functions and Formula Auditing
• Sharing and Protecting Workbooks
• Automating Workbook Functionality
• Creating Sparklines and Mapping Data
• Forecasting Data
• Resources

Learning Outcomes

• Familiarise yourself with the Excel interface, including the ribbon, cells, columns, rows, and menus.
• Understand the basic layout of a worksheet and workbook.
• Learn how to input data into cells efficiently.
• Understand techniques for editing and formatting data
• Learn how to manage rows, columns, and sheets within a workbook.
• Acquire skills in applying basic mathematical functions (, SUM, AVERAGE).
• Learn statistical functions, logical functions, and text functions for data manipulation.
• Explore keyboard shortcuts to enhance your speed and efficiency
• Learn to navigate Excel quickly and use features like Quick Analysis.
• Understand the basics of creating and using formulas in Excel.
• Learn to use common functions to perform calculations.
• Learn to visually represent data using charts and graphs.
• Understand how to customise and edit charts to convey information effectively.

Updated on 08 December, 2023