No internet? No problem! Download any course on the Alison App and learn on the go. 📲 Download Courses &
Learn Without Internet
Get App
Esplora Diplomi & Certificati
Scopri le carriere
Più
LMS
Microsoft Excel 2013 - Avanzato: fogli di calcolo principali
Beginner Level

Microsoft Excel 2013 - Avanzato: fogli di calcolo principali

44,171Learners already enrolled
30
Not Interested
  • 5-6 Avg Hours
  • CPD Accredited
Start Learning
  1. Business
  2. Microsoft
  3. Microsoft Excel 2013 - Avanzato: fogli di calcolo principa...

Microsoft Excel 2013 - Avanzato: fogli di calcolo principali

Scopri come padroneggiare i fogli di calcolo con questo corso di formazione avanzata online gratuito su Microsoft Excel.
Questo corso di formazione avanzata online gratuito su Microsoft Excel 2013 ti insegnerà come utilizzare funzioni e formule avanzate in Excel e potenziare le tue competenze di Excel. Imparerai come usare le ... Questo corso di formazione avanzata online gratuito su Microsoft Excel 2013 ti insegnerà come utilizzare funzioni e formule avanzate in Excel e potenziare le tue competenze di Excel. Imparerai come usare le funzioni e fare analisi statistiche dei dati in Excel. Questo corso è rivolto a studenti con una conoscenza esistente di Excel che desiderano moltiplicare la produttività dei fogli di calcolo. Inizia questo corso oggi per portare le tue abilità con i fogli di calcolo a un livello superiore.
COURSE PUBLISHER -
Start Learning

What You Will Learn In This Free Course

  • Discuss the use of advanced functio...
  • Illustrate a good understanding of ...
  • Identify how time and dates are sto...
  • Discuss how to use statistical func...
  • Discuss the use of advanced functions and formulas in Excel
  • Illustrate a good understanding of financial functions
  • Identify how time and dates are stored and calculated
  • Discuss how to use statistical functions to perform regression and percentile calculations
  • Explain and demonstrate how text functions work
  • Discuss detailed knowledge of logical functions
  • Recognize how to connect Excel with external data sources
View All Learning Outcomes View Less
Course Modules
Course Description
Alison Certificates
Module

Introduction to Advanced Excel 2013

This module introduces you to Advanced Excel 2013 and outlines what you can expect to learn in this free online course.
Start Learning
Module

Functions

This module teaches you about the workings and concepts of functions in Excel 2013. It outlines a list of functions, common types of Arguments and various advanced aspects of funct... Read More This module teaches you about the workings and concepts of functions in Excel 2013. It outlines a list of functions, common types of Arguments and various advanced aspects of functions. Read Less
Start Learning
Module

Personal and Professional Financial Functions

This module provides a comprehensive exploration of some of the personal and professional financial functions available through Excel 2013. A series of case studies and practical e... Read More This module provides a comprehensive exploration of some of the personal and professional financial functions available through Excel 2013. A series of case studies and practical exercises enable the learner to gain a thorough understanding of Excel 2013. Read Less
Start Learning
Module

Date and Time Functions

This module guides you through the uses of Date and Time Functions in Excel 2013. It outlines how dates and times are stored, explores the calculation of dates and times and provid... Read More This module guides you through the uses of Date and Time Functions in Excel 2013. It outlines how dates and times are stored, explores the calculation of dates and times and provides exercises on date and time functions so that you can test your knowledge in a practical setting. Read Less
Start Learning
Module

Statistical Functions for Description, Prediction and Inference

This module outlines different types of statistical functions in Excel 2013. It also explores averages, percentiles, regression and the LINEST function.
Start Learning
Module

Text Functions

This module teaches you about the functions of manipulating text in Excel 2013. It guides you through the ways in which you can separate pieces of text into separate cells, shows y... Read More This module teaches you about the functions of manipulating text in Excel 2013. It guides you through the ways in which you can separate pieces of text into separate cells, shows you how to convert text into a numerical format and explains how to remove leading and trailing spaces from text strings. Read Less
Start Learning
Module

Lookup and Logical Functions

This module outlines the various uses of the lookup functions in Excel 2013. It shows you how to set up and use both VLOOKUP and HLOOKUP functions as well as how to create an IFNA ... Read More This module outlines the various uses of the lookup functions in Excel 2013. It shows you how to set up and use both VLOOKUP and HLOOKUP functions as well as how to create an IFNA and an IF statement in a function. Read Less
Start Learning
Module

Connecting to External Data

Learn about the ways in which Excel can be connected to external data, including connecting to Access data, connecting to web data and connecting to other workbooks.
Start Learning
Module

Tables

In this final module, you will learn about creating, designing, manipulating and organizing tables in Excel 2013. This module includes a look at removing duplicates, resizing table... Read More In this final module, you will learn about creating, designing, manipulating and organizing tables in Excel 2013. This module includes a look at removing duplicates, resizing tables and examines table styles and selection. 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
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 Microsoft Excel 2013 - Avanzato: fogli di calcolo principali

30
Anup K. Alison Graduate
loved this course
good expiriean
Was This Review Helpful?
Report
Sailendra D. Alison Graduate
Liked this course
Very good experience
Was This Review Helpful?
Report
Radhe Krishan T. Alison Graduate
loved this course
very good experience
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

- Alison Stats

- Learners- Courses- Learners Benefited From Their Courses

More Free Online Courses by This Publisher

See All Courses

    Learners Who Took This Course Also Enrolled In

    Explore Subjects Related To This Course