access
lifetime
content
2 Hours
Description
This beginner-friendly class is divided into sections to help you master the world's leading spreadsheet software. In the first part, you'll learn the Excel interface and how it is laid out. In part two, you'll learn how to create and open Excel files, add, delete, and change the name of worksheets. In part three, you'll learn to insert data manually and automatically. The final part will be dedicated to formulas and functions that are crucial to working with data automatically.- Access 28 lectures & 2 hours of content 24/7
- Learn the Excel interface
- Customize the Excel quick access & ribbon toolbars
- Understand the structure of an Excel Workbook
- Create, save & open an Excel document
- Add, rename, & delete worksheets
- Enter text manually & automatically w/ the autofill tool
- Create formulas using logical operators
- Learn & apply the primary functions
Instructor
Luis Carlos is a Telecommunications Engineer with experience as a trainer in mathematics, computer science, and web development.Important Details
- Length of time users can access this course: lifetime
- Access options: web streaming, mobile streaming
- Certification of completion included
- Redemption deadline: redeem your code within 30 days of purchase
- Experience level required: beginner
Requirements
- Internet required
Terms
- Unredeemed licenses can be returned for store credit within 15 days of purchase. Once your license is redeemed, all sales are final.
Course Outline
- Introduction to Microsoft Excel
- Introduction - 1:56
- Excel interface overview - 4:25
- Excel Ribbon - How to work and how to customize - 3:50
- Quick Access Toolbar - How to use and edit - 1:38
- Start Working With Excel - Learn Fundamental Tools
- Excel Workbooks - Create, Open and Save files - 5:18
- Working with Worksheets - Add, delete and change name - 2:44
- Automatic data with autofill - save time using this tool - 5:25
- Rows and columns - Add and delete - 4:07
- Hide & Unhide Rows/Colums and Worksheets - 4:20
- Change row and column size - 3:29
- Wrap, shrink and merge text - 4:05
- First Challenge - Practical exercise using Font tools - 3:27
- Format painter tool - Another powerfull tool to save time - 2:46
- Format Numbers Tool - Date and Time Format - 5:00
- Identify and Remove Duplicates Values - 4:10
- Sort and Filter Tools - 14:28
- Formulas and Functions to manipulate your Data
- Cell references to link data - Relative, absolute and mixed - 8:09
- Formula Anatomy - How to create a formula using Math operators - 4:43
- Use Functions in Excel - Syntax used to create functions - 4:07
- Sum Numbers with Sum Function - 2:34
- Average Function for cells ranges average calculation - 1:35
- How to use Statistical Functions Min and Max - 2:00
- Count and CountIf Functions - 5:31
- Exercise with Logical Functions IF, OR and AND for single and multiple condition - 7:10
- Conditional Addition with Sumif and Sumifs - 3:54
- Extract Data using Vlookup Reference Function - 6:08
- Hlookup Function to Extract Data - 2:43
- Offset function for dinamyc ranges - 14:51
