Excel for Beginners
This Excel for Beginners course is for anybody who uses Excel for simple tasks at home or at work, such as tracking costs or calculating sums and totals. This online course is meant for those who have never used Excel or only have a rudimentary knowledge of the software. It’s also perfect for anyone who is familiar with prior versions of the application but is unfamiliar with the most recent. If you’re reentering the workforce, this course will be a terrific match for you and will help you catch up with your colleagues.
Course Summary
The lesson starts by defining terms like “What is a cell?” and “How can I know the difference between a column and a row?” The course goes on to cover basic Excel principles including creating, copying, deleting, and cutting data from Excel cells. You’ll also learn how to modify data that’s been entered into a cell, as well as how to insert and edit comments in Excel.
Sheets are a completely different idea from cells, and will be covered in the Excel overview, which is only a tiny part of the beginning course. You’ll learn how to rename a sheet, remove it, hide and unhide it, and move and copy it in this part. You’ll also discover how to alter the colour of tabs.
What you will learn
The MS Excel beginners course will give you a full overview of all of the most common features of Excel and how to use them. Some of the highlights of this course include:
- A basic overview of Excel
- Calculating sums, averages, and totals
- Counting cells
- Learning formulas, such as IF, COUNTIF, SUMIF, VLOOKUP, HLOOKUP, and AVERAGEIF
- Pivot tables
- Inserting, editing, and deleting comments
- Creating borders
- Wrapping text
- Merging cells
- Pasting, sorting, and converting columns to rows
- Creating graphs and charts
- Using the dictionary
- Using hyperlinks
Excel Beginners Course Modules
- Module 1: Introduction to Excel
- Module 2 : Add
- Module 3 : Multiply
- Module 4 : Subtraction in Excel
- Module 5 : Dividing
- Module 6 : Sort
- Module 7 : Percentage
- Module 8 : Running Totals
- Module 9 : Print
- Module 10 : Paste Special
- Module 11 : Merge
- Module 12 : Filter
- Module 13 : Average
- Module 14 : AVERAGEIF
- Module 15: SUMIF Formula
- Module 16: IF Formula
- Module 17: VLOOKUP
- Module 18: HLOOKUP
- Module 19 : Count if Formula
- Module 20 : Count Blank
- Module 21 : Counta Formula
- Module 22 : Count Formula
- Module 23 : Concatenate
- Module 24 : Transpose
- Module 25: Date Formula
- Module 26: Month Formula
- Module 27: Pivot Tables
- Module 28: Pivot Table – Filter & Calculate – The Values Area
- Module 29: Pivot Table – Tabular Data Structure
- Module 30: Filter & Calculate on Multiple Fields
- Module 31: Pivot Table – Filter the Entire Pivot Table
- Module 32: Working with charts – Different Charts and Graphs in Excel
- Module 33: Number Formatting
- Module 34: Create Borders
- Module 35: Conditional Formatting
- Module 36: Comments
International Student Fee : 100 USD | 375 AED | 375 SAR
Flexible Class Options
- Corporate Group Training | Fast-Track
- Week End Classes For Professionals SAT | SUN
- Online Classes – Live Virtual Class (L.V.C), Online Training
