À 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

    Conditions requises

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

    Carrière

    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

    Opportunités de 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.

      Certification

      Vous devrez suivre chaque leçon dans son intégralité et répondre aux examens à la fin de chaque module de cours. Si votre taux de réussite dépasse 55 % à chaque examen, vous avez alors droit à un certificat de réussite ou à d'autres options d'accréditation pour reconnaître votre réussite.

      La plupart de nos cours vous rapporteront des crédits via la formation continue (CE) / le développement professionnel continu (CPD). Les points CE/CPD sont acceptés et reconnus par les organismes membres professionnels et les établissements universitaires aux États-Unis et dans le monde.

      Tous les cours sont accrédités par l'International Council for Online Educational Standards (www.icoes.org) et l'Association internationale des collèges privés d'enseignement professionnel (www.iapcc.org). Lorsqu'ils terminent avec succès un cours, les étudiants peuvent choisir d'acheter un certificat ICOES reconnaissant la réussite auprès de cette institution tierce.

      Creator

      IOA Original

      This course is an exclusive offering from the International Open Academy (IOA). IOA Originals are thoughtfully crafted and developed either in-house by IOA or with complete ownership of production and distribution rights.

      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.

      En solde

      Excel Training

      26975 étudiants. Accrédité par ICOES. Certifié par IAPCC et CPD.

      26975 étudiants. 
      Accrédité par ICOES.
      Certifié par IAPCC et CPD.

      Prix réduit

    • - 0%
    • Prix régulier €129.00
      ( / )
      Accédez à cette formation

      À 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

        Conditions requises

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

        Carrière

        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

        Opportunités de 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.

          Creator

          IOA Original

          Expertise:

          This course is an exclusive offering from the International Open Academy (IOA). IOA Originals are thoughtfully crafted and developed either in-house by IOA or with complete ownership of production and distribution rights.

          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.