Microsoft Excel - Getting Started With The MS Excel Basics
- Offered byUDEMY
Microsoft Excel - Getting Started With The MS Excel Basics at UDEMY Overview
Duration | 2 hours |
Total fee | ₹396 |
Mode of learning | Online |
Credential | Certificate |
Microsoft Excel - Getting Started With The MS Excel Basics at UDEMY Highlights
- Earn a Certificate of completion from Udemy
- Get a 30 days money back guarantee on the course
- Get full lifetime access of the course material
- Learn from 37 downloadable resources and 24 articles
Microsoft Excel - Getting Started With The MS Excel Basics at UDEMY Course details
- Learn everything you need to get Excel onto your resume or CV
- Learn basic formulas such as SUM & AVERAGE
- Learn basic charts to present your work
- Learn how to prepare your work for printing
- Learn some simple best practice principles to get the most out of Excel
- Microsoft Excel - Getting Started With The Basics, is an Excel Course where you can learn how to get the most out of Microsoft Excel
- Learn all about MS Excel cells, Excel rows & columns, how to speed up your work with Excel spreadsheets and easiest ways of sorting & filtering data in Excel 2010 and onwards
- This course explore some of the most popular Excel charts and graphs, and Excel formulas and functions and from there we will dive into best practices to make sure you know Excel Essentials for the real world
- This course is exactly as described: a beginner's tutorial on the most basic and fundamental aspects of Excel
Microsoft Excel - Getting Started With The MS Excel Basics at UDEMY Curriculum
Master the basics
Formatting Text, Cells & Borders (make tables look great in MS Excel)
How to Use & Customise Text Styles
Preparing Your Work for Printing in MS Excel
Inserting shapes, text boxes and smart art
Managing data
How to Sort Your Data Correctly
Using Autofilter to Effectively Search & Filter Your Data
Tables & Named Ranges
Creating Drop Down Selections & Restricting Data Entry Using Data Validation
How To Colour Cells Depending on Their Contents Using Conditional Formatting
How to Import External Data From Databases
How to Download Data Tables From Websites
What to do When Excel Can't Read Your Data - Text To Columns
Creating Excel Charts - Pie & Bar/Column
Enriching data with functions
SUM, AVERAGE, MIN and MAX
Absolute vs Relative cell references
SUMIF, COUNTIF, AVERAGEIF
Referencing Tables & Named Ranges Correctly
Nesting Functions
Analysing data with charts
Preparing your data for charts
Pie & Donut Charts
Line Charts
Bar & Column Charts
Chart & Axis Formatting