Complete Excel Megacourse: Beginner to Expert

Complete Excel Megacourse: Beginner to Expert, available at $64.99, has an average rating of 4.34, with 266 lectures, based on 452 reviews, and has 23873 subscribers.

You will learn about How to use Microsoft Excel and its basic functions How to create worksheets Everything about using and formatting cells How to use autofill The principles and use of formulas How to manipulate data through different functions How to use and master Excel’s most famous functions: AVERAGE, SUM, PRODUCT, COUNT, COUNTA, IF, COUNTIF Simple graphs and charts How to create a budgetary system All the new functions in Excel 365 How to customize your charts How to use dashboards How to create 2D or 3D maps How to use Pivot Tables, Power Query, Power Pivot, and Dynamic Array Formulas to analyze large datasets efficiently Techniques for cleaning and preparing data to ensure accurate analysis results Tips and tricks for using Excel functions to check and manipulate data This course is ideal for individuals who are Anyone who wants to learn to use Microsoft Excel – no experience needed! or Professionals who want to learn new tools of Excel or Anyone who wants take their Excel skills from beginner to advanced or Anyone with specialised needs (data analysts, businessmen, students, researchers, etc.) It is particularly useful for Anyone who wants to learn to use Microsoft Excel – no experience needed! or Professionals who want to learn new tools of Excel or Anyone who wants take their Excel skills from beginner to advanced or Anyone with specialised needs (data analysts, businessmen, students, researchers, etc.).

Enroll now: Complete Excel Megacourse: Beginner to Expert

Summary

Title: Complete Excel Megacourse: Beginner to Expert

Price: $64.99

Average Rating: 4.34

Number of Lectures: 266

Number of Published Lectures: 266

Number of Curriculum Items: 266

Number of Published Curriculum Objects: 266

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will Learn

How to use Microsoft Excel and its basic functions
How to create worksheets
Everything about using and formatting cells
How to use autofill
The principles and use of formulas
How to manipulate data through different functions
How to use and master Excel’s most famous functions: AVERAGE, SUM, PRODUCT, COUNT, COUNTA, IF, COUNTIF
Simple graphs and charts
How to create a budgetary system
All the new functions in Excel 365
How to customize your charts
How to use dashboards
How to create 2D or 3D maps
How to use Pivot Tables, Power Query, Power Pivot, and Dynamic Array Formulas to analyze large datasets efficiently
Techniques for cleaning and preparing data to ensure accurate analysis results
Tips and tricks for using Excel functions to check and manipulate data

Who Should Attend

Anyone who wants to learn to use Microsoft Excel – no experience needed!
Professionals who want to learn new tools of Excel
Anyone who wants take their Excel skills from beginner to advanced
Anyone with specialised needs (data analysts, businessmen, students, researchers, etc.)

Target Audiences

Anyone who wants to learn to use Microsoft Excel – no experience needed!
Professionals who want to learn new tools of Excel
Anyone who wants take their Excel skills from beginner to advanced
Anyone with specialised needs (data analysts, businessmen, students, researchers, etc.)

Learn Microsoft Excel!

Have you ever wanted to be able to use Microsoft Excel – the largest spreadsheets program, like a pro? From managing your accounts to running your business’ finances, modelling chaos to simulating airports, recording your progress to planning your time; spreadsheets are an invaluable tool to learn and understand. Whether you’re looking to record your home incomings and outgoings, or want to explore Excel for its mathematical opportunities, investigate the statistical tools, and its data analysis wizards, this course is for you.

In this course, you’re going to learn everything you need to know to get started with Excel. You will explore what cells and worksheets are, how to enter formulae, manipulate data through functions and present the data in an effective fashion. You’ll even learn how to use Excel to develop diverse and interesting solutions to problems, as well as learn the individual techniques and how to apply them to a solution.

Our instructor has many years of experience teaching Excel to a wide range of audiences – from very young children through to professionals, and the expertly-crafted syllabus is designed to be easy to follow and thorough. We’ve also included plenty of practical examples explained and done on-screen for you to study. That’s why this is the only Microsoft Excel course you’ll ever need to master this software!

Start using Excel today!

After taking this course you’ll be able to:

Work professionally with Microsoft Excel and its advanced features
Solve real work problem with the help of Excel
Use the elements and theories in Excel to make your work processes better
Create your own KPI or Investment Dashboard
Create a Web Analytics Report
Make a Daily Activity Tracker
Use predictive analysis and Excel’s predictive shortcuts to gain insights and make data- drive decisions
Confidently analyze large datasets using Excel’s advanced data analysis tools

Course Curriculum

Chapter 1: Introduction

Lecture 1: What is Microsoft Excel

Lecture 2: How do I get Microsoft Excel

Lecture 3: How do I open Microsoft Excel

Chapter 2: Getting to know the Interface

Lecture 1: Cell, Worksheets and Workbooks

Lecture 2: The Ribbon Toolbar

Lecture 3: Selecting Cells and The Name Box

Lecture 4: Altering Rows and Columns

Lecture 5: Borders

Lecture 6: Revision: Times Table Square

Chapter 3: Using Formulae in Excel

Lecture 1: Exploring Data Types

Lecture 2: Formatting Data

Lecture 3: Creating a Series

Lecture 4: Creating Formulae

Lecture 5: Formulae and Autofill (Relative Addressing)

Lecture 6: Resolving Relative Addressing Issues (Absolute Addressing)

Lecture 7: Formatting Cells

Lecture 8: Revision: Times Table Square

Chapter 4: Protecting Cells and Worksheets

Lecture 1: Protecting Worksheets

Lecture 2: Restricting Data in Cells

Chapter 5: Data, Formatting and the First Function

Lecture 1: Creating Lists

Lecture 2: Adding and Deleting Rows and Columns

Lecture 3: Conditional Formatting

Lecture 4: Introducing Functions – MOD

Lecture 5: Revision: Times Table Square

Chapter 6: Basic Functions in Excel

Lecture 1: Introducing Battleships

Lecture 2: The IF Function

Lecture 3: The COUNTIF Function

Lecture 4: The COUNTA Function

Lecture 5: Nested IFs

Lecture 6: The SUM Function

Lecture 7: Named Ranges

Lecture 8: Revision: Battleships

Chapter 7: Shapes and Images

Lecture 1: 3D Formulae

Lecture 2: Shapes

Lecture 3: Images

Lecture 4: Revision: Battleships

Lecture 5: Revision: Battleships

Chapter 8: Importing Data into Excel

Lecture 1: Using CSV files

Lecture 2: Exporting Data into a CSV file

Lecture 3: Issues with CSV files

Lecture 4: Importing CSV files Using the Legacy Wizard

Chapter 9: Averages in Excel

Lecture 1: The AVERAGE Function

Lecture 2: The MEDIAN Function

Lecture 3: The MODE Function

Lecture 4: The MODE.SNGL Function

Lecture 5: The MODE.MULT function

Lecture 6: Revision: Gradebook

Chapter 10: Using Lookups in Excel

Lecture 1: The VLOOKUP Function

Lecture 2: The HLOOKUP Function

Chapter 11: More Functions in Excel

Lecture 1: The MAX and MIN Functions

Lecture 2: The RAND and RANDBETWEEN Functions

Lecture 3: The INDEX Function

Lecture 4: The MATCH Function

Lecture 5: Filters

Lecture 6: Revision: Gradebook

Chapter 12: Functions and Conditions

Lecture 1: The SUMIF Function

Lecture 2: The SUMIFS Function

Chapter 13: Working with Dates and Text

Lecture 1: Working with Dates

Lecture 2: Working with Text

Chapter 14: Simple Graphs and Charts

Lecture 1: Simple Bar Graphs

Lecture 2: Pie Charts

Lecture 3: Scattergraphs

Lecture 4: Scattergraphs 2

Chapter 15: Handling Text and Importing WWW Data

Lecture 1: Manipulating Text

Lecture 2: More Manipulating Text

Lecture 3: Importing Data from the Web

Chapter 16: Generating Test Data

Lecture 1: Creating Test Data Pt. 1

Lecture 2: Creating Test Data Pt. 2

Chapter 17: Creating a Budgetary System

Lecture 1: Developing a Budget Spreadsheet

Lecture 2: Continuing the Budget Spreadsheet

Chapter 18: Revision Exercise: Astronomical Modelling

Lecture 1: Revision: Astronomical Modeling Pt. 1

Lecture 2: Revision: Astronomical Modeling Pt. 2

Lecture 3: Revision: Astronomical Modeling Pt. 3

Lecture 4: Revision: Astronomical Modeling Pt. 4

Chapter 19: New Functions in Excel 365

Lecture 1: UNIQUE and Spills

Lecture 2: The IFS Function

Lecture 3: The MAXIFS Function

Lecture 4: The MINIFS Function

Lecture 5: The SWITCH Function

Lecture 6: The SORT Function

Lecture 7: The XMATCH Function

Instructors

Creativity Unleashed
Amazing online courses to unleash your creativity

Rating Distribution

1 stars: 7 votes
2 stars: 9 votes
3 stars: 46 votes
4 stars: 157 votes
5 stars: 233 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu