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
Explore Diplomas & Certificados
Descobrir Carreiras
Mais
LMS
Microsoft Excel 2010
Beginner Level

Microsoft Excel 2010

172,982Learners already enrolled
910
Not Interested
  • 6-10 Avg Hours
  • CPD Accredited
Start Learning
  1. Negócios
  2. Microsoft
  3. Microsoft Excel 2010

Microsoft Excel 2010

Trabalhe com planilhas de forma mais eficiente e eficaz com este curso tutorial online gratuito do Microsoft Excel 2010.
Este curso fornece uma compreensão completa do Microsoft Excel 2010 e de seus aplicativos mais importantes. O Excel continua sendo um dos aplicativos de software mais populares do mundo e é uma ferramenta e... Este curso fornece uma compreensão completa do Microsoft Excel 2010 e de seus aplicativos mais importantes. O Excel continua sendo um dos aplicativos de software mais populares do mundo e é uma ferramenta essencial usada na maioria dos locais de trabalho. Seja você um usuário iniciante ou intermediário, este curso ensina dicas e truques, como teclas de atalho e outros atalhos, para aumentar rapidamente sua produtividade e carreira, então inscreva-se para ficar à frente da concorrência.
COURSE PUBLISHER MicrosoftEstablished provider of Microsoft
Start Learning

What You Will Learn In This Free Course

  • Explain how to create a worksheet a...
  • Identify patterns and trends with c...
  • Describe the ‘save’ and ‘run’ macro...
  • Identify how to navigate Excel's me...
  • Explain how to create a worksheet and save, prepare for printing and apply templates to it
  • Identify patterns and trends with conditional formatting, sparklines and charts
  • Describe the ‘save’ and ‘run’ macros
  • Identify how to navigate Excel's menus
  • State the MS Excel 2010 version's improvements and new features
  • Indicate the process of working with formulas and functions
  • Outline the use of ‘VLOOKUP’ to search through the data in the spreadsheet
  • Describe how to apply a table to data
  • Discuss the ways to check conditions with the ‘IF’ function
  • Explain the process of calculating dates using formulas
  • Recall how to work more efficiently with keyboard shortcuts
View All Learning Outcomes View Less
Course Modules
Course Description
Alison Certificates
Module

Making the switch to Excel 2010

This module will teach you about switching from and older versions of Microsoft Excel to Excel 2010
Start Learning
Module

What's new in Excel 2010

There are many new and improved features in this version of Excel. This module will show you these changes that will allow you to be more productive.
Start Learning
Module

Basic Tasks in Excel 2010

This module will help you get set up and started using Excel. These simple step by step instructions will guide you through creating and saving a workbook and show you how to compl... Read More This module will help you get set up and started using Excel. These simple step by step instructions will guide you through creating and saving a workbook and show you how to complete basic tasks. Read Less
Start Learning
Module

Create your first spreadsheet

This module will get you started working on a spreadsheet, doing basic math, add and delete columns and rows and prepare the worksheet for printing.
Start Learning
Module

Create Formulas

This module explains that when working with formulas the results automatically update when values are changed and also how to use functions which are more complicated formulas.
Start Learning
Module

VLOOKUP - What it is and when to use it

You will be introduced to VLOOKUP in this module; it is used to look up a value to find corresponding data on the same row.
Start Learning
Module

Understand Data at a glance with Conditional Formatting

This module explains how to use conditional formatting to make your data stand out, this helps you to analyse data and to determine patterns and trends.
Start Learning
Module

Sparklines - Use tiny charts to show data trends

Here you will be shown Sparklines which are tiny charts that fit into a spreadsheet cell, these give a visual representation of your data to help spot patterns and trends.
Start Learning
Module

Use Excel tables to manage information

In this module you will learn to apply tables in Excel, their used to store related information to make it easier to format, sort and total your data.
Start Learning
Module

The IF Function - What it is and how to use it

In this module you will learn about the IF function, this checks if a condition you specify is true or false and it executes a reaction depending on the result.
Start Learning
Module

How to create a basic chart in Excel 2010

There are many different charts in Excel for representing different data visually to show comparisons, patterns and trends.
Start Learning
Module

Save time by creating and running macros in Excel 2010

You will be shown how to save and execute a macro in this module, macros are used to record a set of instructions you do all the time to use whenever you want.
Start Learning
Module

Figure out dates by using formulas in Excel 2010

This module explains how dates are stored in Excel for using in formulas to get the number of days between two dates.
Start Learning
Module

Plan payments and savings in Excel 2010

You will be shown in this module how to use more complex formulas for figuring out mortgage repayments and calculating the accumulative interest on your savings.
Start Learning
Module

Keyboard shortcuts in Excel 2010

In this module you will learn how to use CTRL key shortcuts and ALT key shortcuts to gain a quicker workflow.
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 Microsoft Excel 2010

910
JANAKI L. Alison Graduate
loved this course
goodgoodgood
Was This Review Helpful?
Report
Bernard Katongo L. Alison Graduate
loved this course
Great course! Prepares one on the functionalities of excel.
Was This Review Helpful?
Report
Shakir U. Alison Graduate
loved this course
thank you so much , i learn a lot
Was This Review Helpful?
Report
Brenda R. Alison Graduate
This course was thorough and I learned some new MS Excel skills.
Was This Review Helpful?
Report
Ahsan A. Alison Graduate
This course is really helpful to beginners as well as pros. I did course from a school but i learned here more than anywhere. Thankyou for providing useful information.
Was This Review Helpful?
Report
View 24 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

Microsoft's Alison Stats

Microsoft's Alison Stats

1,199,118 Learners36 Courses8,819 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

    Frequently Asked Questions

    What is Microsoft Excel?
    What are the best free online Microsoft Excel courses?
    How much does an online Microsoft Excel course cost?