Getting Started

Welcome to DistilledU, the online search marketing university.

You can try the demo or sign up for a full account to access all modules and our whole video library.

Try demo
3 free demo modules
Get Full Account
$40.00 with monthly plan
$33.00 with annual plan

Already a member? Log in

Questions? See our FAQs

DistilledU Content Status

  • Lesson Rating
  • 4.4 out of 5 from 18,456 reviews
  • Modules
  • 93 hours
  • Video Library
  • 133 hours

Used for training by

Special offer! Save 17.5%!

Sign up to our Annual Plan for $396.00 per year, saving you $84.00 on a monthly subscription.

Sign up for an annual plan

Add colleagues & save 10%

Get a 10% discount after signing up by adding colleagues to your DistilledU account.

Sign up now

Interactive: Excel Skills

Time remaining/total 2h 30m 4.0 / 5

Getting started with a basic formula

Time required: 10m
Lesson URL:
Teacher: Will Critchlow

Making the most of Excel

Most people get started with Excel as a place to make lists. The next step up from that is basic calculator functionality followed by more complex models and ultimately basic software programs.

The goal of this module is to give you a solid grounding in the building blocks of Excel models. We will cover the most useful core functions as well as basic best practices. We have a guide covering more of the uses of Excel for SEO which is a great place to get started with tables, pivot tables and other crucial Excel skills. We recommend that you start with the Microsoft Developer Center if you would like to learn the Visual Basic programming language.

In this module, we will cover:

  • Basic math functionality
  • Best practices: naming your references
  • String manipulation (length, substrings, finding characters)
  • Basic Boolean logic
  • Reference handling and lookups
  • Error handling
  • Working with columns of data

The intention is that this module will give you a solid enough grounding that, when combined with the extensive help will allow you to create any formula you need.

We are going to start with simple calculator-type functions:

You enter a formula in Excel by starting with an equals sign (=). Cells are referenced by their row and column - so C2 is the cell three along and two down.

You can construct mathematical formulae using cell references and the basic mathematical operators: + (addition), - (subtraction), * (multiplication) and / (division).

The formula below adds cells A1 and B1. Modify it to divide A1 by B1.



Small clue Big clue Show answer
Close

 If A1 and B1 were numbers, how would you divide A1 by B1?

Close

For example, if you were dividing 4 by 2 in excel, you would write = 4 / 2

Not yet completed

Copying formulae

Time required: 15m
Teacher: Will Critchlow

Best practices: naming your references

Time required: 5m
Teacher: Will Critchlow

Introduction to text manipulation - string length

Time required: 10m
Teacher: Will Critchlow

Finding text in a string

Time required: 15m
Teacher: Will Critchlow

Slicing and dicing strings

Time required: 20m
Teacher: Will Critchlow

Basic logic

Time required: 10m
Teacher: Will Critchlow

Error handling

Time required: 10m
Teacher: Will Critchlow

Basics of arrays

Time required: 15m
Teacher: Will Critchlow

Conditional columns

Time required: 20m
Teacher: Will Critchlow

Lookups and matches

Time required: 20m
Teacher: Will Critchlow
 
Close

Sign up for a free demo account

Simply fill out the form below to accces our 3 demo modules for free

or pay for a full account

Close

Log in to your account

Forgot your password?

Close

Sign up for a full account

  • Only $40 per month or $33.00 per month with annual plan
  • 93 hours of lesson and tests spread over 26 modules
  • Share your test scores and badges with others using your DistilledU profile.
  • Video Library with over 133 hours of advanced content
  • Constantly growing resource - new modules and features added regularly

or try 3 demo modules for free

Close

Suggest a term

Please suggest any terms that you feel are missing from our glossary using the form below. Your suggestion(s) will be sent to Distilled for consideration.

Close

Suggest an edit to term:

Original:
Your edit:

Your suggested edit will be sent to Distilled for consideration.