Excel Beginners Guide: Fundamental Tools to Work Smarter

2 Reviews

189 Enrolled

2 Hours

$9.99$50.00

You save 80%

28 Lessons (2h)

Introduction to Microsoft Excel
Introduction1:56
Excel interface overview4:25
Excel Ribbon - How to work and how to customize3:50
Quick Access Toolbar - How to use and edit1:38
Start Working With Excel - Learn Fundamental Tools
Excel Workbooks - Create, Open and Save files5:18
Working with Worksheets - Add, delete and change name2:44
Automatic data with autofill - save time using this tool5:25
Rows and columns - Add and delete4:07
Hide & Unhide Rows/Colums and Worksheets4:20
Change row and column size3:29
Wrap, shrink and merge text4:05
First Challenge - Practical exercise using Font tools3:27
Format painter tool - Another powerfull tool to save time2:46
Format Numbers Tool - Date and Time Format5:00
Identify and Remove Duplicates Values4:10
Sort and Filter Tools14:28
Formulas and Functions to manipulate your Data
Cell references to link data - Relative, absolute and mixed8:09
Formula Anatomy - How to create a formula using Math operators4:43
Use Functions in Excel - Syntax used to create functions4:07
Sum Numbers with Sum Function2:34
Average Function for cells ranges average calculation1:35
How to use Statistical Functions Min and Max2:00
Count and CountIf Functions5:31
Exercise with Logical Functions IF, OR and AND for single and multiple condition7:10
Conditional Addition with Sumif and Sumifs3:54
Extract Data using Vlookup Reference Function6:08
Hlookup Function to Extract Data2:43
Offset function for dinamyc ranges14:51

Learn the Essential Tools of Microsoft Excel to Format & Manipulate Data Using Formulas & Functions

Luis Carlos

Instructor

Luis Carlos is a Telecommunications Engineer with experience as a trainer in mathematics, computer science, and web development.

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

Specs

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 30 days of purchase. Once your license is redeemed, all sales are final.

Your cart is empty. Continue Shopping!

Processing order...