Highlights
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.
Groupon Customer Reviews
About This Deal
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
What We Offer
-
Accredited Online Excel Training Course with Proof of Completion
-
This course is Accredited by ICOES and CPD Continuing Professional Development (CPD) Certified.
When you successfully complete an International Open Academy course, you can order a digital certificate of achievement with your name and the course on it. Successfully completing a course means that you have completed each lesson in full, and passed your exams!
Modules
- Module 1: Getting To Know Your Excel Program
- When to use Excel
- How to navigate its interface
- How to understand the structure
- How to use the ribbon in Excel
- Basic formatting
- 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
- Auditing Formulas and Tasks
- Module 4: Presentation
- Font and Number Formatting
- Applying Borders
- 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 and Bar Graphs
- Line Graphs
- Pie Charts
- How to Make Your Charts Pop for Presentations
For more information about this course, please go to this link.
About International Open Academy
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.
Company Legal Name: International Open Academy | Registration number: 540695 | Registration Country: IE | Contact info: NULL | The merchant has certified that their products or services comply with the applicable rules of EU law.