Microsoft Excel- Scratch to Advanced Level

Here’s the deal:

You can learn Excel by watching random YouTube-videos and reading online tutorials…

… but it’s CRAZY inefficient (that approach took me 7 years!).

That’s why I’ve distilled all my knowledge into a single course called “Zero to Hero”.

In Zero to Hero, you go from beginner to Excel-superuser

So, if you want to:

• Work more productively on your daily Excel tasks

• Get new and better career opportunities

• Upgrade your professional skills

You’ve come to the right place!

The grid

• How to select cells with the name box, a cool feature that few Excel users take advantage of.

• How to insert new rows or columns any time you need them, and why Excel doesn't care how many rows or columns you delete. (By the way, deleting rows and columns is a great way to slice clutter out of a worksheet).

• How to get Excel to expand column widths automatically, so you can actually see your data (works for multiple columns, too, you just have to know where to click).

• How to hide rows and columns, and tell if someone else has hidden them.

• How to "cancel" a change you don't want to make, by pressing just one key. You'll use this every day.

Building a workbook

• How to insert, remove, and rearrange worksheets, and how to color tabs to make then easier to see.

• A simple way to duplicate entire worksheets (a huge time saver if you need to set up many similar worksheets).

• An easy way to hide tabs you don't want others to see.

• How to move worksheets to a different (or new) workbook.

Formulas

Formulas are the bread and butter of Excel. Nothing happens in a spreadsheet without them. Core Formula shows you...

• How to enter both formulas and functions.

• How to enter and verify references by pointing and clicking (a good way to prevent Excel disasters).

• How to control "the order of operations in your formulas" when needed. (The difference between a formula that gives you the correct result and a formula that's just plain wrong.)

• How relative references really work and why they are incredibly useful.

• What an absolute reference is and why you need them sometimes.

• How to get Excel to change between relative and absolute addresses for you. Who wants to fiddle with dollar ($) signs?

• The simplest way to create a named range, and why named ranges are a fantastic way to make your formulas easier to read and copy. (They also add professional polish).

Formatting

• How to make Excel format your dates for you (in any way you like).

• How switch quickly between different number formats, like accounting, currency, dates, and times. Even how to make Excel format numbers as a fraction (most people don't even know you can do this).

• How to create your own custom number formats to display numbers any way you like. (Even things like durations like 30m, or 8 hrs).

• How to know whether Excel thinks something is a number or text, just by watching the alignment.

• How to turn on text wrapping, and how to add a line break inside a cell (something that drives people crazy).

• How to center text across cells *without* merging cells (Excel pros consider merging cells simply "evil").

• How to align text to the top or bottom of a cell, and even how to rotate text at different angles (one way to get long labels to fit in narrow columns).

• How to use a special shortcut to apply almost any kind of formatting, *without* the ribbon.

• How to insert special symbols in Excel like ™, ®, © etc.

• How to format individual words and even letters in Excel. (Yes, you can bold just one word!)

• How to use special formats, like strikethrough and double-underline.

• How to quickly strip all formatting and start over. (Much faster than trying to undo formatting).

Borders and fills

• How to quickly remove all borers and fills so you can start again.

• How to "punch lines" into a solid fill for a more refined look.

• How to "draw" borders in almost any shape using a special tool on the ribbon.

• How to use a special tool to paint cells with the formatting you see in other cells (a huge time-saver).

• How to quickly strip away a lot of formatting and start over. Often, this is far faster than trying to undo many layers of formatting.

Conditional formatting

Conditional formatting is one of the coolest and most underutilized features in Excel. With a few clicks, it can show you things about your data your eye won't catch otherwise.

• How to get Excel to show you the top 10 values in a list, or the bottom 10.

• How to make Excel show you duplicates (It's fun to make Excel do the hard stuff).

• How to make your own conditional formats, so you can flag problems or highlight good data automatically.

Just Hit an Enroll Button