When you enroll through our links, we may earn a small commission—at no extra cost to you. This helps keep our platform free and inspires us to add more value.

Development
SkillShare logo

Microsoft Excel 365 Bootcamp: Master working with data in Microsoft Excel 365

Unlock creativity with Skillshare! Learn acrylic painting, AI writing, graphic design, and photography.

     0 |
  • Reviews ( 0 )
Free
Microsoft Excel 365 Bootcamp: Master working with data in Microsoft Excel 365

Related Courses

This Course Includes

  • iconskillshare
  • icon0 (0 reviews )
  • icon3 hours 31 minutes
  • iconenglish
  • iconOnline - Self Paced
  • iconcourse
  • iconSkillShare

About Microsoft Excel 365 Bootcamp: Master working with data in Microsoft Excel 365

Introduction

Excel Walkthrough

Cell Referencing, Work Sheets, and Adding or Deleting worksheets

Absolute and Relative Referencing

Insert rows, columns, and cells

Enter Values into Cells

Pasting Cells and Values

Importing files into Excel

Power Query and cleaning up data

Conditional Formating

Basic Operations in Excel

Formulas in Excel

Sorting and Filtering

Statistical Functions

Rounding Values

Autosum

Sumif, Averageif

COUNTIF

Dealing with missing values

Dealing with strings in Excel

Changing data from string to numeric

Concatenate, Upper or Lower Functions for string manipulation

If statements and Nested Ifs

Logical Operators in Excel

Isnumber, Isblank, and Iserror

Data Visualization in Excel

Data Analysis: Summary Statistics

Data Analysis: Correlation

Data Analysis: Regression

HLOOKUP

VLOOKUP

Match

What If Analysis in Excel

Using Solver to Solve Equations

Pivot tables and Pivot charts

Statistical Analysis Process

What You Will Learn?

  • Microsoft Excel 365 bootcamp is a course that exposes students to data analytics tools available in Excel. The course begins with the basics of Excel ( for those who are new to Excel) and then progresses to more advanced tools such as the data analysis toolpack, solver, what-if-analysis, conditional statements, pivot charts, pivot tables etc. In this course students will learn through hands on , practical demonstrations of Excel tools for data analysis and will gain practical knowledge of applying these tools through the final project. The course covers basics to advanced tools, and students will learn applications of these tools in business. Real data is used to teach the concepts and this allows students to gain an understanding of how the Excel tools taught can be applied to the real world. After finishing this course students will learn how to use data and Excel tools to solve business problems, how to study trends in data and use these trends to infer about the business setting they are studying. . The course covers the following topics:.
  • 1. Introduction to Excel.
  • 2. Importing Data.
  • 3. Basic Operations in Excel.
  • 4. Statistical functions and applications..
  • 5. Data Visualisation..
  • 6. Data Analysis using Excel.
  • 7. Solving Equations in Excel.
  • 8. What if analysis.
  • 9. Look up and match functions..
  • 10. Pivot tables and charts.
  • 11. Statistical Analysis in Excel.
  • Prerequisites:.
  • 1. Basic High School Mathematics.
  • 2. Basic knowledge of statistical concepts such as mean, media, mode, standard deviation etc..
  • 3. A computer with Mac OS or Windows.
  • 4. Eagerness to learn.