I have learned Excel from many different sources including books,
websites, Youtube, online courses & analyst employment. My goal was
to create a course that has everything in 1 place so that you don’t have
to go searching everywhere like I did. It took me a long time to master
Excel and now I want the course that I wish I had when I started
learning so that you can learn in a 20 hour course what takes most
people 5-20 years to learn. That is my goal with this course.
As far as the content goes, I cover everything except for VBA/Macros
because that really needs a whole course of it’s own. But everything
else in Excel I cover and that’s why the course is so long. But it’s not
really not that long if you think about the benefits, including the
time it will save you when you become an excel expert and also the
career opportunities. You could be less than a week away from becoming
an Excel expert! Or you can do the course slowly over years, it’s
completely up to you. The course can be done at your own pace and in any
order. I have arranged it logically into what I think is the best way
to learn but you can do the videos in any order. If one video requires
having seen another as a prerequisite then I mention that in the video
so you can go back and watch that if you need to. The main thing is that
you find the course valuable and learn a lot.
The course is suitable for complete beginners and I have a video at
the start teaching excel for people who have never used it before. But
that’s not to say it won’t be useful for advanced users. As you can see
from the content we cover everything, including the most advanced
formulas and features. I try to do this with a lot of examples and
explain as clearly as possible so that you understand why we do certain
things not just how to do it. In only 19 hours and 120 videos, I
guarantee you will the Excel guru among your friends & co-workers.
Contents
- Fundamentals
- Formatting
- Working With Data
- Formulas & Functions
- Pivottables
- Charts
- Print, Page Set & View
- Proofing, Sharing & Protection
- Shortcuts
- Other Useful Tips
- File, Ribbon & Quick Access Toolbar
What you’ll learn
- Basics of excel spreadsheets-navigating, saving, printing, math
- Use of the all aspects of the speadsheet including the ribbon icons, quick access toolbar and dialog boxes
- Use all aspects of formatting to highlight key points in the data
- Sorting, filtering, manipulating & summarising data to draw quick conclusions
- Connecting to data from different sources including text, websites, databases, stocks and geographical information
- Use ‘What If’ analysis to o analysis based on changing conditions
- Create dynamic charts and formulas which automatically expand to include new data added
- Functions & formulas
- Array formula
- Tables, pivottables & pivotcharts
- Charts, dashboards & other data visualisations
- Customise the look and feel of the spreadsheet for general viewing and printing
- Adding security & protection to restrict user permissions.
- Crashing & recovery incase of spreadsheet crashes
- Keyboard shortcuts to save time
- Use templates & ad-ins for specific scenarios
- Quick tips for insightful data analysis & saving time