EXCEL at Work - Complete MS Excel Mastery Beginner to Pro
5.0 /5- Offered byUDEMY
EXCEL at Work - Complete MS Excel Mastery Beginner to Pro at UDEMY Overview
Duration | 7 hours |
Total fee | ₹449 |
Mode of learning | Online |
Credential | Certificate |
EXCEL at Work - Complete MS Excel Mastery Beginner to Pro at UDEMY Highlights
- Earn a certificate of completion from Udemy
- Learn from 24 downloadable resource & 7 articles
- Get full lifetime access of the course material
- Comes with 30 days money back guarantee
EXCEL at Work - Complete MS Excel Mastery Beginner to Pro at UDEMY Course details
- This course is perfect for a first time beginner who needs to learn much more than just the basics
- This course would also be helpful for an intermediate Excel user who needs to improve their skills in areas such as using functions; creating charts, graphs and tables; creating pivot tables and charts; formatting spreadsheets; navigating efficiently within an Excel worksheet and more
- This course is helpful for increasing personal productivity, efficiency at work or even develeping skills to obtain a better job
- This course would not be useful for an Excel user who has already reached the advanced or expert stage
- Create a basic Kitchen Remodel Costs worksheet
- Learn to use the 7 most popular functions in Excel, including IF functions and VLOOKUP
- Create professional looking pie charts, bar charts, column charts and more
- Create a table and a range and sort your data
- Create pivot charts and tables to do lightening fast analysis of your data
- Learn to use new features of Excel including 1-click forecasting and 3D maps
- Take your Excel skills to a whole new level to impress your boss and (although it's ultimately up to you) position yourself for the raise or promotion you deserve
- This course is designed to teach you the basics of Microsoft Excel all the way to Excel mastery
- This course is designed to teach you the most popular functions and features of Excel that most people wish they knew how to do
- in this course, you'll quickly become comfortable using the entire Excel dashboard including its tabs, ribbon and tools
- You'll learn all the basics of opening an Excel document, creating a spreadsheet from scratch, writing formulas and saving your document to your computer
EXCEL at Work - Complete MS Excel Mastery Beginner to Pro at UDEMY Curriculum
Introduction to Microsoft Excel
Introduction
How to Get the Most Out of This Course
Take a Tour of the Excel Dashboard - How to Use the Tabs and Ribbon
Using Excel Templates to Save Time and Effort
Creating your first excel document
Saving your document where you can find it
Entering data and Navigating around the cells
Creating Simple Formulas to Do Powerful Calculations
Working with Workbooks and Worksheets
Create a kitchen remodel cost worksheet
Introduction - Creating and Formatting your heading
Formatting Subheadings and Columns and Alphabetizings Lists
Entering and Formatting Numbers
Create Formulas to Quickly Calculate Your Costs
Formatting - Grids and Spacing
Introduction to Excel formulas and functions
Introduction to Excel formulas and functions
What is a Formula and What Can It DO for You?
What is a Function and What Does IT Do?
3 Things to know before you start using functions
The Anatomy of a Formula
Quickly select cells to use in your formula
Absolute vs. Relative Cell References
How to use the 7 most popular excel functions
How to Use the Downloads to Learn Functions Faster
AVERAGE and AVERAGEA Functions
COUNT, COUNTA and COUNTBLANK Functions
IF Functions
SUMIF and SUMIFS Functions
COUNTIF and COUNTIFS Functions
VLOOKUP Function
LEFT, RIGHT and MID Functions
Other popular excel functions
CONCATENATE - Combining Text
LEN - Length of Text
FIND and SEARCH
MIN and MAX
AND and OR
ROUND, CEILING and FLOOR
TODAY and NOW
CONDITIONAL FORMATTING
ALT Shortcut Keys for INDEX/MATCH Lecture
INDEX and MATCH
UPPER, LOWER, and PROPER
EXCEL at Work - Complete MS Excel Mastery Beginner to Pro at UDEMY Faculty details
Other courses offered by UDEMY
Student Forum
Anything you would want to ask experts?