Excel 2016 - 10 Easy Steps for Beginners
Genre: eLearning | MP4 | Video: h264, 1280x720 | Audio: aac, 48000 Hz
Language: English | VTT | Size: 1.26 GB | Duration: 12 section | 37 lectures | (5h 53m)
What you'll learn
You will know how to input text easily, especially if your typing skills aren't good
You will know how to create simple calculations
You will know how use percentages in calculations
You will know how to create formulas
You will know how to format data to bring your spreadsheets to life
You will know how to use tables
You will know how to create charts to visualize your data quickly and easily
You will know how to print with confidence
Requirements
Students need to be excited about learning a new skill that is highly sought after
No previous experience of Excel is necessary, I'm going to teach you all you need to know to get you started with confidence
A computer with Excel 2016 installed - Excel 2013 will have most features but not all
Description
This online Excel course will teach you how to create amazing spreadsheets and charts whether you have used Excel before and just want a refresher or you are totally new to it and are scared the world will end if you press the wrong button!
While there are plenty of Excel courses that will teach you Excel, it's really hard to find one that doesn't jump around with different data examples and can cause confusion when you're just starting out.
This course, centres around a fictitious company called AdventureWorks and you start at the beginning and work through to the end with the same data set, building your knowledge, understanding and confidence as the company introduces new stock and suppliers.
You will learn how to create calculations to see how the company profits are doing in the easiest of easy ways - you don't need to be an accountant to work this out - it's easy!
You will generate reports both manually and automatically using Excel feature-rific tools - which are AMAZING - such as the Quick Analysis Tool and Flash Fill
On the strength of your report creation skills, you will present these reports visually in Charts and edit them just like the boss likes them!
Here's just a few things you'll learn:
AutoFit
AutoComplete
Auto Fill
Amending spreadsheets
Simple calculations
Working with percentages
Formatting data
Cell addressing
Flash Fill
Working with tables
Sorting & Filtering
Creating charts
Printing
Improve Your Career Prospects, Acquire More Skills, Make More Money
This course will provide you with a solid foundation to hone your skills that will take you to the next level. You will feel confident and chomping at the bit to improve - Excel does that. It grabs hold of you and each new skill you acquire drives you further and further.
Excel is packed with endless possibilities and my aim is to open the door for you to explore. Your earning potential will increase as your skills develop - you'll get noticed and with that recognition comes reward! Master the basics of this amazing application and boost your income with a relevant and highly sought after skill
Don't Put It Off Any Longer. Start Now. With Me. Today.
By the end of this course, your confidence as an Excel user will soar. You will have a thorough understanding of the fundamentals that drives Excel to be the most powerful application in the Microsoft suite of programmes.
Download the Excel 2016 - 10 Easy Steps for Beginners 70 page, screen-shot packed user guide containing all the course steps and exercises. Follow along with me in the Sales Report workbook and consolidate, embed and underpin your knowledge with practice exercises that I show the solutions to. Smash the quizzes with your understanding of Excel's tools and options.
This course will take you from scared to PREPARED - for anything that needs calculating, reporting, presenting or printing!
Who this course is for:
This course is for anyone who wants to learn how to use Excel 2016 but were too afraid
In other words.... ALL absolute beginners who want to become a skilled Excel user
This course is for office workers, mums, dads, grandparents, kids ... anyone that wants to organise their schedule, bills, lists, workload properly
This course is for anyone who wants to improve their career prospects
This course is for anyone who just wants to prove to themselves they can do it!
