WANT TO BECOME CONFIDENT IN EXCEL?
Looking to learn Microsoft Excel but don't know where to start?
OR, you've been using Excel for a while but don't feel 100% confident?
There is so much information out there. What do you really need to succeed at work?
I’ve picked out the Excel Essential skills a Data Analyst needs and packaged them in a structured course.
In fact, I collected the most common Excel problems faced by my clients. I added in my 15+ years' experience in finance and project management. I included all the hidden tips and tricks I came to learn as an Excel MVP and put it ALL in THIS course. I also made sure it covers the absolute Excel beginners.
These practical, real-world examples help you understand the full potential of each feature. You'll learn how to use Excel for quick and painless data analysis.
There are many helpful and time-saving Excel tools. We tend to forget what these are if we don't use them. This Excel Essentials Course will give you the practice you need to be able to apply the best solution for the task at hand. This way you can do more in less time.
WHY TAKE THIS COURSE?
Yes. There are many Microsoft Excel courses out there teaching you the important Excel functions and features you need to master.
BUT, can you apply what you learnt to your own files?
Do you get enough practice and challenges to remember all the new information?
This course will get you confident and comfortable designing simple to complex spreadsheets. You'll go beyond Excel basics. As you go through the course, you'll be able to apply what you learnt immediately to your job.
You'll master new formulas and find better ways to setup your existing spreadsheets. Management loves efficiency.
In this course you'll solve dozens of practical real-world examples. They'll help you think outside the box so you can work smarter not harder.
⯆ Over 10 hours of video content
⯆ Practice & Solution Workbooks for each Section
⯆ Challenges & Quizzes to test your understanding
⯆ Course notes summarizing the most important points
⯆ Digital certificate of completion
⯆ BONUSES ONLY AVAILABLE HERE! (see right below)
BONUSES (ONLY INCLUDED HERE)
BONUS 1: Get the whole course as an eBook! Your detailed manual takes you step by step through the course. This way you can read & review when you like. Watch when you have time (you'll get this after 30 days after enrollment).
BONUS 2: Downloadable videos so you don't have to worry about internet connection.
WHAT YOU'LL BE ABLE TO ACHIEVE
By the end of the course you'll be confident and comfortable showcasing your new skills at work, allowing you to:
- Input data and navigate large spreadsheets
- Apply hacks to get your work done faster
- Be able to choose the right formula to automate your analysis
- Use hidden features to transform messy data to proper data sets
- Get answers from your data
- Organize, clean and manage large data
- Create compelling Excel reports by following the set of spreadsheet design principles
- Turn messy data into helpful charts
- Create interactive reports with Pivot Tables
- Import and transform data with tools like Get & Transform (Power Query)
We start from Excel basics to make sure we have the right fundamentals. We them move on to more advanced topics like Conditional Formatting, Excel Pivot Tables and Power Query. We cover important formulas like VLOOKUP, SUMIFS and nested IF Functions.
I don't just cover the purpose of a feature or formula but how you can take advantage of it using practical examples.
There are challenges and quizzes along the way to test your new Excel skills.
Your downloadable Excel Course Notes are available as a PDF file. These cover the most important points. Keep them handy and refer to them when you need to.
Get started now!
Valued at $174
Get it for an unbelievable price!
(why so cheap? See FAQ section below)
★★★★★ "Leila has an extraordinary way of breaking down complex formulas to understand how the mechanics actually work so you start to imagine on your own different combinations of formulas to solve complex questions.” Lisa
★★★★★ “The instructor's explanations and referencing real-world situations are just what is needed to understand how these formulas can help you work smarter.” Keith
★★★★★ "It was just what I needed! Definitely a great hands on way for someone with existing excel skills to pick up great "hacks" for excel." Teo
★★★★★ "Lots of tips and techniques. Already using them in my own work!" Alison
★★★★★ "I am really enjoying the course, Leila is a great instructor. Every lesson I learn something useful to improve my day to day with excel." Alisa
IS THIS ONLINE EXCEL COURSE FOR BEGINNERS ONLY?
This Complete Excel Course is for two types of people:
- Excel beginners, i.e. anyone looking to learn Excel from scratch
- Excel intermediate and Excel advanced users who want to make sure their skills cover all the essentials. This includes many Excel tricks and hidden features few data analysts know of.
The Excel Essentials for the Real World Course covers ALL the fundamentals an Excel beginner needs to know. BUT it also fills in the gaps for Excel Intermediate and Advanced users. It's for corporate professionals who feel comfortable with Excel but not 100% confident.
This is more than an Excel Basics Course. It starts off easy and adds in tips and tricks many Excel advanced users don't know of.
Organized Workbooks to Practice as you go through each Section
Along the way I will challenge you to apply what you learnt to solve a practical problem
You'll have Course Notes that summarize the most important points for you
AND a Comprehensive Manual that explains all the concepts and steps in detail
My courses & tutorials are for those who use Excel at work and want to become better. For those that want to contribute by coming up with solutions to problems.
I don’t just want to show you solutions, but to inspire you to experiment, create and share that with others.
On my YouTube channel, I share Excel tips & tricks based on questions I get from the Excel online community & professionals at my training sessions.
I am a Certified Microsoft Excel Expert and was given the Microsoft Excel MVP award in 2017. I have over 15 years of experience implementing and training users on Management Information Systems of different sizes and nature - these include SAP BW and Oracle HFM.
My background is: Masters in Economics, Economist, Consultant, Oracle HFM Accounting Systems Expert & Project Manager. My passion is teaching and solving difficult Excel problems. I am also addicted to learning and enjoy taking online courses on a variety of topics.
I founded XelPlus in 2015. My aim with my site is to help people gain the knowledge they need so they can create useful tools, solve problems and get more done.
Let's start now.
StartOverview - Data Input & Hidden Excel Features (1:40)
StartData Entry and Editing (7:14)
StartBasic Excel Formulas (9:26)
StartText to Speech (Hidden Feature) (3:09)
StartCorrectly Input Dates and Time Stamps (4:25)
StartUse AutoFill To Do Your Work (3:56)
StartFlash Fill for Major Time Saving (Become Pro) (5:11)
StartCustom Lists With AutoFill (Hidden Feature) (2:30)
StartInputting & Editing Comments & Notes (8:13)
StartFinding Formula & Input Cells with ONE Click (Become Pro) (3:59)
PreviewData Validation to Reduce Time Checking Data (11:04)
StartAdding Tool Tips (Screen Tips in Excel) (2:18)
StartLearn to Work with Pictures, Shapes & Other Objects (5:30)
StartQuiz: Data Input in Excel
StartChallenge: Data Manipulation & Preparation
PreviewSolution: Data Manipulation & Preparation (5:41)
StartSummary: Key Features to Impress & Save Time
Who's RIGHT for this course
- Business professionals looking to become more confident in Excel.
- Absolute beginners who want a structured, engaging, fun and practical Excel course.
- Excel users who want to discover & showcase new tips and tricks from Excel MVPs.
- Students who want to make sure they have the Excel knowledge to succeed at their next job.
- Data analysts looking to discover new tools to help them do more in less time.
- This course is designed for Excel on Windows (some techniques might not work on Mac)
- Microsoft Excel 2016/2019 or Office 365 (Note: most tips work on ALL Excel versions but some will only apply to 2016 and above)
- No prior Excel knowledge is needed. We will start from scratch.
- Willingness to learn. Let's do this!
Why Start Now?
Excel in itself can do so much for your career. It's just one program but it's the one hiring managers are interested in.
That’s why basic Microsoft Excel skills is a mandatory requirement for most office-based professionals today.
Superior Excel skills can get you a promotion. Some jobs require that to begin with.
This course will take you from Excel beginner to professional.
There's a 100% money back guarantee. You have nothing to lose.
Excel Essentials comes with lifetime access. Buy now. Watch anytime.