Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Microsoft Excel 365 Bootcamp
Rating: 4.5 out of 5(5 ratings)
55 students

Microsoft Excel 365 Bootcamp

Go from zero to hero in Microsoft Excel 365 and learn how to analyse Data in Excel 365
Created byRicky Lahiri
Last updated 7/2023
English

What you'll learn

  • Microsoft Excel 365
  • Data Visualisation in Excel 365
  • Statistical tools in Excel 365
  • Pivot Plots and Charts in Excel 365
  • Solving Equations in Excel 365
  • Conditional Statements in Excel 365
  • Lookup and database functions in Excel 365
  • What-if-analysis in Excel 365
  • How to clean up data in Excel

Course content

10 sections • 34 lectures • 2h 52m total length

  • Excel Walkthrough5:39

    Students will be given a brief walkthrough of Excel

  • Cell referencing worksheets and adding and deleting worksheets2:16

    Students will be taught how to reference cells and add and delete worksheets.

  • Absolute and Relative Referencing8:15

    Students will be taught Absolute and Relative Referencing.

  • Insert rows, columns and cells2:00

    Students will be taught how to insert columns , rows and cells

  • Enter values into cells1:15

    Students will be taught how to input values into cells

  • Pasting Cells and Values2:31

    Students will be taught how to paste values and cells

  • Importing Files into Excel0:59

    Students will be taught how to import files into Excel

  • Power Query and Cleaning up data8:46

    Students will be taught how to use power query and how to clean up data

  • Conditional Formating1:21

    Students will be taught conditional formating.

Requirements

  • A computer with Microsoft Excel installed on it.

Description

Microsoft Excel 365 Bootcamp is a course that has been designed to allow students to master Excel 365 and learn all the nuances of Excel 365. In this course I begin with the very basics, and then advance step by step to more advanced concepts , tools and techniques that can be used in Excel. The course is designed for those who want to learn the diverse range of applications that Excel is capable of.  This course will allow students to not only master Excel applications, but also to use Excel in a wide variety of situations upon completion of the course. Budding business analysts, business intelligence analysts, data analysts can use Excel to visualise data, generate pivot plots and tables, conduct statistical analysis, solve equations, and this course is designed to impart the aforementioned skills to students. The course uses a learning by doing format, which means that all the lectures are taught in Excel with a hands on approach. Real world examples are used to demonstrate concepts, and practical data is used to demonstrate various Excel tools. At the end of the course, students will be well equipped to use Excel for providing business solutions. The course teaches the following topics:

1. Introduction to Excel

2. Importing Data

3. Basic Operations in Excel

4. Statistical functions and applications.

5. Logical Operators and Conditional Statements in Excel

6. Data Visualisation.

7. Solving Equations in Excel

8. What if analysis

9. Look up and match functions.

10. Pivot tables and charts

11. Statistical Data Analysis in Excel

Who this course is for:

  • Beginners in Excel who was to master excel
  • Beginner data analysts who want to learn how to conduct data analysis in Excel
  • People who want to learn data visualisation and statistics in Excel
  • People who want to learn the most used Excel functions
  • People who want to learn how to solve equations in Excel
  • People looking for a career in data analytics, business analytics and business intelligence
  • People who want to learn the nuances of Excel 365 in depth
  • People who want to learn Excel tools and tricks
  • People who want to learn how to clean up data in Excel

Report abuse