COURSES / COMPUTING & IT

Excel Training

$ 99

SIGN UP NOW!
  • Internationally Accredited by ICOES
  • Instant Free PDF Certificate
  • 24/7 Access
  • 3206 Students Enrolled
  • 45 Study Hours
  • 30 Days to complete the course

ABOUT THIS COURSE

Become an Excel whiz and make life - in the office and at home - so much easier!


Excel is used in almost every office, school, and home, and it’s one of the basic programs that everyone should know. Why? Because it will make your life so much easier! Whether you want to learn excel to log data and records at work, manage expenses at home, or keep track of important information, Excel will make managing these tasks quick and efficient by doing all the hard work for you. Unlike Word, Excel can be tricky to grasp, and most people benefit from a professional tutorial or course to ensure they get the most out of the program. It’s perfectly fine to teach yourself, but you will likely miss out on tools and functions that will really speed up your tasks, and make the program easier to use. In this online course, you’ll learn just how powerful a tool Excel can be when done right! We’ll cover all the bases – starting with an overview of all tools and functions, show you some useful beginner tips and tricks, move on to intermediate formulas and techniques, and finish by showing you how to export your data as charts. You’ll go from Excel newbie to Master of Spreadsheets in no time, and you’ll learn a certificate in Excel to show off your achievement!

WHAT YOU’LL LEARN

  • How to navigate Excel and understand its core tools and functions
  • How to organize, sort, and optimize data
  • How to analyze and interpret data at a glance
  • Basic and intermediate level formulas
  • How to create tables, including pivot tables
  • How to make your worksheets and data visually appealing
  • How to create various charts for presentations
  • Beginner to intermediate users of Excel
  • Anyone who needs a refresher on how to use Excel
  • Those wanting to become Excel Certified
  • Anyone who works with budgets, payroll, statistics, etc.
  • Pretty much anyone who works with a computer!
  • People who manage their own budgets – savings, expenses, etc.
  • Business owners and managers

Access to any version of Excel, but preferably Excel 2016

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.

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 Colour 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

RECEIVE YOUR CERTIFICATE IN 4 SIMPLE STEPS

Step 1

Register

Follow the easy peasy enrollment process

Step 2

Study

Absorb and remember course content with our easy-to-follow, structured information and helpful illustrations. And yes - you can study anywhere, anytime, from any device

Step 3

Evaluations

Reinforce your learning with quizzes at the end of each module

Step 4

Certification

Once you’ve successfully completed your course and passed the exams, you’ll receive your certification. Congratulations on your amazing achievement!

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 Colour 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

$ 99

SIGN UP NOW!
  • Internationally Accredited by ICOES
  • Instant Free PDF Certificate
  • 24/7 Access
  • 3206 Students Enrolled
  • 45 Study Hours
  • 30 Days to complete the course
SIGN UP NOW! Remove