If you are looking for an Excel course for beginners to experts? This online course has something for everyone, covering beginner, intermediate and advanced lessons in Excel.
Supports Excel for Windows 2010, 2013, 2016. Also available:Â Online Excel with One Drive
In 50 engaging lessons you will learn basic techniques including how to use math, statistical, logic and text functions, organize data by sorting and filtering, effectively present your data in several chart formats and more. You will also learn intermediate and advanced techniques such as how to find a value with VLOOKUP, create and format PivotTables, record basic Macros and more.
Whether you use Excel for work or study, these tutorials will start you on your journey to becoming an Expert of Excel. Learn more about how a GoSkills Excel which can boost your career.
If you'd like to learn more advanced Excel techniques, check out our Advance Excel course.
The course is Microsoft Excel 2010, 2013 and 2016 compliant. Videos are recorded in Microsoft Excel 2016 and 2013 for PC, and where the user interface is significantly different, Excel 2010 videos are provided too.
Once enrolled, I support with any course related inquiries.
Formula:Â
Formula Anatomy
Understanding Excel Formula Anatomy
Cell Referencing
Learn about working with absolute and relative cell referencing, and techniques for copying formulas.
Function Anatomy
Use to understand the anatomy of Excel functions, and what their components mean.
Math Functions
Learn basic math functions including SUM, ROUND and SUBTOTAL.
Basic Statistics
Learn basic statistical functions including COUNT, COUNTA, AVERAGE, MAX, MIN, MEDIAN and MODE.
Logic Functions
Learn to build standalone logical IF functions, and make them more complex by nesting AND and OR within them.
Text Functions
Learn to break apart text with the LEFT, RIGHT, MID, FIND and SEARCH functions, and to combine text with the & character.
Understanding Dates
Understand how dates work in Excel using the TODAY, YEAR, MONTH, DAY and DATE functions.
Understanding Time
Understand how time works in Excel, and how to change from whole numbers into time increments and back again.