Microsoft Excel Essentials for Business - Level 1

INSTRUCTOR-LED ONLINE COURSE

This course is designed to provide participants with a strong foundation in Microsoft Excel, a powerful tool for managing and analyzing business data. Participants will learn how to create and manage spreadsheets, format data, and perform basic calculations using Excel.

Businessman on a laptop in a hotel lobby

The Key topics in this course are:

  • Introduction to Excel
  • Introduction to Basic Arithmetic in Formulas
  • Introduction to Basic Functions (SUM, PRODUCT, POWER, QUOTIENT, MAX, MIN, AVERAGE, COUNT, COUNTA, COUNTBLANK)
  • Working with Text Functions (CONCAT, CONCATENATE, TEXT JOIN, UPPER, LOWER, PROPER)
  • Understanding Order of Operations
  • Managing Worksheets
  • Working with Dates & Time. (TODAY, NOW, YEAR, MONTH, DAY, EOMONTH, EDATE, WORKDAY, NETWORKDAYS)
  • Absolute and Relative Cell Reference
  • Understanding The Importance of Data Validation
  • Working with Statistical and Math & Trig Functions. (MEAN, MEDIAN, MODE, SUMIF, COUNTIF, AVERAGEIF,)
  • Range Names, Custom List and Dealing with Errors
  • Formatting, Custom Formatting and Protecting Worksheets and Workbooks
  • Working with Logical Functions (IF, AND, OR & NOT)
  • Working with Lookup & Reference Functions (VLOOKUP, FILTER, SORT, UNIQUE etc)
  • Manipulate Data and Modifying worksheet
  • Creating and Managing Tables & Slicers, Charts and Objects
  • Introduction to Interactive reports with Excel Pivot Tables
  • Printing Excel Files and Saving as PDF

Microsoft Excel Essentials for Business - Level 1

In this course, participants will learn how to use Microsoft Excel to manage and analyze business data. They will learn how to create and manage spreadsheets, format data, and perform basic calculations using Excel. Participants will also learn how to create charts and graphs to visualize their data.

Target Audience

This course is ideal for business professionals, entrepreneurs, and individuals who want to improve their data management and analysis skills using Microsoft Excel. It is also suitable for beginners who have little or no experience with the software.

Tuition Fees

$899.99/TTD

10 Sessions ~ 30 hrs

5/5

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.

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.

A: Yes, participants should have Microsoft Excel installed on their computer before starting this course.

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.