Introduction to Excel
4.5 /5- Offered by365DataScience
Introduction to Excel at 365DataScience Overview
Duration | 4 hours |
Mode of learning | Online |
Official Website | Go to Website  |
Credential | Certificate |
Introduction to Excel at 365DataScience Highlights
- Earn a Certificate of Completion from 365datascience
- Gain expertise on widely used skills like Data Analysis, Data Visualization, Excel
Introduction to Excel at 365DataScience Course details
- Understand Excel best practices
- Navigate spreadsheets professionally
- Use keyboard shortcuts
- How to use Excel functions
- Insert and format different types of charts
- Work with pivot tables
- This course teach all the Excel skills that need to perform multi-layered calculations, create charts, manipulate data, look up functions, and more
- This course will teach how to apply various Excel techniques for performing calculations, data manipulations, analyses, and more
- This course gives the skills that need to crunch numbers in the spreadsheet software program
Introduction to Excel at 365DataScience Curriculum
Welcome! Course Introduction
Welcome to the Course
Excel Made Easy: A Beginner's Guide to Excel Spreadsheets
Data Entry Techniques in Excel
How to Make Your Spreadsheets Look Professional
Inserting, Deleting, and Modifying Rows & Columns
Excel Formulas for Beginners
Excel Functions
Work Efficiently by Using Cut, Copy, and Paste
Formatting
Pasting Values, Formulas and Formats with Paste Special
Useful Tools & Tips
Inserting a Line Break with Alt + Enter
Do More with Your Sales Data with Excel's Text to Columns Feature
Create Easily Printable Excel Documents
How to Wrap Text in Excel and Adjust a Cell's Size
Insert Hyperlinks into Excel Spreadsheets
Using Excel's Freeze Panes to Handle Large Datasets
Beginner, Intermediate & Advanced Functions
Key Excel Functions: If
Enlarge the formula bar
Key Excel Functions: Sum, Sumif, Sumifs
Key Excel Functions: Count, Counta, Countif, Countifs
Key Excel Functions: Average & Averageif
Practical Exercise "Build A P&L From Scratch
Introduction to the Case Study
What You Will See Next
Understand Your Data Source Before You Start Working on It
Ordering the Source Worksheet
Create a Code: The Best Way to Organize Your Data and Work Efficiently with It
Introduction To Excel Charts
Introduction to Excel Charts
Beginner's Guide to Inserting Charts in Excel
Modifying Excel Charts - The Easy Way
Making Your Excel Charts Sexier - Proven Tips
Creating a Bridge Chart in Excel 2016 - As Easy as It Gets
Building Professional Charts In Excel
Stacked Column Chart with a Secondary Axis
Doughnut Chart
Area Chart
Bridge Chart
Introduction to Excel at 365DataScience Faculty details
Other courses offered by 365DataScience
Student Forum
Anything you would want to ask experts?