Microsoft 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.
Over 312,124+ happy students choose Skillademia
14.5 hours
Level required for the course
Beginner
Learning material in this course
$0.2 lesson
Price per lesson for the course

Course Introduction

“Revived our business.”
“Visual perfection!”
“Templates don’t come better.”

Course includes

Build an advanced NFT character from complete scratch – unleash your creativity.
Learn to draw figures, bodies, guns, shields.
Learn how to design stunning backgrounds.
Learn how to learn from the very best.
Lines, shapes, eyes, ears, faces –– an advanced guide on how to make all elements stand out beautifully from all the noise.
Learn how to texturize characters
Learn how to apply shades to certain elements
Learn how to balance all aspects of colour
From free to professional software –– our challenge provides easy-to-use software tutorials to get you started quickly.
Learn Procreate (professional art software)
Learn Aseprite (animation software)
Learn to use Piskel (free pixel art software)

What’s a Rich Text element?

The rich text element allows you to create and format headings, paragraphs, blockquotes, images, and video all in one place instead of having to add and format them individually. Just double-click and easily create content.

Static and dynamic content editing

A rich text element can be used with static or dynamic content. For static content, just drop it into any page and begin editing. For dynamic content, add a rich text field to any collection and then connect a rich text element to that field in the settings panel. Voila!

How to customize formatting for each rich text

Headings, paragraphs, blockquotes, figures, images, and figure captions can all be styled after a class is added to the rich text element using the "When inside of" nested selector system.

This is some text inside of a div block.
This is some text inside of a div block.

Not only valuable, but also super fun.

Earn extra $12k per year on the side.

The Pixel Art industry is ripe with freelancing opportunities. Learn this skill and be able to earn!

Zero previous experience required.

We take you from a complete beginner and guide you every step of the way.

Step-by-step guides, tutorials and more.

Everything you need to learn to create a pixel NFT character is in this $5 course.

Theory mixed with actual practice.

Test your theoretical skills with practical examples and exciting challenges.
Awesome job opportunities
25
You have received 41+ new freelance job offers
Client 1 –– Small order
$75.00
Client 2 –– Bigger order
$1280.00
Your freelance gigs
per month
$1351
Curriculum for Learn Excel

14.5 hours of valuable material

20 sections • 96 lectures • 14h 25m total length
Introduction • 3 Lessons • 9 Min

  What is Microsoft Office • 02:29

  How do I get Microsoft Excel • 03:58

  How do I open Microsoft Excel • 02:13

Getting to know the Interface • 6 Lessons • 57 Min

  Cell, Worksheets, and Workbooks • 09:05

  The Ribbon Toolbar • 09:30

  Selecting Cells and The Name Box • 11:03

  Altering Rows and Columns • 10:20

  Borders • 09:06

  Revision: Times Table Square • 08:07

Using Formulae in Excel • 8 Lessons • 1 Hr 29 Min

  Exploring Data Types • 11:47

  Formatting Data • 14:49

  Creating a Series • 07:52

  Creating Formulae • 11:22

  Formulae and Autofill (Relative Addressing) • 12:27

  Resolving Relative Addressing Issues (Absolute Addressing) • 13:27

  Formatting Cells • 09:55

  Revision: Times Table Square • 07:49

Protecting Cells and Worksheets • 2 Lessons • 16 Min

  Protecting Worksheets • 10:22

  Restricting Data in Cells • 05:16

Data, Formatting and the First Function • 5 Lessons • 53 Min

  Creating Lists • 04:07

  Adding and Deleting Rows and Columns • 05:21

  Conditional Formatting • 10:05

  Introducing Functions - MOD • 12:41

  Revision: Times Table Square • 20:59

Basic Functions in Excel • 8 Lessons • 1 Hr 7 Min

  Introducing Battleships • 13:13

  The IF Function • 10:00

  The COUNTIF Function • 02:09

  The COUNTA Function • 02:34

  Nested IFs • 08:02

  The SUM Function • 05:51

  Named Ranges • 06:09

  Revision: Battleships • 18:44

Shapes and Images • 5 Lessons • 48 Min

  3D Formulae • 02:36

  Shapes • 03:36

  Images • 09:52

  Revision: Battleships • 13:48

  Revision: Battleships • 17:54

Importing Data into Excel • 4 Lessons • 41 Min

  Using CSV files • 15:47

  Exporting Data into a CSV file • 08:04

  Issues with CSV files • 08:35

  Importing CSV files Using the Legacy Wizard • 08:38

Averages in Excel • 6 Lessons • 53 Min

  The AVERAGE Function • 14:42

  The MEDIAN Function • 10:07

  The MODE Function • 05:58

  The MODE.SNGL Function • 03:01

  The MODE.MULT function • 04:37

  Revision: Gradebook • 14:29

Using Lookups in Excel • 2 Lessons • 16 Min

  The VLOOKUP Function • 11:32

  The HLOOKUP Function • 04:49

More Functions in Excel • 6 Lessons • 34 Min

  The MAX and MIN Functions • 02:09

  The RAND and RANDBETWEEN Functions • 07:26

  The INDEX Function • 01:58

  The MATCH Function • 05:00

  Filters • 05:07

  Revision: Gradebook • 11:51

Functions and Conditions • 2 Lessons • 9 Min

  The SUMIF Function • 03:15

  The SUMIFS Function • 05:16

Working with Dates and Text • 2 Lessons • 9 Min

  The SUMIF Function • 03:15

  The SUMIFS Function • 05:16

Simple Graphs and Charts • 4 Lessons • 41 Min

  Simple Bar Graphs • 06:14

  Pie Charts • 03:50

  Scattergraphs • 18:00

  Scattergraphs 2 • 13:12

Handling Text and Importing WWW Data • 3 Lessons • 37 Min

  Manipulating Text • 12:23

  More Manipulating Text • 17:00

  Importing Data from the Web • 07:53

Generating Test Data • 2 Lessons • 41 Min

  Creating Test Data Pt. 1 • 22:17

  Creating Test Data Pt. 2 • 19:05

Creating a Budgetary System • 2 Lessons • 51 Min

  Developing a Budget Spreadsheet • 28:49

  Continuing the Budget Spreadsheet • 21:56

Revision Exercise: Astronomical Modelling • 4 Lessons • 1 Hr 19 Min

  Revision: Astronomical Modeling Pt. 1 • 21:24

  Revision: Astronomical Modeling Pt. 2 • 23:39

  Revision: Astronomical Modeling Pt. 3 • 27:56

  Revision: Astronomical Modeling Pt. 4 • 05:32

New Functions in Excel 365 • 13 Lessons • 1 Hr 5 Min

  UNIQUE and Spills • 09:07

  The IFS Function • 08:58

  The MAXIFS Function • 02:21

  The MINIFS Function • 01:09

  The SWITCH Function • 02:33

  The SORT Function • 02:55

  The XMATCH Function • 08:22

  The LET Function • 03:30

  The XLOOKUP Function • 04:20

  The FILTER Function • 02:11

  The SORTBY Function • 02:12

  The SEQUENCE Function • 05:53

  Revision: Combining Functions • 11:27

More Basic Features of Excel • 9 Lessons • 52 Min

  The RANDARRAY Function • 07:48

  Text to Columns • 01:27

  Zooms and Sheet Selections • 02:21

  Logical Functions • 10:09

  ODDs and EVENs • 06:47

  Trigonometry • 10:06

  Ceilings and Floors • 06:07

  Reviewing all our Learning • 06:24

  Last Words • 00:31

HIDE
HIDE
HIDE
HIDE

Skillademia provides the most value-dense courses, on earth.

Our team of production managers, teachers, content creators, and educators provide the most streamlined systems for creating a lot of valuable content.
$0.6 per hour
Skillademia
$3 per hour
Average

23 hours

Average amount of content in a single Skillademia course.

$0.6 per hour

Average price for a course

Easy-entry barrier

Higher education costs upwards of $10k per year, while courses don't provide much value. Skillademia is the opposite.

Community-support

Learn together with your tribe of passionate learners. Community support, helpful guidance, and like-minded people.

Step-by-step guides

Skillademia takes complete novices and guides them to become a pro. So fun and exciting, a toddler could learn Photoshop.
Pivot
Saturday
Petsky
Course material
Valuable
Developer API
Hours of material
Unlimited
10
10
Server Location
Global
US Central
US Central
Servers
Global
US Central
US Central
Rollback API
Designer Features
Websites
Unlimited
Per Site
5
24/7 Support
HTML Export
Monthly Visits
Unlimited
20,000
10,000
SVG Editing

Microsoft 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.
Over 312,124+ happy students choose Skillademia
14.5 hours
Level required for the course
Beginner
Learning material in this course
$0.2 lesson
Price per lesson for the course

Zero previous knowledge required.

Take your first step in learning Learn Excel like a pro.
Buy full course for $18.99

Search Pivot