Welcome to Mobilarian Forum - Official Symbianize forum.

Join us now to get access to all our features. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, and so, so much more. It's also quick and totally free, so what are you waiting for?

Microsoft Excel 365 Bootcamp

O 0


Alpha and Omega
Nov 24, 2022
Reaction score
1 years of service


Microsoft Excel 365 Bootcamp
Published 3/2023
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 1.88 GB | Duration: 2h 53m

Go from zero to hero in Microsoft Excel 365​

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

A computer with Microsoft Excel installed on it.

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 Excel2. Importing Data3. Basic Operations in Excel4. Statistical functions and applications.5. Data Visualisation.6. Solving Equations in Excel7. What if analysis8. Look up and match functions.9. Pivot tables and charts10. Statistical Data Analysis in Excel

Section 1: A walkthrough of Excel

Lecture 1 Excel Walkthrough

Lecture 2 Cell referencing worksheets and adding and deleting worksheets

Lecture 3 Absolute and Relative Referencing

Lecture 4 Insert rows, columns and cells

Lecture 5 Enter values into cells

Lecture 6 Pasting Cells and Values

Lecture 7 Importing Files into Excel

Lecture 8 Power Query and Cleaning up data

Lecture 9 Conditional Formating

Section 2: Mathematical and Numerical Operations in Excel

Lecture 10 Basic Operations in Excel

Lecture 11 Formulas in Excel

Lecture 12 Sorting and Filtering

Lecture 13 Statistical Functions

Lecture 14 Rounding Values

Lecture 15 Autosum Function

Lecture 16 SUMIF and AVERAGEIF Functions

Lecture 17 COUNTIF

Lecture 18 Dealing with missing values

Section 3: String Operations in Excel

Lecture 19 Dealing with Strings in Excel

Lecture 20 Changing data from string to numeric

Lecture 21 CONCATENATE, LOWER, UPPER functions for string manipulation

Section 4: Conditional Statements

Lecture 22 IF and Nested IF statements

Lecture 23 Logical Operators in Excel


Section 5: Plots in Excel

Lecture 25 Different Types of Plots in Excel

Section 6: Database Functions in Excel

Lecture 26 HLOOKUP

Lecture 27 VLOOKUP

Lecture 28 MATCH

Section 7: What if analysis

Lecture 29 What-if-analysis

Section 8: Using Solver to solve equations

Lecture 30 Using Solver to solve equations

Section 9: Pivot Tables and Pivot Charts

Lecture 31 Pivot Tables and Pivot Charts

Section 10: Statistical Data Analysis

Lecture 32 Descriptive Statistics

Lecture 33 Correlation Analysis

Lecture 34 Regression Analysis

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

You must reply in thread to view hidden text.

You must reply in thread to view hidden text.

You must reply in thread to view hidden text.

You must reply in thread to view hidden text.
K 0

KatzSec DevOps

Alpha and Omega
Jan 17, 2022
Reaction score
2 years of service
oaxino salamat sa pag contribute. Next time always upload your files sa
Please, Log in or Register to view URLs content!
para siguradong di ma dedeadlink. Let's keep on sharing to keep our community running for good. This community is built for you and everyone to share freely. Let's invite more contributors para mabalik natin sigla ng Mobilarian at tuloy ang puyatan. :)
Top Bottom