Acerca de
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
Requisitos
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.
Lecciones
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
Carrera
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
Posibilidades de carrera
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.
Certificados
Deberás completar cada módulo en su totalidad y responder a los exámenes al final de cada módulo del curso. Si tu tasa de aprobación supera el 55% en cada examen, estarás calificado para acceder a un certificado de consecución u otras opciones de acreditación para reconocer tu éxito.
La mayoría de nuestros cursos te otorgarán créditos a través de Educación Continua (CE) / Desarrollo Profesional Continuo (CPD). Los puntos CE/CPD son aceptados y reconocidos por entidades profesionales e instituciones académicas en Estados Unidos e internacionalmente.
Además, todos nuestros cursos están acreditados por el Consejo Internacional de Estándares Educativos en Línea (www.icoes.org) y la Asociación Internacional de Colegios de Carrera Privada (www.iapcc.org). Al completar con éxito un curso, los estudiantes pueden optar a adquirir un certificado ICOES que reconoce el éxito mediante esta institución externa.
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.
Excel Training
26861 estudiantes. Acreditación ICOES. Certificación IAPCC y CPD.
26861 estudiantes.
Acreditación ICOES.
Certificación IAPCC y CPD.
Acerca de
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
Requisitos
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.
Lecciones
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
Carrera
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
Posibilidades de carrera
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:
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.