Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
Do you want to learn how to work with Excel 2016?
Even if you don’t have any prior experience?
Would you like to take your skills to the next level and become an advanced user?
If so, then this is the right course for you!
Microsoft Excel 2016 is here, and it promises to be one of the greatest versions that we’ve seen so far. It includes a number of great new features, while all of the old ones are still in place and much improved.
However, it’s essential that you learn how to work with it effectively.
If you want to become any of the following…
Then you simply have to learn Microsoft Excel 2016. There is no way around it.
But how can you do that if you have very limited time and no prior training? And how can you be certain that you are not missing an important piece of the puzzle?
Microsoft Excel 2016 Beginners & Intermediate Excel Training is here for you. One of the best Excel courses available on Udemy, it includes everything you’ll need. We will start from the very basics and then gradually build a solid foundation that will serve you well throughout your career.
What makes this course different from the rest of the Excel courses out there?
How come Microsoft Excel is so important?
Every large company uses it, right? So if you want to learn a new skill that is highly valued by all employers, you should start here.
Here are 5 more reasons why you should take this course and learn Excel:
This course is suitable for people without any previous experience in Excel. We will start from the very basics and will gradually move on to some of the more advanced features, such as lookup functions, functions with conditions, goal seek, pivot tables, custom formatting, Excel 2016 charts, and other tools that are often used for the purposes of Financial Modeling.
Additionally, the course includes practical case studies that will reinforce everything that you learn. One of the exercises that we will see in the course consists of building a complete Profit & Loss statement from scratch.
This course is perfect for University students, Entry-level Finance, Business and Marketing professionals who would like to grow faster than their peers.
Students of this course who complete 50% of the lessons get full, lifetime access to our five-star rated course “Beginner to Pro in PowerPoint: Complete PowerPoint Training”. It has a full price of $20.
Students of this course who complete 100% of the lessons get full, lifetime access to our five-star rated course “Finance 101: Financial Skills for the Real World”. It has a full price of $20.
Please don’t forget that the course comes with Udemy’s 30-day unconditional money-back-in-full guarantee. And why not give such a guarantee, when we are convinced that it will provide a ton of value for you?
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Welcome! Course Introduction|
What Does the Course Cover?Preview
Bonus Gift Number 1
Bonus Gift Number 2
Quiz Number 1
|Section 2: A Quick Introduction to the Basics of Excel|
Overview of Excel 2016Preview
The Excel 2016 Ribbon
Working with Rows & Columns
Data Entry in Excel
Introduction to Formatting
Creating Formulas in Excel
Microsoft Excel at Its Best - Functions
Work Efficiently By Using Cut, Copy & Paste
Pasting Values, Formulas and Formats with Paste Special
Quiz Number 2
|Section 3: Excel Best Practices: Useful Tips & Tools|
This Is How You Can Start Formatting Your Sheets in a Professional Way
Fast Scrolling That Would Allow You to Be 3x Faster
Fixing Cell References Properly
Using the Alt plus Enter combination
Learn How to Organize Your Excel Data with Text to ColumnsPreview
Wrapping Text in Excel
Create Easily Printable Documents by Using Set Print Area
Find and Select Special Types of Cells with Select Special (F5)
Learn How to Assign Dynamic Names within a Model
Excel Formulas that Make Sense - Named Ranges
Assigning Custom Formats to Specific Cells (Ex. Multiples)
Execute 50 Commands with a Single Click - Excel Macros
Create a Drop-Down List by Using Data Validation
Using Custom Sort in Order to Sort Multiple Columns within a Table
Create a Great Index Page at the Beginning of Your Financial Models
Freeze the Title Row of Your Table - Freeze Panes
Excel's "Tell Me" Search Bar
Quiz Number 1
|Section 4: Keyboard Shortcuts in Excel|
Keyboard Shortcuts Save LOTS of time in Excel
|Section 5: Excel 2016 Functions|
Key Functions in Excel: Count, Counta, Countif, Countifs
Key Functions in Excel: Sum, Sumif, Sumifs
Key Excel Functions: Average & Averageif
Working with Text in Excel: Left, Right, Mid, Upper, Lower, Proper, Co
Find the Highest and the Lowest Values in a Range: Max & Min
Include Round in Your Financial Models
Transferring Data Efficiently: Vlookup & Hlookup
Use Index & Match as a Substitute of Vlookup
Iferror Allows You to Deal Easily with Error Mesages
Excel's Dynamic & Interactive Tables: Pivot Tables
Create Flexible Financial Models with the Choose Function
Find the Result that You Are Looking For with Goal Seek
Include Sensitivity Analysis In Your Model Through Data Tables
Quiz Number 2
|Section 6: Create Professional Charts in Microsoft Excel 2016|
Introduction to Charts in Excel 2016
Inserting Charts in Excel & Learning About the Various Chart Types
Formatting of Excel Charts (1/2)
Formatting of Excel Charts (2/2)
Creating a Bridge Chart in Excel 2016 - As Easy As It Gets
An Easy Way to Create a Treemap
Use Sparklines to Show Data Trends
|Section 7: Build a Complete P&L from Scratch|
Introduction to the Case Study
This Is the data that we will use for our Exercise
Let's Reorder our Excel sheet and create a clear structure!
Introducing a Code: The best way to work with large amounts of data
Finishing Touches of our Database
Using Vlookup in Order to Transfer Data
Applying Sumif in Order to Populate the Database with Numbers
Demonstrating How Index & Match Can Successfully Replace Vlookup
Mapping the Items Within Our Database - A Key Exercise For Financial Analysts
Creating the Structure of the P&L Statement
Time for Some Formatting! The Secret of Creating Awesome Looking Excel Sheets
Populating the P&L sheet with figures
How do We Find Mistakes in the easiest way possible?
Finishing Touches: Calculating Year-on-Year Growth and Percentage Incidence
Quiz Number 3
Course Challenge - Apply Your Skills in Practice
365 Careers is a firm specializing in high-end financial training programs. Our growing list of courses includes Excel (Microsoft Excel for Beginner and Advanced users), PowerPoint, Financial Modeling, Company Valuation, Accounting, Investment Banking, Financial Planning & Analysis, and Job Hunting trainings. Our goal is to provide to our students the practical instruments they will need in order to perform successfully at their future workplace.