“Hot Key Excellence” – Full Excel Game

$159.00

It’s a fast moving 21st century, when the time is the most valuable resource.

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

Using Excel mouse-free improves your speed in Excel up to 10 times. Learning this skill with our Excel Simulation Game makes it up to 5 times quicker for you.

Category:

Description

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 shortcut or formula separately in Excel – you get 2 in 1 with our Game. Your muscle memory will work for you, while you are playing and having fun.

 

Lifetime Access to the Game

Forgot shortcut or formula? 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 – space bar and highlighted letter/number.

 

Full Excel Shortcuts and Formulas Lists

Within the Game you can find the full Excel Hot Key List and Full Formula List. There are also lists in each topic separately for your convenience.

 

Free Advanced Excel Game

Advanced Excel is already included in the Full Version of the Game – FOR FREE.

 

 

WHAT YOU’LL LEARN

Commonly Used Hot Keys

Let’s Begin

  • How to create new Excel file and new sheet in the file in one click
  • How to move between sheets and opened Excel files with no mouse
  • Basic shortcuts – save, undo, redo
  • Zoom In / Zoom Out in micro-seconds
  • Hide / Unhide Excel Toolbar – the power of space in Excel
  • How to close Excel file and/or Excel application mouse-free
  • Right-Clicking Menu of the mouse with no mouse – yes, it’s possible too!

Navigating and Highlighting

  • Move between cells and contiguous ranges in Excel mouse-free
  • Where is Home and End in Excel
  • Highlight range of cells in Excel fast and accurate with the shortcuts
  • Highlight the whole column or row in micro-seconds
  • Shortcuts to move within highlighted area and deselect to the original cell
  • Add/Delete column or row in one click
  • Go To dialog window – run in Excel!
  • Naming cell in Excel

Copy Paste

  • Copy, cut, paste – basic shortcuts
  • Fill Right or down in micro-seconds
  • The power of Paste Special
  • Paste Column Width – yes, you can do even that!
  • Paste Special – you can do Operations here and it might save you hours!
  • Paste Link from another sheet
  • Transpose in Excel

Formatting

  • Bold, itilize, underline in one click
  • Repeat previous action with one hot key
  • Format as percent or currency in one click
  • Format Cells dialog window
  • Navigating within dialog window mouse-free

Basic Formulas

  • 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
  • Working with comments in Excel mouse-free (create, show, close, delete comments)
  • Insert Function Window

 

Ribbon Navigation

Alt File and Quick Access Toolbar

  • Working with Excel Ribbon mouse-free
  • Customize your Quick Access Toolbar to boost productivity in Excel
  • File option on the Ribbon

Alt Home

  • Access Home option on the Ribbon mouse-free
  • Change font or font size with the shortcuts
  • Working with borders in Excel with no mouse
  • Shortcuts for Alignment
  • Autofit Column Width / Row Height in micro-seconds
  • Hide / Unhide Columns or Rows with the shortcuts
  • Shortcuts to Hide / Unhide Excel Sheets

Print and Page Layout

  • Print in micro-seconds
  • Shortcuts for Page Setup and Page Layout
  • Header and Footer Access with no mouse

Alt A – Data

  • Access Data option on the Ribbon mouse-free
  • Sort data in the table without a mouse
  • Filter in micro-seconds
  • Shortcut to remove duplicates
  • Group / Ungroup rows or columns using shortcuts

Alt W – View

  • Access View option on the Ribbon mouse-free
  • Hide / Unhide gridlines and headings with shortcuts
  • Shortcuts to Hide / Unhide formula bar
  • Freeze / Unfreeze row or column in micro-seconds

Alt Menu Additional

  • Access Insert and Formula options on the Ribbon mouse-free
  • Shortcuts to insert picture or Draw in Excel
  • Trace Precedents or Dependents of the cell in micro-seconds
  • Go to Search option in Excel without a mouse
  • And more!

 

Formulas and Functions

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

Advanced

  • 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

 

Advanced Excel

Macros

Macros are one of Excel’s most powerful features – they can help you automate repetitive tasks and save hours and hours in Excel. Macros are  actually much easier to write than you’d think. Learn with us simple steps to create macros!

Data Tables and Conditional Formatting

Data Tables allow you to try out different  values (scenarios) for formulas  at once and save you tons of time .

Conditional Formatting visualizes quickly and efficiently any trend you’d like to find out and highlight.

Pivot Tables and Charts

If you use Excel, but don’t know how to use Pivot Tables, you’re missing out – wasting hours trying to do things that a Pivot Table can do for you automatically.

One of the hottest trends today is data visualization. Why? Because when data is presented visually, people understand it immediately. Learn how Excel charts work with us!