SlideServe
Télécharger Obtenir Pro
Menu
Accueil Pro
Préférences
ApparenceLight Aide et commentaires
© SlideServe · v2026

Microsoft Excel Tutorial For Beginners-1 | Excel Formulas & Functions | Excel Training | Simplilearn

Simplilearn avatar
Simplilearn
27 diapositives · 585 Views · Nov 22, 2020

This presentation on Excel Tutorial for beginners part-1 will help you get started with Excel and explore the features it offers. You will take a tour to understand Excel basics and look at how to write functions, sort, and filter data. You will understand how to import data and split data into multiple columns. You will learn about sumif and countif functions. Finally, you will get to know all about conditional formatting in Excel. Let's begin.

This Data Analyst Master\u2019s Program in collaboration with IBM will make you an expert in data analytics. In this Data Analytics course, you'll learn analytics tools and techniques, how to work with SQL databases, the languages of R and Python, how to create data visualizations, and how to apply statistics and predictive analytics in a business environment.


Why become Data Analyst?
By 2020, the World Economic Forum forecasts that data analysts will be in demand due to increasing data collection and usage. Organizations view data analysis as one of the most crucial future specialties due to the value that can be derived from data. Data is more abundant and accessible than ever in today\u2019s business environment. In fact, 2.5 quintillion bytes of data are created each day. With an ever-increasing skill gap in data analytics, the value of data analysts is continuing to grow, creating a new job and career advancement opportunities.

The facts are that professionals who enter the Data Science field will have their pick of jobs and enjoy lucrative salaries. According to an IBM report, data and analytics jobs are predicted to increase by 15 percent to 2.72 million jobs by 2020, with the most significant demand for data analysts in finance, insurance, and information technology. Data analysts earn an average pay of $67,377 in 2019 according to Glassdoor.

Who should take up this course?
Aspiring professionals of any educational background with an analytical frame of mind are best suited to pursue the Data Analyst Master\u2019s Program, including:
1. IT professionals
2. Banking and finance professionals
3. Marketing managers
4. Sales professionals
5. Supply chain network managers
6. Beginners in the data analytics domain
7. Students in UG\/ PG programs

\ud83d\udc49Learn more at: https:\/\/bit.ly\/2SECA5r

#microsoft excel tutorial for beginners #excel formulas and functions #excel training #excel tutorial #excel tutorial in english #excel tutorial advanced #excel tutorial pivot table #excel tutorial for beginners
Microsoft Excel Tutorial For Beginners-1 | Excel Formulas & Functions | Excel Training | Simplilearn - slide 1
01 / 27Microsoft Excel Tutorial For Beginners-1 | Excel Formulas & Functions | Excel Training | Simplilearn
1 / 17

Télécharger la présentation

Microsoft Excel Tutorial For Beginners-1 | Excel Formulas & Functions | Excel Training | Simplilearn
Une image / un lien ci-dessous est fourni (tel quel) pour télécharger la présentation

Politique de téléchargement : le contenu du site vous est fourni TEL QUEL pour votre information et votre usage personnel ; il ne peut être vendu, concédé sous licence ni partagé sur d’autres sites sans l’accord de son auteur.Le contenu vous est fourni TEL QUEL, pour votre information et votre usage personnel uniquement. Téléchargez la présentation en cliquant sur ce lien. Lors du téléchargement, si vous ne parvenez pas à télécharger une présentation, l’éditeur a peut-être supprimé le fichier de son serveur.Pendant le téléchargement, si vous ne parvenez pas à obtenir une présentation, le fichier a peut-être été supprimé par l’éditeur.

F I N

Plus de contenu associé

Transcription de la présentation

  1. Functions & Formulas

  2. What’s in it for you? • Functions & Formulas • Conditional Formatting • Data Validation • Pivot Chart & Pivot Table

  3. One day in a start-up…

  4. Functions & Formulas Click here to watch the video

  5. Now that our business is growing, we need to find an efficient way to work with data

  6. We have to find a way to work faster with storing and analyzing data

  7. Oh! Don’t worry. We can make use of Microsoft Excel to do this job

  8. Will Excel be able to cater to all our business needs?

  9. Yes! We can make use of excel in several ways. This will prove to be cost efficient as well

  10. If that’s the case, let’s go ahead with excel. Let’s train our employees in excel

  11. Yes! That will make the job easier for us. I will start their training right away

  12. Yes! That will make the job easier for us. I will start their training right away Before moving to understand excel in-depth, let’s have a look at the various benefits of using excel

  13. Why use Excel?

  14. Why use Excel? • Excel proves to be a great platform to perform various mathematical calculations on large datasets

  15. Why use Excel? • Excel proves to be a great platform to perform various mathematical calculations on large datasets • Various features in excel like searching, sorting, filtering make it easier for you to play with data • Excel allows you to beautify your data and present it in the form of charts, tables and data bars

  16. Why use Excel? • Reporting, accounting, and analysis can be performed with the help of excel • Excel can help you with your task lists, calendars, and goal planning worksheets • Excel provides good security for your data. Excel files have the feature of password-protection, this way your information is safe

  17. What is Excel?

  18. What is Excel? Microsoft excel is an application that is used for recording, analyzing and visualizing data. It is in the form of a spreadsheet

  19. Let’s have a look at few of the functions and formulas used in Excel Functions & Formulas

  20. Let’s have a look at few of the functions and formulas used in Excel Functions & Formulas • iseven • islogical • subtotal • int • sum • average

  21. Let’s have a look at few of the functions and formulas used in Excel Functions & Formulas • iseven • islogical • subtotal • int • sum • average • trunc • abs • sqrt • rept • count • max

  22. Let’s have a look at few of the functions and formulas used in Excel Functions & Formulas • iseven • islogical • subtotal • int • sum • average • trunc • abs • sqrt • rept • count • max • now • time • text • sumif • trim • len

  23. Conditional Formatting

  24. Conditional Formatting

  25. Conditional Formatting • It is a feature that allows you to format cells based on a pre-set condition

  26. Conditional Formatting • It is a feature that allows you to format cells based on a pre-set condition • Conditional Formatting helps you identify the required cells faster • It also helps you highlight a few significant cells • It is easy to perform conditional formatting as shown alongside, as the options are ready available in Excel

  27. Join us to learn more! simplilearn.com UNITED STATES Simplilearn Solutions Pvt. Limited 201 Spear Street, Suite 1100 San Francisco, CA 94105 Phone: (415) 741-3319 INDIA Simplilearn Solutions Pvt. Limited #53/1C, 24th Main, 2nd Sector HSR Layout, Bangalore 560102 Phone: +91 8069999471 UNITED STATES Simplilearn Solutions Pvt. Limited 801 Corporate Center Drive, Suite 138 Raleigh, NC 27607 Phone: (919) 205-5565