Microsoft Excel Essentials for Business - Level 2
INSTRUCTOR-LED ONLINE COURSE
This course is designed to build on the skills learned in Microsoft Excel Essentials for Business – Level 1. Participants will learn how to perform more advanced data analysis using Excel, including using functions and formulas, creating pivot tables, and using macros.
The Key topics in this course are:
- Review of Excel Essentials for Business - Level 1
- Range Names, Custom List and Dealing with Errors
- Understanding Absolute and Relative Cell Reference
- Working with Logical Functions (IF, AND, OR & NOT)
- Working with Dynamic Arrays SORT & SORTBY FUNCTION UNIQUE FUNCTION FILTER FUNCTION SEQUENCE FUNCTION XLOOKUP FUNCTION
- Using Excel Formulas for Quick & Dynamic Analysis SUMIFS COUNTIFS AVERAGEIFS SUMPRODUCT IFERROR For Credible Reports FREQUENCY, SMALL & LARGE to Organize and Rank
- Working with Paste Special and Find & Replace
- Formatting, Custom Formatting and Protecting Worksheets and Workbooks
- Creating and Managing Tables & Slicers, Charts and Objects
- Creating Interactive reports with Excel Pivot Tables and Charts
- Solve problems with Goal Seek
- Automating tasks with macros
- Customizing Excel
Microsoft Excel Essentials for Business - Level 2
In this course, participants will build on the skills learned in Microsoft Excel Essentials for Business – Level 1. They will learn how to perform more advanced data analysis using Excel, including using functions and formulas, creating pivot tables, and using macros. Participants will also learn how to customize Excel to suit their business needs.
Target Audience
This course is ideal for business professionals, entrepreneurs, and individuals who want to improve their data analysis skills using Microsoft Excel. It is suitable for participants who have completed Microsoft Excel Essentials for Business – Level 1 or have equivalent knowledge.
Tuition Fees
Duration: 10 Sessions ~ 30 hrs
FAQ (Frequently
Asked Questions)
This FAQ covers common questions about the Computer Essentials for Adults course, including who the course is for, what you’ll learn, and what you’ll receive upon completion.
- Who is this course for?
- What will I learn in this course?
- Is this course online or in-person
- How long does the course take to complete?
- etc...
This course is suitable for adults who are new to computers and have little or no experience using them. No prior knowledge or experience with computers is required.
A: In this course, you'll learn about the different parts of a computer and how to use a mouse and keyboard. You'll also learn about the Windows operating system and how to use common applications like a web browser, email client, and word processor. You'll work on hands-on projects and exercises to gain practical experience using a computer.
A: This course is an instructor-led online course. All course materials and lectures will be delivered online, and you'll have the flexibility to complete the course at your own pace.
The length of the course will depend on your schedule and how much time you can devote to it. On average, students complete the course within 4-6 weeks, but you can work at your own pace and complete the course as quickly or slowly as you'd like.
A: Yes, upon completion of the course, you'll receive a certificate of completion that you can add to your resume or professional portfolio.
A: No, there are no prerequisites for this course. It is suitable for adults who are new to computers and have little or no experience using them.
A: No, no additional software or materials are required for this course. You'll be able to access all course materials online.
Yes, you'll have access to an instructor and support team throughout the course. You can ask questions and get help with course content and assignments at any time.
