About
Microsoft Excel is used in almost every office, school, and home around the globe.
Whether you want to log data and records at work or keep track of expenses at home, our Excel training will make managing these tasks quick and efficient.
Use Microsoft Excel to its fullest potential by learning how to:
- Navigate Excel and understand its core tools
- Use the most important Excel formulas and functions
- Sort, analyze, and interpret data
- Create tables, worksheets, graphs, and charts
- Make your worksheets and data visually appealing
Requirements
International Open Academy courses are designed for anyone with an interest in learning. No formal qualifications are required to study with us. Our courses are suitable if you want to learn new skills, start a new career, or if you’re already working in a particular industry and wish to upgrade your talents and enhance your resume.
Lessons
Module 1: Getting To Know Your Excel Program
- When Is Excel Used?
- Learning to Navigate the Interface
- Overview of The Ribbon
- Important Tools and Functions
- Basic Formatting
- Understanding Structure: Cells, Rows, and Columns
Module 2: Executing Formulas and Functions
- Learning the Principles of Excel Formulas
- Mathematical Calculations and Equations
- Statistical Functions
- Date and Time
- Logical Functions
- Exercise: Applying Formulas in the Real World
Module 3: Organizing and Analyzing Data
- How to Sort Data and Apply Filters
- Using Macros to Automate Tasks
- Creating Pivot Tables
- Formatting Pivot Tables
- Auditing Formulas and Tasks
Module 4: Presentation
- Font and Number Formatting
- Applying Borders and Outlines
- Adding Color to Enhance Data
- Merging, Wrapping, and Indents
- Conditional Formatting
- Printing Worksheets, Sections, and Tables
Module 5: Creating Charts and Graphs
- Overview of Creating and Reading Excel Charts
- Column charts
- Line Charts
- Pie Charts
- Bar Graphs
- Area Charts
- How to make Your Charts POP for Presentations
Career
Who is this course for?
- All office and administrative workers
- Business owners and managers
- Anyone who needs to organize data and manage budgets, whether for business or personal use
Career path
Learn Excel online and use it as a stepping stone to a career as an administrative assistant, accountant, project manager, or financial or business analyst.
Certification
You will be required to complete each lesson in full, and answer exams at the end of each course module. If your pass rate exceeds 55% on each exam then you are eligible to access a certificate of achievement or other accreditation options to recognize your achievement.
Most of our courses will earn you credits through Continuing Education (CE) / Continuing Professional Development (CPD). CE/CPD points are accepted and recognized by professional member bodies and academic institutions across the US and internationally.
All courses are accredited by the International Council for Online Educational Standards (www.icoes.org). When successfully completing a course, students can choose to purchase an ICOES certificate that recognizes the achievement, from this third-party institution.
Creator
IOA Original
Our team of experts has worked diligently to create, write, and produce this course, ensuring it provides learners with a distinctive opportunity to access premium content on a wide range of diverse topics.
Excel Training
13186 Students. ICOES Accredited. CPD Certified.
13186 Students.
ICOES Accredited.
CPD Certified.
About
Microsoft Excel is used in almost every office, school, and home around the globe.
Whether you want to log data and records at work or keep track of expenses at home, our Excel training will make managing these tasks quick and efficient.
Use Microsoft Excel to its fullest potential by learning how to:
- Navigate Excel and understand its core tools
- Use the most important Excel formulas and functions
- Sort, analyze, and interpret data
- Create tables, worksheets, graphs, and charts
- Make your worksheets and data visually appealing
Requirements
International Open Academy courses are designed for anyone with an interest in learning. No formal qualifications are required to study with us. Our courses are suitable if you want to learn new skills, start a new career, or if you’re already working in a particular industry and wish to upgrade your talents and enhance your resume.
Lessons
Module 1: Getting To Know Your Excel Program
- When Is Excel Used?
- Learning to Navigate the Interface
- Overview of The Ribbon
- Important Tools and Functions
- Basic Formatting
- Understanding Structure: Cells, Rows, and Columns
Module 2: Executing Formulas and Functions
- Learning the Principles of Excel Formulas
- Mathematical Calculations and Equations
- Statistical Functions
- Date and Time
- Logical Functions
- Exercise: Applying Formulas in the Real World
Module 3: Organizing and Analyzing Data
- How to Sort Data and Apply Filters
- Using Macros to Automate Tasks
- Creating Pivot Tables
- Formatting Pivot Tables
- Auditing Formulas and Tasks
Module 4: Presentation
- Font and Number Formatting
- Applying Borders and Outlines
- Adding Color to Enhance Data
- Merging, Wrapping, and Indents
- Conditional Formatting
- Printing Worksheets, Sections, and Tables
Module 5: Creating Charts and Graphs
- Overview of Creating and Reading Excel Charts
- Column charts
- Line Charts
- Pie Charts
- Bar Graphs
- Area Charts
- How to make Your Charts POP for Presentations
Career
Who is this course for?
- All office and administrative workers
- Business owners and managers
- Anyone who needs to organize data and manage budgets, whether for business or personal use
Career path
Learn Excel online and use it as a stepping stone to a career as an administrative assistant, accountant, project manager, or financial or business analyst.
Certification
You will be required to complete each lesson in full, and answer exams at the end of each course module. If your pass rate exceeds 55% on each exam then you are eligible to access a certificate of achievement or other accreditation options to recognize your achievement.
Most of our courses will earn you credits through Continuing Education (CE) / Continuing Professional Development (CPD). CE/CPD points are accepted and recognized by professional member bodies and academic institutions across the US and internationally.
All courses are accredited by the International Council for Online Educational Standards (www.icoes.org). When successfully completing a course, students can choose to purchase an ICOES certificate that recognizes the achievement, from this third-party institution.
Creator
IOA Original
Expertise:
Our team of experts has worked diligently to create, write, and produce this course, ensuring it provides learners with a distinctive opportunity to access premium content on a wide range of diverse topics.