Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
EXCEL FOR BEGINNERS
Rating: 4.6 out of 5(573 ratings)
12,782 students

EXCEL FOR BEGINNERS

Begin your experience with the most used software by companies in the world.
Created byGrupo Voitto
Last updated 3/2019
English
English [Auto],

What you'll learn

  • MS Excel is an extremely versatile software that is surely present in your professional and personal life, helping from the creation of financial management and routine organization to the creation of data analysis panels. By using MS Excel, you will become more productive and able to make decisions with more precision and confidence, qualities increasingly valued by the job market. If you want to start studing such a powerful tool, the Excel for Beginners course is for you! With practical lessons, you will begin to use basic functions already in the first classes.

Course content

2 sections • 8 lectures • 31m total length

  • Lesson 1 - Introduction to elements9:44

    Navigate workbooks and worksheets, master the Excel toolbar, and apply formatting, formulas, and data tools; create charts, pivot tables, and data validation while protecting sheets.

  • Lesson 2 - Find and replace3:30

    Learn to find and replace letters or numbers in Excel, use automatic formulas to fix decimal separators—comma and dot—and replace mistakes across thousands of data entries, saving time.

  • Lesson 3 - Paste link4:48

    Learn how to use paste link to dynamically connect Excel data and charts to Word or PowerPoint, so updates in the source file reflect in your reports and presentations.

  • Lesson 4 - Introduction to basic formulas5:05

    Learn to build formulas using functions, sums, and cell references by starting with =, linking cells like B8 and C8, and applying addition, subtraction, multiplication, and division.

  • Lesson 5 - Introduction to basic functions2:38

    Learn to create functions in Excel to improve efficiency by summing daily quantities with the sum function, and selecting ranges using control shift down or auto fill.

  • Lesson 6 - Exercise 11:07
  • Lesson 7 - Answer Exercise 12:53

    This lesson teaches correcting an exercise by multiplying quantity by price, fixing decimal separators, auto filling totals, summing with the sum function, and linking the Excel results to Word.

Requirements

  • You who have never had contact with the software, will begin to use basic functions already in the first classes.

Description

Do you know how to turn data into relevant information?

MS Excel is an electronic spreadsheet software widely used by companies of all branches and activities worldwide for stock control, database creation, simple and complex data analysis, among thousands of other functions.

MS Excel is an extremely versatile software that is surely present in your professional and personal life, helping from the creation of financial management and routine organization to the creation of data analysis panels. By using MS Excel, you will become more productive and able to make decisions with more precision and confidence, qualities increasingly valued by the job market.

If you want to start studing such a powerful tool, the Excel for Beginners course is for you! With practical lessons, you will begin to use basic functions already in the first classes.


During this course, you will see:

  • A brief introduction to MS Excel and its first steps;

  • How to format cells;

  • How to insert images and print your spreadsheets;

  • Introduction to basic MS Excel formulas and functions;

  • Drills.

Who this course is for:

  • The MS Excel Introduction training is intended for those people who are unfamiliar with the tool but are eager to begin to study this software so widely used in business to promote agility and productivity.

Report abuse