Excel Beginners Guide: Fundamental Tools to Work Smarter

Excel Beginners Guide: Fundamental Tools to Work Smarter

2 Reviews
196 Enrolled
2 Hours
Deal Price$9.99
Suggested Price
$50.00
You save 80%
Excel Beginners Guide: Fundamental Tools to Work Smarter
2 Reviews
$9.99$50.0080% OFF
Excel Beginners Guide - Fundamental Tools to Work Smarter

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
Excel Beginners Guide: Fundamental Tools to Work Smarter
2 Reviews
$9.99$50.0080% OFF
View similar items
DescriptionInstructorImportant DetailsReviewsRelated Products

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

LC
Luis CarlosLuis Carlos | Engineer & Web Developer
4.1/5 Instructor Rating: ★ ★ ★ ★ ★ ★
Luis Carlos is a Telecommunications Engineer, with an experience as a trainer in Mathematics, Computer Science, and Web Development, having participated in many projects directed to student. Several years of training helped him develop many skills. Transmitting knowledge and contributing to the personal development of each person is his goal in his courses.

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 wth 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
  • Have questions on how digital purchases work? Learn more here

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.
2 Reviews
4.5/ 5
All reviews are from verified purchasers collected after purchase.
Diane Jaeger Ploussard profile picture

Diane Jaeger Ploussard

Verified Buyer

I had not used spreadsheets in years and could not remember the formulas. This has been a lifesaver for me. I have had to use spreadsheets a lot lately and this has helped me so much. Thank you for offering it and at such a great price.

Dec 1, 2022
SY

Siew Lin, Vivien Yoong

Verified Buyer

Easy to understand

Feb 25, 2020
Your Cart
Your cart is empty. Continue Shopping!
Processing order...