What’s included:
- 16 easy-to-digest Excel tutorial videos
- Downloadable exercise files and reference guides
- Unlimited quiz and test attempts
- Certificate of completion
- Free access to the GoSkills Excel Office app
Learn how to:
- Understand the difference between formulas and functions.
- Calculate and simplify data with functions like AVERAGE, SUM, COUNTIF and TODAY.
- Apply cell formatting that makes data visually appealing.
- Use dynamic conditional formatting to make critical information stand out.
- Manage workbooks, including how to rename, add, delete, move, and copy sheets.
- Group, sort, and filter to quickly organize your data.
- Easily transform numerical data into visual charts and graphs.
Every concept in this course can be used in all versions of Microsoft Excel, and was recorded using Excel 2019/365.
Once enrolled, our friendly support team is here to help with any course-related inquiries.
Summary
- Skill level: Beginner
- Lessons: 49
- Versions supported: 2016, 2019, 2021, 365
- Estimated study time: 1h 15m for all materials
- Certificate: Yes
- Pre-requisites: None
- Video duration: 1h 15m
Features
Premium video tutorials
Personalized Learning
Learn at your own pace
Tests and Quizzes
Award winning instructors
Get Certified
Mobile - Learn on the go
Regularly updated content
Accreditations & Approvals
All courses under each learning path are accredited and approved by one or more of the following bodies as is applicable.
Instructors
All courses are taught by reputed trainers with relevant accreditations and industry experience.
Modules
Get Ready to Excel
Understand why you need to know how to use Excel.
The Basics
Introduction to the Ribbon, worksheets, and understanding cell contents and cell referencing.
Formulas vs Functions
What is the difference between a formula and a function? What’s the structure of each?
Formulas & Functions in Action
Determining when it’s best to use formulas vs. functions. Learn how to copy and paste formulas and functions.
Using Functions to Simplify Data
Solve common problems using essential functions.
Cell Formatting
Resize rows/columns, adjusting fonts, colors & alignment.
Number Formats
Change number formats to/from: date, currency/general.
Conditional Formatting
Format cells dynamically based on criteria which you define.
Worksheet Management
Edit worksheet by adding and removing rows and columns.
Workbook Management
Renaming, adding, deleting, moving and copying sheets.
Sorting & Filtering
Organize your data using sorts and filters.
Creating Charts
2
Formatting Charts
Learn how to create title and various options for your chart, adjust data source and change chart type.
Putting it all Together
Change the way your worksheet appears onscreen. Customize the way data appears when printed.
Excel Hacks & Tricks
Useful shortcuts and tips for working with Excel sheets
Excel Hacks & Tricks Part 2
Useful shortcuts and tips for working with Excel sheets
Target Audience
- Graduates exploring placement in the Microsoft Excel positions across industries
- Professionals needing upskilling to be future-ready or become more productive in their current roles
- Experienced individuals exploring Microsoft Excel in an Hour
How do I Access The Program
- Buy the course online
- Save your payment transaction receipt for any future reference
- Our team will share the credentials to enable you access your course online within 2 business days of payment transfer
Bulk Orders
Incase you are looking for bulk user licenses, or customized Learning Paths for various Job Roles, reach out to us with your detailed requirements.
Reviews
There are no reviews yet.