Online
- Duration / Course length: Upto 12 Hours Start now
- Accredited by: CPD Certification Service
- Certificates:
- Course delivery: This course is delivered in video format
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
- 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.
Eligibility / Requirements
- This course is available to all learners, of all academic backgrounds.
- Learners should be aged 16 or over to undertake the qualification.
- Good understanding of English language, numeracy and ICT are required to attend this course.
Job roles this course is suitable for:
Admin , Payroll Officer , Data Analyst , Business Analysts , Data Journalists , Financial Analyst , Project Manager , Accountant , Sales AnalystAbout Course Gate
Being a top supplier of online courses will always be at the heart of our operation. But, this is not all we’re about. Rather, we see ourselves taking one step further in our devotion to satisfying our learners’ needs. That involves ensuring that learners can study from anywhere in the world, at their convenience, proving more flexible than traditional learning establishments. Life takes over sometimes and it can be hard to find time for personal and professional development. With our services, time won’t be a barrier to your learning, as you can study our courses using any device that connects to the internet.
465 students have enrolled with Course Gate through Laimoon
See all Course Gate courses
