Microsoft Excel Beginners & Intermediate Excel Training
5.0 /5- Offered byUDEMY
Microsoft Excel Beginners & Intermediate Excel Training at UDEMY Overview
Duration | 4 hours |
Total fee | ₹3,499 |
Mode of learning | Online |
Credential | Certificate |
Microsoft Excel Beginners & Intermediate Excel Training at UDEMY Highlights
- Get a certificate of completion from Udemy
- 3.5 hours on-demand video
- 182 downloadable resources and 4 articles
- Access on mobile and TV
- Assignments
- 30-Day Money-Back Guarantee
- Full Lifetime Access
Microsoft Excel Beginners & Intermediate Excel Training at UDEMY Course details
- For Beginner, Intermediate and Advanced users who want to be proficient in Excel
- This training is highly recommended for university students, entry-level finance, business and marketing professionals who would like to grow faster than their peers
- A solid understanding of Excel opens the door for a number of career paths
- Top Excel users are promoted very easily inside large corporations
- Excel skills remain with learner and provide extra security. You won?t ever have to fear unemployment
- The course 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 charts, and other tools that are often used for the purposes of financial modeling
- The course includes practical case studies that will reinforce everything to learn
- One of the exercises we will see in the course consists of building a complete Profit & Loss statement from scratch
- Work comfortably with Microsoft Excel 2016 and many of its advanced features
- Learner will learn to use sophisticated functions that will improve the quality of your work
Microsoft Excel Beginners & Intermediate Excel Training at UDEMY Curriculum
Welcome! Course introduction
What does the course cover?
Bonus Gift Number 1
Bonus Gift Number 2
Quiz Number 1
A quick introduction to the basics of Excel
Overview of Excel
The Excel 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
Format Cells
Pasting Values, Formulas and Formats with Paste Special
Quiz Number 2
Assignment 1
Basic Excel - Practice Activity
Excel best practices: Useful tips and 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 columns
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
Completing 33% of the course
Introduction to Custom Formatting
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
Keyboard shortcuts in Excel
Keyboard Shortcuts Save LOTS of time in Excel
Excel functions
A helpful consideration
Key Functions in Excel: COUNT, COUNTA, COUNTIF, COUNTIFS
Key Functions in Excel: SUM, SUMIF, SUMIFS
Key Excel Functions: AVERAGE & AVERAGEIF
Completing 50% of the course
Working with Text in Excel: LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE
Find the Highest and the Lowest Values in a Range: MAX & MIN
Include ROUND in Your Financial Models
Transferring data efficiently: VLOOKUP and HLOOKUP
Use INDEX & MATCH as a Substitute of VLOOKUP
The Perfect VLOOKUP Substitute: XLOOKUP (Office 365 Only)
IFERROR Allows You to Deal Easily with Error Messages
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
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
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
Substituting VLOOKUP with XLOOKUP (Office 365 Only)
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
Practical exercise - SUMIFS
Practical Exercise - SUMIFS
Completing 100% of the course
Other courses offered by UDEMY
Microsoft Excel Beginners & Intermediate Excel Training at UDEMY Students Ratings & Reviews
1 Rating- 4-51
Student Forum
Anything you would want to ask experts?