Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Language
English
Taught by
Skillademia Academy
Certificate
- Available
- *The delivery and distribution of the certificate are subject to the policies and arrangements of the course provider.
Rating
Course Overview
Learn how to use Microsoft Excel like a pro with this step-by-step course!
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 Content
- 48 section(s)
- 266 lecture(s)
- Section 1 Introduction
- Section 2 Getting to know the Interface
- Section 3 Using Formulae in Excel
- Section 4 Protecting Cells and Worksheets
- Section 5 Data, Formatting and the First Function
- Section 6 Basic Functions in Excel
- Section 7 Shapes and Images
- Section 8 Importing Data into Excel
- Section 9 Averages in Excel
- Section 10 Using Lookups in Excel
- Section 11 More Functions in Excel
- Section 12 Functions and Conditions
- Section 13 Working with Dates and Text
- Section 14 Simple Graphs and Charts
- Section 15 Handling Text and Importing WWW Data
- Section 16 Generating Test Data
- Section 17 Creating a Budgetary System
- Section 18 Revision Exercise: Astronomical Modelling
- Section 19 New Functions in Excel 365
- Section 20 More Basic Features of Excel
- Section 21 Introduction to Data Visualization
- Section 22 Data Visualization through Tables
- Section 23 From Tabular to Graphical Representation
- Section 24 Chart Customizations
- Section 25 Must-Know Charts & Graphs
- Section 26 Specialized Charts & Graphs
- Section 27 Useful Visualizations
- Section 28 Dashboards in Excel
- Section 29 Excel for Cartography
- Section 30 Excel Add-Ins for Visualization
- Section 31 Managing and Presenting Visualizations
- Section 32 Introduction to Data Analysis
- Section 33 Reviewing the Basics
- Section 34 Data Cleaning and Preparation
- Section 35 Pivot Tables
- Section 36 Power Query
- Section 37 Power Pivot
- Section 38 Dynamic Array Formulas
- Section 39 Predictive Analysis
- Section 40 Additional Practice and Exercises
- Section 41 Capstone Project
- Section 42 Introduction to Excel Programming
- Section 43 Visual Basic for Applications and Getting Started
- Section 44 Menus and Tools
- Section 45 First Code and Statements
- Section 46 Variables
- Section 47 Procedures
- Section 48 Application Methods and Additional Topics
What You’ll 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
Skills covered in this course
Reviews
-
KKhomotso Matlou
Yes, I have learn alot.
-
MMelanie H. Ebrole
So far, it is very concise, clear and easy to follow.
-
MMatthew Richard Guilfoyle
It was a very educational and enjoyable course.
-
LLatif BORA
Good expression, i teach easily.
