Microsoft Excel Essentials: Level One
This course is designed for those interested to learn the basics of spreadsheets, the basic and complex formulas, as well as learn in detail all of the basic functions of Excel, not only how to use it, but some powerful tools to allow you to understand how it works.
About This Coursebeginner
Excel is the most commonly used and in demand tool for making sense of data. When you can harness that power, you will be a sought after employee. If you run a business, being proficient in Excel can help you see your business in a completely different light.
If you are a complete beginner looking to master Excel, or you just want to brush up on the basics, you’ve come to the right place. If you want to earn more money by developing a skill set that today’s employers demand, this is the course for you. Getting to grips with Excel will give you a distinct advantage in whatever work you currently do, and can open the door to new opportunities.
Many of my students have gone on to get better paying jobs, or even start their own businesses, using the very skills you will soon master. In this course we cover in detail all of the basic functions of Excel, and you will learn not only how to use it, but some powerful tools to allow you understand how it works. There is a difference between repeating something and understanding it.
Together we concentrate on building a single complete project from beginning to end, using all the basic functions and give you a thorough understanding. I know your time is valuable, so most lectures are between 3-5 minutes, allowing you to dip in and out when it’s convenient for you. This also maximizes your learning, and makes it easy if you ever need to go back to refresh your memory. There are screencasts, lots of quizzes, presentations, pdfs, downloadable files all designed to optimize your learning.
Who this course is for:
- This course is aimed at complete beginners, or those who want to get a thorough knowledge of the basics
- Anyone looking to increase their chances of better paying jobs, through mastering MS Excel
Our Promise to You
By the end of this course, you will have learned the basics of Excel.
30 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.
Get started today and learn more about the essentials of Microsoft Excel.
Downloadable Materials – Excel Essentials 1
Opening Excel, And Creating A Shortcut
The Anatomy Of A Workbook: Where Everything Is, And What It Does
A Quick Review Of What’s Where
Always Do This First – Save Your New Workbook
Let’s Enter Some Data
Ooops. I Made A Mistake – Undo And Redo
Changing Appearance Of Text With Formatting – Fonts
A Quick Word On Formatting
Formatting – Alignment
Saving Time With AutoFilling Sequences
Power User – Adding Your Own Lists To Autofill
Saving Time With Format Painter
Changing The Column Width
Tidy Large Titles With Merge And Centre
Entering Data – A Couple Of Shortcuts
Sums – The Old Fashioned Way
Sums – Using Autosum
Basic Formulas – Subtraction
Basic Formulas – Multiplication
Basic Formulas – Division
The Order Of Mathematical Operation
Power User – Evaluate Formula Function
Inserting New Columns And Rows
Moving Existing Columns And Rows
Cutting, Copying, Inserting And Deleting
Hiding Columns And Rows
A Primer In Building Complex Formulas
Building A Complex Formula
Wrapping Text And Soft Enter
Adding A New Worksheet
Creating A Simple Chart
Customizing The Quick Access Toolbar
Freezing For An Easier View
Whizzing Around Excel
The Keyboard Shortcuts
Relative Relative Style
Absolute Absolute Style
Absolute Relative Style
Relative Absolute Style
Reverse Engineering A Sample Spreadsheet
Casing And Text Functions
Level 1 SQA 03 – Charts From A Filtered List
No Reviews found for this course.