
This lecture covers:
- How to use the course resources (shortcut and exercise files)
- How to enter text in cells
- How to edit cells
- PC vs. Mac
- The Excel ribbon vs. the older toolbar
- Basic cell navigation
Learn to navigate through excel without a mouse, using your arrow keys. To make things even faster, you'll learn how to jump THROUGH large blocks of cells, to get right where you need to go.
Learn various methods of formatting cells, including Conditional Formatting, where you can teach excel to format cells for you automatically
Learn Paste Special, one of the most powerful tools to prevent you from repeating repetitive formatting or function tasks.
Play some fun games using Paint Special
See how fast your formatting has gotten, with a challenge!
Learn the basics of functions and formulas, the tools that make excel one of the most powerful systems in the world for analysis.
Now that you've learned the basics, here are some fun excel pranks you can play on your friends!
Congratulations on finishing! This course only touches on the power of excel. Take my other courses to learn many more tips and tricks to make you the most expert excel user in your workplace!
100% of all my course revenue will be donated. Why? Read on...
This course is a preview to my full Excel Afterburner class
It's right for you if:
This course is based on the training Wall Street bankers use to become the fastest and most productive excel users in the world. You will learn to quickly navigate your excel sheets, organize/format data, calculate/solve problems confusing problems, and present your data beautifully..
The quick exercises are specifically designed to build off of each other so that you get continued practice on the basics as you get more advanced.
I have been extremely fortunate in my career to graduate from Harvard Business School and work for some of the top companies in the world. I didn't originally come from an ivy league school; in fact, I was rejected from most universities and jobs I applied to. I know how hard it can be to propel yourself forward, and many people helped me get where I am today.
I will give 100% of my tuition to Kiva, an organization that helps educate and secure financing for business owners in impoverished areas. That way, you can help others while you're learning yourself.
Once you've completed this course, check out my others to advance your skills!