Excel Beginners Guide: Fundamental Tools to Work Smarter

2 Reviews
182 Enrolled
2 Hours
$10.00$200.00
You save 95% -

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

LC
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.