À propos

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

    Prérequis

    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.

    Leçons

    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

    Carrière

    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.

    A qui s'adresse ce cours ?

    • All office and administrative workers 
    • Business owners and managers
    • Anyone who needs to organize data and manage budgets, whether for business or personal use

    Certification

    Détails de la certification

    To receive certification, you must complete every page of the course and score at least 55% on the exam at the end of the course.

    After successfully completing the course, you will be able to download your PDF course certificate.

    All our courses are accredited by the International Council for Online Educational Standards.

     

    En solde

    Excel Training

    Prix réduit

    €99.00

  • - 0%
  • Prix régulier €99.00
    ( / )
    Taxes incluses.
    ICOES

    Accrédité

    CPD/CE

    Accrédité

    9483

    Étudiants inscrits

    Money-Back

    de Remboursement


    À propos

    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

      Prérequis

      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.

      Leçons

      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

      Carrière

      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.

      A qui s'adresse ce cours ?

      • All office and administrative workers 
      • Business owners and managers
      • Anyone who needs to organize data and manage budgets, whether for business or personal use

      Certification

      Détails de la certification

      To receive certification, you must complete every page of the course and score at least 55% on the exam at the end of the course.

      After successfully completing the course, you will be able to download your PDF course certificate.

      All our courses are accredited by the International Council for Online Educational Standards.

       

      ICOES

      Accrédité

      CPD/CE

      Accrédité

      9483

      Étudiants inscrits

      Money-Back

      de Remboursement