Microsoft Excel 2013 Basics

Introduction

Questions

Attachments

Syllabus

Lessons

Introduction
Back To Basics: Number Format, Keyboards, PivotTables, Formulas
Formulas: Comprehensive Examples [12]
Formulas: Calculation Order of Precedence
Formulas: Increase or Decrease Percentage
Cell References: Relative, Absolute & Mixed (8 Examples)
Table Formulas Nomenclature / Structured References [22 Examples]
Scenarios To Save Sets Of Formula Inputs, Paste Special Trick
3D Cell References and Worksheet, Workbook References
Defined Names & Aggregate Functions
AND & BETWEEN Criteria: SUMIFS, COUNTIFS, AVERAGEIFS, more
Calculations With OR Criteria: COUNTIFS, DCOUNTA, SUMIFS, DSUM
AND & OR Criteria Calculations: D Functions like DSUM, DCOUNT
AND & OR Criteria Calculations: Table Feature
AND, OR, IF Functions For AR Dept (Multiple Logical Tests)
IF & IS Functions To Deliver Numbers, Text, Formulas, Nested IFs
Round Functions: ROUND, MROUND, ROUNDUP, CEILING, more…
Introduction To SUMPRODUCT Function
VLOOKUP Function 20 Examples, VLOOKUP Formula, Excel VLOOKUP
Text Functions RIGHT, LEFT, MID, SEARCH for Partial Text VLOOKUP
VLOOKUP, DGET & MATCH For Looking Up Records 7 Examples
INDEX and MATCH Functions For Unusual Lookups
CHOOSE function to lookup table for VLOOKUP With Multiple Tables
VLOOKUP and IFNA for Commissions
Getting Top 5 Values With LARGE And Bottom 5 With SMALL
Goal Seek: Get Formula To Evaluate To Desired Result
Excel Compare Two Lists Formula: Item In List? Item Not In List?
Grading: Calculate Current Percentage & Decimal Grade
How To Track Down Excel Formula Errors (16 Examples)
Excel Data Validation: List, Date, Time, Custom (22 Examples)
Flash Fill: Extract, Combine, Insert, Reverse Data (25 Example)
Custom Number Formatting & Text Functions, (33 Examples)
Date Functions: EDATE, EOMONTH, DATE, YEAR, MONTH, DAY, More
Introduction To Array Formulas and Array Functions

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