Excel 2022 for Data Analysis: Beginners Online Training

Focused View

Jonathan Barrios

4:31:46

146 View

1. Analyze Data with Excel

1. Foundational Statistics for Data Analysis with Excel Analyze Data with Excel .mp4

01:51

2. Excel for Data Analytics .mp4

08:10

3. Excel User Interface .mp4

08:58

4. Excel Data Types .mp4

07:24

5. Excel Formula Basics .mp4

09:25

6. Excel Analysis ToolPak .mp4

07:27

2. Manipulate Data with Excel

1. Introduction .mp4

01:39

2. Excel Numeric Functions .mp4

11:17

3. Excel Text Functions .mp4

10:03

4. Excel Date Functions .mp4

08:57

5. Relative and Absolute Cell References .mp4

08:03

6. Sorting and Filtering Data .mp4

07:14

7. Removing Duplicate Data .mp4

04:10

3. Identify Foundational Statistics for Data Analysis

1. Introduction .mp4

04:15

2. What is Statistics .mp4

13:45

3. Statistical Data Types .mp4

08:19

4. Important Statistical Terminology .mp4

08:41

5. Data Analysis Types .mp4

06:13

6. Programming Languages .mp4

06:56

7. Analytics Suites .mp4

07:22

4. Apply Descriptive Statistics

1. Introduction .mp4

03:46

2. Measures of Central Tendencies .mp4

11:24

3. Measures of Dispersion .mp4

08:41

4. Variance .mp4

13:52

5. Standard Deviation .mp4

11:46

6. Z-Scores .mp4

11:35

7. Percentages .mp4

08:44

5. Apply Inferential Statistics

1. Introduction .mp4

03:49

2. Confidence Intervals Part 1 .mp4

12:38

3. Confidence Intervals Part 2 .mp4

05:29

4. Hypothesis Testing .mp4

14:07

5. AA Test Part 1 .mp4

09:06

6. AA Test Part 2 .mp4

06:40

Description

This entry-level Excel 2022 for Data Analysis: Beginners training prepares technical and non-technical professionals to take huge amounts of data or big confusing spreadsheets and use Excel to extract meaningful information that can help make better business decisions.

Too many people think that learning about Microsoft Excel functions and formulas will be a dry and uninteresting slog that won't help them in the long run. The truth is that even the tiniest familiarity with Excel can not only make your job easier but help you organize and manipulate data in order to answer business questions.

More details

This course will show you the simple steps you can follow to make your Excel spreadsheets do more for you and act how you want them to. Excel was designed to do tons of work for you automatically. Take this course and learn exactly how to unlock all that potential.

Once you're done with this data analysis skills training, you'll know how to take huge amounts of data or big confusing spreadsheets and use Excel to extract meaningful information that helps make better business decisions.

For anyone who manages technical and non-technical professionals, this data analysis training can be used to onboard technical and non-technical professionals, curated into individual or team training plans, or as a data analysis reference resource.

Excel 2022 for Data Analysis: Beginners: What You Need to Know

This Excel 2022 for Data Analysis: Beginners training covers Excel topics including:

Finding your way around spreadsheets
Reading, writing, and updating formulas in Excel
Using the power of Excel to do the heavy lifting of analysis for you

Who Should Take Excel 2022 for Data Analysis: Beginners Training?

This Excel 2022 for Data Analysis: Beginners training is considered foundational-level data analysis training, which means it was designed for technical and non-technical professionals. This Excel skills course is valuable for new IT professionals with at least a year of experience with data analysis tools and experienced technical and non-technical professionals looking to validate their data analysis skills.

New or aspiring technical and non-technical professionals. If you've ever seen a really good spreadsheet with automatic formatting and fancy formulas, you know how powerful Excel can be. This Microsoft Excel course is designed to show you how to analyze and visualize data in order to tell compelling stories or answer complicated business questions â€” no matter your familiarity with Excel spreadsheets or data analysis.

Experienced technical and non-technical professionals. If you've been working in an office for a few years, you know that data analysis isn't a specialized skill that only a handful of people do. Most professionals do data analysis of some kind, and this Excel course can ensure you know all the tricks, secrets, and formulas you should be aware of in order to properly analyze data with Excel.

User Reviews

Rating

average 0

Total votes0

Focused display

Data Analysis

Excel

Excel Analytics

Excel Dashboard

Excel Modeling

Excel Charts

Jonathan Barrios

Instructor's Courses

"Helping aspiring data professionals learn about data and seeing them succeed is one of my greatest passions as a trainer. I love to learn, share my knowledge, and help others succeed—this is why I am passionate about being a trainer at CBT Nuggets."

Jonathan started his career as a full-stack developer and quickly became interested in combining his online education experience with his data science and machine learning knowledge. Jonathan has been a programmer, data analytics instructor, and curriculum writer for several leading online education platforms is excited to share his skills and education experience with aspiring data practitioners at CBT Nuggets.

Certifications: None

Areas of expertise: Full-stack software development, data analytics, data science, machine learning, and cloud technologies such as AWS and Google Cloud. HTML, CSS, JavaScript, PHP, Python, SQL, NoSQL, and frameworks/libraries such as Laravel, Vue, Tailwind, React, Gatsby, Django, NumPy, pandas, Matplotlilb, Scrappy, BeautifulSoup, SciPy, Seaborn, Plotly, Scikit-learn, Tensorflow, and PySpark.

CBT Nuggets

View courses CBT Nuggets

CBT Nuggets is renowned for providing innovative training that's informative, meaningful, and engaging. We provide a variety of training, primarily in IT, project management, and office productivity topics. Our comprehensive library contains thousands of training videos ranging from Cisco networking to Microsoft Word. Whether you want to pass a certification exam, increase your skills, or simply learn new things, we've got you covered! All of our training is delivered through high-quality online streaming video. Subscribers can train 24 hours a day, seven days a week, from the convenience of a computer or mobile device. CBT Nuggets trainers are the rock stars of training, renowned for their expertise, industry-wide credibility, and engaging personalities. They enable CBT Nuggets to deliver accurate, up-to-date training, using a laid-back whiteboard presentation style. There are no scripts, EVER. Our trainers love to teach, and it shows! CEO and founder Dan Charbonneau was a Microsoft trainer when he began recording CBT Nuggets' very first training videos back in the 1990s. He wanted to help provide large organizations, small teams and individuals with comprehensive and budget-conscious training, and he realized it couldn't be done in a classroom. From the CBT Nuggets World Headquarters in Eugene, Oregon, Dan and his team promise each video will be informative, comprehensive, accurate, and fun to watch.