No internet? No problem! Download any course on the Alison App and learn on the go. 📲 Download Courses &
Learn Without Internet Coming soon to iOS
Get App
Explorar diplomas y certificados
Descubrir carreras
Más
LMS
MS Excel 2013 Avanzado
Advanced Level

MS Excel 2013 Avanzado

17,646Learners already enrolled
43
Not Interested
  • 3-4 Avg Hours
  • CPD Accredited
Start Learning
  1. Enseñanza y Académicos
  2. STEM
  3. MS Excel 2013 Avanzado

MS Excel 2013 Avanzado

En este curso en línea gratuito, aprenda la manipulación avanzada de datos y cree escenarios y análisis estadísticos utilizando MS Excel.
Aprender a usar Excel es una ventaja en cualquier profesión; la capacidad de usar de manera eficiente hojas de cálculo, tablas y automatización para procesar grandes cantidades de datos es útil en varias ... Aprender a usar Excel es una ventaja en cualquier profesión; la capacidad de usar de manera eficiente hojas de cálculo, tablas y automatización para procesar grandes cantidades de datos es útil en varias líneas de trabajo. Este curso completo es adecuado para quienes deseen obtener más información sobre las funciones más avanzadas disponibles en Microsoft Excel 2013. Para completar este curso, necesitará tener un buen conocimiento de las funciones básicas de MS Excel 2013.
COURSE PUBLISHER Workforce Academy PartnershipBusiness solutions & skills masters
Start Learning

What You Will Learn In This Free Course

  • Explain how to record a macro using...
  • Discuss how to apply conditional fo...
  • State how to watch and evaluate for...
  • Describe the watch window in Excel ...
  • Explain how to record a macro using the record macro dialogue box
  • Discuss how to apply conditional formatting
  • State how to watch and evaluate formula features
  • Describe the watch window in Excel 2013
  • State how to add and edit a Sparkline in Excel 2013
  • Define a scenario in Excel 2013
  • Explain how to inaugurate Excel data with the web
  • Describe how to publish a file in Excel 2013
View All Learning Outcomes View Less
Course Modules
Course Description
Alison Certificates
Module

Automating Worksheet Functionality

In this module, you will be introduced to steps on how to update workbook properties. A macro is an action or a set of actions that you can run as many times as you want, you will ... Read More In this module, you will be introduced to steps on how to update workbook properties. A macro is an action or a set of actions that you can run as many times as you want, you will discover how to create and edit a macro. You will also learn how to apply conditional formatting and data validation criteria to ranges of cells in your workbook. Read Less
Start Learning
Module

Auditing Worksheets

In this module, you will be introduced to steps on how to trace cells. You will learn how to troubleshoot invalid data and formulas, how to watch and evaluate formulas. Excel allow... Read More In this module, you will be introduced to steps on how to trace cells. You will learn how to troubleshoot invalid data and formulas, how to watch and evaluate formulas. Excel allows you to group rows or columns so that they can be hidden or displayed with a single mouse click. You will learn how to create a data list outline using Excel 2013. Read Less
Start Learning
Module

Analyzing and Presenting Data

In this module, you will be introduced to the creation of sparklines, as well as create scenarios and perform a what-if analysis. You will learn how to perform a statistical analys... Read More In this module, you will be introduced to the creation of sparklines, as well as create scenarios and perform a what-if analysis. You will learn how to perform a statistical analysis using the analysis tool pack. You will also learn about how to create interactive data using power view. Read Less
Start Learning
Module

Working With Multiple Workbooks

In this module, you will be introduced to steps on how to consolidate data. When you create formulas in Excel and refer to a data point in another workbook, Excel creates a link to... Read More In this module, you will be introduced to steps on how to consolidate data. When you create formulas in Excel and refer to a data point in another workbook, Excel creates a link to that workbook. This module teaches you how to link cells in different workbooks and how to merge workbooks. Read Less
Start Learning
Module

Exporting Excel Data

In this module, you will be introduced to steps on how to export Excel data. A comma-delimited file is one where each value in the file is separated by a comma. You will learn how ... Read More In this module, you will be introduced to steps on how to export Excel data. A comma-delimited file is one where each value in the file is separated by a comma. You will learn how to import a delimited text file, integrate Excel data with the web and how to create a web query. Read Less
Start Learning
Module

Course assessment

 Start Learning

Knowledge & Skills You Will Learn

No internet? No problem! Download any course on the Alison App and learn on the go. 📲 Download Courses & Learn Without Internet Coming soon to iOS
Get App

Complete This CPD Accredited Course & Get Your certificate!

  • Certify Your Skills
    A CPD accredited Alison Diploma/Certificate certifies the skills you’ve learned
  • Stand Out From The Crowd
    Add your Alison Certification to your resumé and stay ahead of the competition
  • Advance in Your Career
    Share your Alison Certification with potential employers to show off your skills and capabilities
Start Learning

Learner Reviews & Feedback For MS Excel 2013 Avanzado

43
Shanice M. Alison Graduate
Liked this course
I enjoyed this course and learnt a lot from it.
Was This Review Helpful?
Report
Franchel I. Alison Graduate
loved this course
lovely really enjoyed it
Was This Review Helpful?
Report
Hinda M. Alison Graduate
Liked this course
Really i appreciate how Alison facilitates getting new skills
Was This Review Helpful?
Report
Satish K. Alison Graduate
loved this course
Good to learn in simple and efficient . Excellent choice for beginners.
Was This Review Helpful?
Report
Md K. Alison Graduate
loved this course
Very Very Grateful and helpful
Was This Review Helpful?
Report
View 2 More Reviews
Back to course information

Want to create a customised learning path for your team?

Our dedicated Learning Advisors are here to help you curate a customised learning path tailored to your organisation's needs and goals.

Activate your Free LMS now Speak to Learning Advisor

Not sure where to begin? Or even what you want to do?

Discover the career most suitable for you and get started in the field with a step-by-step plan.

Get your Plan

About Your Alison Course Publisher

Workforce Academy Partnership's Alison Stats

Workforce Academy Partnership's Alison Stats

3,035,721 Learners143 Courses21,461 Learners Benefited From Their Courses

More Free Online Courses by This Publisher

    Learners Who Took This Course Also Enrolled In

    Explore Subjects Related To This Course