Master Excel Like a Professional and get hired, promoted, and a salary raise. Learn basic to intermediate concepts by doing 3 targeted exercises which will allow you to see excel in action in a realistic context. No isolated concept learning which you can't remember anymore but learning in context. Like stories you never forget, these exercises will stay with you forever and they will be your reference as you start applying your knowledge. You will be able to apply the concepts you learn here in any situation even if you have never used excel before.
Get a glance of what excel is and can do by diving right into.
You can get a trial copy of Excel that last 60 days so you can follow along.
How to fire up Excel in Windows 8.1.
Learn the limitations of Excel
Learn what are Relative, Absolute and Hybrid Cell References.
Learn what a range is, how to represent a range and what is for.
Learn to identify the fill handle in a cell or a range.
Shorten your learning curve by learning when the mouse pointer changes in the excel context.
See how the fill-handle saves you time with its magic.
Just a reminder of math rules when it comes to operation order.
Learn what are data types and their use.
What is the difference between a formula and a function? and why it matters.
We take a look at the project so you can look ahead to what we are to accomplish.
Watch and learn 2 techniques of entering data into a sheet.
Speed up data entry by using a range and freeing up from using the mouse.
Learn how to enter the built-in sum function.
Learn to merge a range of cells with 1 or more content.
Making it all look nice with cell styles
Go beyond cosmetics by formatting cell values with datatypes.
Change look and feel of a worksheet quickly by changing themes.
Use "Chart Tools" settings to change the chart design.
Use "Chart Tools" Format to change the chart settings
Learn how to use the "What If" ",Goal Seek" function.
Let's see if you can remember what you've learned in the Super Cellular Project.
We survey the "Dollar Premiere" project to explore what we will do with this project.
Learn to use the "Quick Analysis" tool to calculate totals
Use the Average, Max, Min, and CountIf functions.
Learn to convert a range into a table, and to apply conditional formatting.
I have been teaching computer courses for the last 14 years in various institutions of higher education. After a start in corporate America, I was invited to teach and fell in love with the experience. I really believe I have a talent for simplifying complex subjects and I actually enjoy making these subjects accessible even to those with little exposure to technology.
My professional career started as a Civil Engineer and a few years later took a Master’s Degree in Information technology, some of the jobs I have held include Resident Engineer and a 2 years freelance experience in networking and web development.
My teaching style is to sprinkle my lectures with a little humor, it refreshes the atmosphere, and to point out mistakes I see of more common occurrence to those new to the topics.
Why do we have to fail to learn? if all those errors are foreseeable by the instructor and proper warnings are in order so we can abbreviate your learning experience.