Skill Beast
Sign In
Sign In
Reset Password
  • HomePage
HomePage
Free
Microsoft Excel 2013 Basics
1
12345

Description

This free online Excel class is created with the goal of helping you learn Microsoft Excel. In these video tutorials I will teach how to use Microsoft Excel 2013 specifically, but most of the information is applicable to previous versions as well.

Through these engaging lessons you will learn how to use math, statistical, logic and text functions, organize data by sorting and filtering, effectively present your data in several chart formats and more.

Take This Course

Students

Lessons

Free

Introduction

Free

Back To Basics: Number Format, Keyboards, PivotTables, Formulas

Free

Formulas: Comprehensive Examples [12]

Free

Formulas: Calculation Order of Precedence

Free

Formulas: Increase or Decrease Percentage

Free

Cell References: Relative, Absolute & Mixed (8 Examples)

Free

Table Formulas Nomenclature / Structured References [22 Examples]

Free

Scenarios To Save Sets Of Formula Inputs, Paste Special Trick

Free

3D Cell References and Worksheet, Workbook References

Free

Defined Names & Aggregate Functions

Free

AND & BETWEEN Criteria: SUMIFS, COUNTIFS, AVERAGEIFS, more

Free

Calculations With OR Criteria: COUNTIFS, DCOUNTA, SUMIFS, DSUM

Free

AND & OR Criteria Calculations: D Functions like DSUM, DCOUNT

Free

AND & OR Criteria Calculations: Table Feature

Free

AND, OR, IF Functions For AR Dept (Multiple Logical Tests)

Free

IF & IS Functions To Deliver Numbers, Text, Formulas, Nested IFs

Free

Round Functions: ROUND, MROUND, ROUNDUP, CEILING, more…

Free

Introduction To SUMPRODUCT Function

Free

VLOOKUP Function 20 Examples, VLOOKUP Formula, Excel VLOOKUP

Free

Text Functions RIGHT, LEFT, MID, SEARCH for Partial Text VLOOKUP

Free

VLOOKUP, DGET & MATCH For Looking Up Records 7 Examples

Free

INDEX and MATCH Functions For Unusual Lookups

Free

CHOOSE function to lookup table for VLOOKUP With Multiple Tables

Free

VLOOKUP and IFNA for Commissions

Free

Getting Top 5 Values With LARGE And Bottom 5 With SMALL

Free

Goal Seek: Get Formula To Evaluate To Desired Result

Free

Excel Compare Two Lists Formula: Item In List? Item Not In List?

Free

Grading: Calculate Current Percentage & Decimal Grade

Free

How To Track Down Excel Formula Errors (16 Examples)

Free

Excel Data Validation: List, Date, Time, Custom (22 Examples)

Free

Flash Fill: Extract, Combine, Insert, Reverse Data (25 Example)

Free

Custom Number Formatting & Text Functions, (33 Examples)

Free

Date Functions: EDATE, EOMONTH, DATE, YEAR, MONTH, DAY, More

Free

Introduction To Array Formulas and Array Functions

Take a course to view this content

Related Courses

Free
Microsoft Excel 2013 Basics
1
12345
Note : http://SkillBeast.org/ does not host any of the videos/files/documents mentioned here. We are trying to provide you the best training materials and content and cool looking website. The Content is taken from reputed websites we have mentioned the site over there . The content on site is not duplicated .
  • HomePage