Course: Formatting 2017-08-23T12:21:42+00:00

Online Excel Course: Formatting

Get instant access

Get access to Formatting now

Formatting: Course on creating a professional-looking spreadsheeto

‘Formatting’ is the perfect course for learning to create professional, actionable spreadsheets.

In just 59 minutes, you’ll know the exact steps to create a beautiful, professional-looking spreadsheet.

This is the quickest and best way to learn Excel’s powerful formatting tools.

  • 30 action-packed lessons
  • Project files to make your new knowledge stick
  • Free cheat sheet for easy repetition
  • (Re)view each lesson as many times as you’d like
  • Perfect for beginners
Get instant access

Course Curriculum

Here’s the complete list of modules and lessons ‘Formatting’ goes through.

  • Introduction to ‘Formatting’
  • What is formatting all about?
  • Fill color
  • Font color
  • Borders
  • Hiding the gridlines
  • Merge cells
  • Text size, bolding and alignment
  • Wrap text
  • Useful presets, comma separator and decimals
  • Dates
  • Custom formats
  • Formatting a dataset in seconds
  • The Format Painter
  • Clearing formatting
  • What is Conditional Formatting?
  • Highlight cells rules
  • Top/Bottom rules
  • Edit and delete rules
  • Using multiple rules
  • Data Bars
  • Color Scales
  • Icon Sets
  • Formulas in conditional formatting
  • Highlight entire rows based on value of a cell
  • Finding duplicates
  • Certificate
  • What now?

Who created this course?

Kasper Langmann (co-founder) created ‘Formatting’.

Kasper is also a certified Microsoft Office Specialist.

What’s unique about Spreadsheeto is, that the course creator is also the co-founder.

Kasper will not only be him you’ll listen to throughout the lessons – you’ll also be in direct contact with Kasper all throughout your Excel-journey.

“Hi, there! My name is Kasper and I’m the creator of ‘Formatting’. I’ve worked professionally with Microsoft Excel for the past 6 years. I’ve helped thousands of people just like you create professional, actionable spreadsheets by using formatting. I’m also a certified Microsoft Office Specialist. I’m so ready to help you get awesome in Excel in no time!”
Kasper Langmann, Co-founder and course creator

Frequently asked questions

Got a question we don’t answer below? Then feel free to contact us.

Can I get a certificate of completion?

Absolutely! Once you’ve completed the course, you’ll get a certificate of completion. This applies not only to this course, ‘Formatting’, but all our courses.

Do I need any experience to take this course?

Not at all. This course is perfect if you’re a beginner looking to upgrade your skills. Everything is explained very beginner-friendly in a nice pace.

What version of Excel do I need?

This course is filmed in Microsoft Excel 2016 for Windows. If you have Excel 2010 (or later) for Windows, you’re perfectly capable of following along.

How long does it take to complete the course?

You can watch all the lessons in less than 1 hour. We’ve removed all the unnecessary and distilled Excel down to its most important elements. We highly suggest you also do the included exercises. We’ve included a cheat sheet that makes revising the course content smooth and easy. How quick you pick up the material is very different from person to person. Therefore, we recommend setting aside 2-3 hours to go through all lessons and exercises.

Get access to Formatting

“Formatting” is part of our premium training Zero to Hero. Click and read more about Zero to Hero.

Formatting: Course on creating a professional-looking spreadsheeto
Get instant access

Send this to a friend