PMP Certification Prep COMING SOON!! Register now and guarantee your place or gather more information through our communication channels

Microsoft Excel: Advanced

19/Nov

Who is this course for:

  • People who, in the exercise of their activity or profession, need to insert, organize and present data in order to extract information.

What you will learn:

  • Using the MS Excel tool at different levels
  • Adapt the use of MS Excel to your daily work needs

requirements

  • Willingness to learn and win!
  • Don’t worry, I’ll help you work with MS Excel from basic concepts to more evolved concepts.
  • At least 2013 version of MS Excel Installed

Program content

Module 01 – First interactions with the Microsoft Excel Tool

  • Capítulo 01 – Interface do Microsoft Excel
  • Chapter 02 – Facilitating access

Module 02 – The MS Excel Spreadsheet

  • Chapter 01 – Creating the Spreadsheet
  • Chapter 02 – Calculation Sheet Formation
  • Chapter 03 – Editing and Checking the Spreadsheet
  • Chapter 04 – Spreadsheet Management
  • Chapter 05 – Printing the Spreadsheet

Module 03 – Formulas and Functions

  • Chapter 01 – Creating Basic Formulas
  • Chapter 02 – Logic Functions and Error Detection
  • Chapter 03 – Time and Date Formulas
  • Chapter 04 – Financial Formulas
  • Chapter 05 – Mathematical and Statistical Formulas
  • Chapter 06 – Query formulas, information and text.

Module 04 – Calculation Sheet, Organization and Review

  • Chapter 01 – Book and Spreadsheet Protection
  • Chapter 02 – Preparing the Calculus Book for Sharing
  • Chapter 03 – Sharing the Spreadsheet and Spreadsheet Data

Module 05 – Graphics and Illustrations

  • Chapter 01 – Illustrating spreadsheet data
  • Chapter 02 – Adding Graphics

Module 06 – Data Management

  • Chapter 01 – Creating and Editing Tables
  • Chapter 02 – Filter and Query tables

Module 07 – Data Analysis

  • Chapter 01 – AND IF Analysis
  • Chapter 02 – Large-scale data analysis

Preço do curso

190.659,00 Kz

Out of stock

Related Product