# “Hot Key Excellence” – Excel Formulas Game

\$89.00

Knowing useful Excel formulas and  functions will make you extremely efficient in Excel.

This Game covers over 70 Excel Formulas and Functions and many more Excel tips and tricks that would be helpful and easy to learn whether you are a beginner or an advanced user of Excel.

We value your time. Save hours and weeks with our Game.

Category:

# WHAT YOU’LL GAIN

## Learn and Practice at the same time

You don’t have to stop the video course and open an Excel file to try the new formula or function in work – you get 2 in 1 with our Game. Your muscle memory will work for you, while you are playing and having fun.

Forgot formula or function you need? Open the game with the lists, and refresh the memory. The Game is well structured and it would be easy to find the formula you are looking for.

## Blind Typing Skills in Excel

You will go over many Excel tasks in the Game totally mouse-free! Throw away your mouse and use Game shortcuts – spacebar and highlighted letter/number.

## Full Excel Formulas & Functions List

Within the Game you can find the full Excel Formula List, and lists of the formulas and functions for each topic separately.

We’ll give you the Advanced Excel Game FOR FREE, if you get all the Keys in the Game. Just send us an e-mail with the screenshot of the “Key Menu” screen (with all the keys collected), and we’ll send you the link to the Advanced Excel Game.

# WHAT YOU’LL LEARN

Basic

• Sum up numbers in one click
• Shortcuts to show a formula in the cell or all formulas on the sheet
• Anchoring with the hot key
• Expand / Collapse Formula bar in one click
• Insert Function Window
• Trace Precedents or Dependents of the cell in micro-second
• Naming cell in Excel
• Two ways to transpose data in Excel

Intermediate

• Average and Median
• Find the smallest or the largest numbers in the cells. MIN, MAX, SMALL, LARGE – what’s the difference
• COUNT, COUNTA, COUNTBLANK – what do we count here?
• ROUND, ROUNDUP, ROUNDDOWN – different ways to round numbers in Excel
• How to multiply in a fancy way – PRODUCT and SUMPRODUCT

• CHOOSE and OFFSET functions – what’s the difference and which one is better to use
• LOOKUP, HLOOKUP and VLOOKUP – let’s find out how it works
• MATCH and INDEX separately and together
• Dynamic reference to other ExceI sheets with INDIRECT function

IF Statements

• IF and nested IF
• SumIF(s) and AverageIF(s)
• CountIF(s) – let’s count it if
• IFError, then how to make it pretty
• IS Functions – ISError, ISBlank, ISNumber, ISText

Text Functions

• Which case would you like for your text – PROPER, LOWER, UPPER
• LEFT, RIGHT and MID to pull specific characters from the text
• FIND and LEN for texts
• Join text strings with CONCATENATE
• How to convert numbers into dynamic text values

Other Useful Functions

• Create a random number in Excel with RAND and RANDBETWEEN
• Commonly used Statistical Functions: STDEV.P, TREND, FORECAST
• Date and Time Functions: WEEKDAY and WEEKNUM
• NETWORKDAYS and EDATE – even more Date and Time Functions
• We even show you useful functions that does not pup up in Excel – DATEDIF
• Check out today’s date with TODAY function