
Lock and freeze cells in Excel using absolute references to keep references fixed while copying formulas, illustrated with a 5 percent discount example.
Master cell referencing in Excel by using absolute and mixed references with dollar signs, enabling rightward and downward copy-paste for 10, 15, and 20 percent discounts.
Improve Excel efficiency by practicing ninja shortcut keys, focusing on red super important, blue, and common black shortcuts, with hands-on exercises to master essential commands.
Master the universal shortcut via the Alt key to reveal ribbon key tips, access the Home tab, apply fill color, adjust indent, and accelerate copy-paste with Ctrl+D and Ctrl+R.
Learn how to use control enter to fill a selected group of cells with the same text or formula across continuous or scattered ranges.
Master workbook navigation and data selection using sheet shortcuts, ctrl page up/down, ctrl+a, shift+ctrl+arrows, and ctrl+backspace to jump to the header, while handling blanks and last used cells.
Navigate ninja-level Excel shortcuts to insert or delete rows and columns. Use Alt I then C or R to insert, Ctrl minus to delete, and Ctrl+Spacebar or Shift+Spacebar to select.
master excel formula shortcuts to navigate and edit formulas, using function keys, control back to key, third bracket open, and shift tab for function arguments, with auto-sum and sheet references.
Master selective Excel formatting shortcuts to format cells, dates, and numbers quickly, using ctrl+1, ctrl+semicolon, and alt+semicolon for visible cells.
Are you new in business or eager to get a better job?
Do you know that employees using Excel are paid %15 more on average.
A working knowledge of Excel is vital for most office based professionals today, and stronger Excel skills can open the door to promotion and leadership opportunities. There are various ways to learn Excel and we’re proud of introducing the most effective and innovative way of learning excel in the world: Learning by doing
Because you can learn Excel by doing where it’s 15 times more effective than in class training. And 5 times more effective than by watching.
We will briefly explain the topics you need to discover and will guide you through the online exercise. You will learn by doing while we will automatically check your actions online and give automated feedback that will lead you to learn subject better
All of our exercises are from real life case studies so that you will easily apply what you learn to your work.
Start learning and mastering Excel today, boost your productivity and make more money with our hands-on training.