Task-based learning

Learn in-demand skills at your owntime, comfort and pace

Made by humans, powered by AI

Our Excel Course

Excel for Analysts

Learn Excel from zero by taking on the role of a junior analyst. Through one continuous project, you will learn the Excel essentials an analyst needs for their daily tasks, along with the keyboard shortcuts that speed up and simplify your workflow. By the end, you will have built an automated interactive report that generates PDF files in a single click.

How it works View Course

What you will see visually

How it works

This is the lesson screen. Hover over each section to see what it does.

Lesson timeline

The module's lessons are shown on a single line. A green dot marks a completed lesson, a gray one is a lesson still to come and the blue ring - the lesson you are on.

Excel for Analysts

M1: Excel Basics

L3: Rows & Col...

Rows and Columns

Shortcut Unlocked

Ctrl+Shift+↓Select all cells below the active cell, until the last row of data

AI Assistant

Shortcut Book

What happens if you use this lesson's unlocked shortcut and all cells below the active cell are empty?

With nothing below to stop at, the selection runs all the way down to the very last row of the sheet.

Ask about this lesson...

Total

1,240

980

1,510

760

2,030

1,120

890

H2:H8 selected in one keystroke

Question

What does [Ctrl+Shift+↓] select from the active cell?

All cells in the same row, until the last column of data

The whole column

All cells in the column, until the last row of data

One cell down

Continue

Lesson timeline

The module's lessons are shown on a single line. A green dot marks a completed lesson, a gray one is a lesson still to come and the blue ring - the lesson you are on.

Features

AI Assistant

Learners have a readily available AI Assistant, fully versed in the course material, to help with any questions related to the course.

1 year of access

Once you enroll, the course is yours for a full year. Go back to any lesson as many times as you need.

Verifiable certificate

Finish the course and receive a certificate with a unique code. An employer can check it on the site without a Lerno account. The certificate stays valid after your access ends.

Our mission

Lerno's mission is to create a digital library of skills and knowledge. Everyone deserves to learn at a time that suits them, at their own pace and in their own comfortable environment.

Teach with Lerno

The Excel course is only the beginning. We want to grow the library together. If you have knowledge you would like to share, let us build your course: you bring the knowledge and experience, we take care of the platform, the learning design and the AI tools.

Partner with us