Mastering MS Excel - From Beginner to Advanced and Beyond
What you'll learn
- Learn or refresh creating worksheets complete with formatting, formulas and basic functions
- Advanced functions such as if function, lookup functions, text functions and more
- Work with datasets and tables
- Adding subtotals and grouping
- Charts and Pivot Tables and Pivot Charts
- Conditional formatting
- Custom number formats
- Data validation
- How to easily remove duplicate data
- How to password protect a whole worksheet and part of a worksheet
- Using Range Names
- More topics coming soon!
Requirements
- Basic computer knowledge.
Description
UPDATED AUGUST 2020
Proficiency in Excel is one of the key skills to landing a good-paying job, according to a recent labor-market analysis by Burning Glass Technologies. ~Monster
According to the Wall Street Journal, high proficiency in software like Microsoft Excel is increasingly helping people land jobs. And jobs that require digital skills such as Excel also pay approximately 13% more than those that don't.
⭐⭐⭐⭐⭐⭐
Are you ready to increase your pay and become more sought after in today’s job market?
Are you ready to be proficient in Excel and stop wasting time and money searching for the best solution to your Excel project or question?
Are you ready to land that good-paying job?
⭐⭐⭐⭐⭐⭐
There is so much information out there. It can be confusing trying to figure out which Excel solution is the best. Or, what skills are needed in today’s job market. So I’ve made it easy for you.
I’ve collected the most common Excel questions and problems my students and clients have faced in various professional settings in the last 20+ years. I’ve added in my own experience using Excel in corporate and military environments and as a consultant. I’ve put this all together in a course that will show you how to use Excel with real-world examples and exercises..
This course is designed to teach you MS Excel from the ground up, either as a refresher or as a newbie, all the way through to the advanced topics which will make you a pro. All the lessons are taught in an easy, stress-free way with step-by-step instructions. When you are done with this course you will be able to look at a problem and come up with an Excel solution.
⭐⭐⭐⭐⭐⭐
I have over 20+ years of experience using and teaching Excel and helping large companies save time and money by using Excel more efficiently. I have shown thousands of students and clients how to not only use Excel but use it efficiently thus saving themselves and their companies time and money. I am certified to teach MS Excel at the Expert level and I know what solutions employers are looking for.
⭐⭐⭐⭐⭐⭐
Benefits
These practical, real-world lessons will help you understand Excel’s full capabilities.
You’ll not only know HOW to do something; you’ll also understand the WHY behind the tasks.
You'll learn how to use Excel for quick and painless problem solving.
You’ll spend less time searching for answers because you will have a solid understanding of the way Excel works.
You will learn sought after skills your dream employers are looking for
You will increase your skill set to impress the boss and become the go-to person for Excel in the office.
You’ll get more done in less time in Excel. Say ‘hello’ to massive productivity in the office.
Your confidence in using Excel will soar and you will be super-marketable.
What’s included:
Solid foundation to build upon (great for beginners or as a refresher for the more seasoned Excel users)
Learn or refresh how to create a worksheet complete with formatting, formulas and functions
Learn to use the most popular functions in Excel, including if functions, lookup functions, text and data and time functions
Learn how to create professional looking pie charts, bar charts, column charts and more
Learn how to create datasets and tables and sort and filter your data
Learn how to create pivot tables and charts for a quick analysis
Follow along step-by-step instructions, demos and lessons
And some bonuses, too!
Downloadable follow-along demo files (BONUS!)
Downloadable PDF’s (BONUS!)
Quizzes (BONUS!)
Future updates and topics (I am constantly adding new topics)
30-day money back guarantee
Who this course is for:
This course is perfect for a first-time beginner who needs to learn much more than just the basics. No more wondering what you should learn first.
This course is also helpful for the Excel user who is ready to expand their skills in areas such as using advanced functions; creating charts, graphs and tables; creating pivot tables and charts and more. No more trying to guess which task to use in certain situations.
This course is helpful for increasing personal productivity, efficiency at work or even developing skills to obtain a better job. Increase your confidence in using Excel.
People who want to learn Excel at their own pace and pick and choose which skills they want to work on and when. No more wasting time going through lessons you don’t need.
This course is NOT for:
This course would not be useful for an Excel user who has already reached the advanced level.
What others have said about my courses:
⭐⭐⭐⭐⭐ “I wish I had taken this course before I took my first Excel class in college. This course explains all the basics that I had to learn through trial and error. Incredibly helpful information!” ~Paula (Foundations of Excel)
⭐⭐⭐⭐⭐ “I have been using Excel for years and I learned more in one class with Vivian than I did from any other instructor.” ~former student
⭐⭐⭐⭐⭐ “I was able to get the promotion I wanted by taking Foundations of Excel. It was fast and much easier than I thought it would be. Vivian has an easy-to-follow method of teaching and I was able to finish what I needed from the course in a couple of hours.” ~former Foundations of Excel student
⭐⭐⭐⭐⭐ “This is such a clear and concise explanation. Thanks for giving the terms and showing the layout slowly, and demonstrating as you do. You're a gifted teacher Vivian.” ~Peri
⭐⭐⭐⭐⭐ “It has helped me quite a bit and I have learned some shortcuts I didn’t know about.” ~Dolores
⭐⭐⭐⭐⭐ “30 minutes working with Vivian 1:1 saved me hours of work trying to learn on my own.” ~former student and client
⭐⭐⭐⭐⭐ “I find Vivian’s courses easy to understand and follow. I feel much more confident in Excel!” ~Connie
Who this course is for:
- Individuals wanting to expand their Excel skills
- Anyone who needs to learn Excel from the ground up
- Users who have a basic understanding of Excel and who are ready to go deeper into the more advanced topics
- Anyone who wants to learn Excel at their own pace and/or pick and choose what topics they learn and in what order
Course content
- Preview01:05
- Preview01:14
- Preview00:26
Instructor
Hi, I’m Vivian with Vivian Says Solutions and I teach Microsoft Excel and Access in easy-to-understand ways so you can save time and money by improving productivity with better, faster and maybe even automated spreadsheets and databases.
I have helped countless companies save hundreds of hours a month (and lots of money!) by teaching their employees to be more efficient using the software or by automating Excel spreadsheets and/or Access databases.
I am a Microsoft Certified Master Office Instructor and have over 20 years experience teaching and using MS Office. I specialize in MS Excel and Access. I have experience using MS Office in different capacities from corporate to military to small business and I bring that experience to the classroom with me.