1 / 27
271 likes | 355 Views
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.<br><br>This Data Analyst Masteru2019s 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.<br><br><br>Why become Data Analyst?<br>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 todayu2019s 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. <br><br>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.<br><br>Who should take up this course?<br>Aspiring professionals of any educational background with an analytical frame of mind are best suited to pursue the Data Analyst Masteru2019s Program, including:<br>1. IT professionals<br>2. Banking and finance professionals<br>3. Marketing managers<br>4. Sales professionals<br>5. Supply chain network managers<br>6. Beginners in the data analytics domain<br>7. Students in UG/ PG programs<br><br>ud83dudc49Learn more at: https://bit.ly/2SECA5r<br><br>
E N D
What’s in it for you? • Functions & Formulas • Conditional Formatting • Data Validation • Pivot Chart & Pivot Table
Functions & Formulas Click here to watch the video
Now that our business is growing, we need to find an efficient way to work with data
We have to find a way to work faster with storing and analyzing data
Oh! Don’t worry. We can make use of Microsoft Excel to do this job
Yes! We can make use of excel in several ways. This will prove to be cost efficient as well
If that’s the case, let’s go ahead with excel. Let’s train our employees in excel
Yes! That will make the job easier for us. I will start their training right away
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
Why use Excel? • Excel proves to be a great platform to perform various mathematical calculations on large datasets
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
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
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
Let’s have a look at few of the functions and formulas used in Excel Functions & Formulas
Let’s have a look at few of the functions and formulas used in Excel Functions & Formulas • iseven • islogical • subtotal • int • sum • average
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
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
Conditional Formatting • It is a feature that allows you to format cells based on a pre-set condition
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
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
