• Title Subjects
  • Data
Excel Functions and Formulas Video Tutorials

Excel Functions and Formulas Video Tutorials

Brian Moriarty and Theodor Richardson
Video
March 2020
9781683924890
More details
  • Publisher
    Mercury Learning and Information
  • Published
    15th March 2020
  • ISBN 9781683924890
  • Language English
$99.95

This video package will provide basic and intermediate skills using Microsoft Excel 2019/365, as well as earlier versions. The package includes twelve videos which focus on mastering Excel functions and formulas with step-by-step instructions using realistic data and samples.

Topics range from creating a variety of tables, inserting and manipulation of charts, data validation, row and column formulas, and much more.

The following is the list of videos included in the package:

Ampersand Concatenate – 4 ways of joining cells
Data Validation – Adding Dropdown Lists
IF IFS Switch Lookup
Inserting Charts in Excel
Labeling Charts
MAXIFS & MINIFS
TABLES - Add Rows and Columns Formulas
TABLES – Create
TABLES – Referencing
TABLES - Sort & Filter
TABLES - Totals
The SUM Formula

To purchase, please email info@merclearning.com

Ampersand Concatenate – 4 ways of joining cells
Data Validation – Adding Dropdown Lists
IF IFS Switch Lookup
Inserting Charts in Excel
Labeling Charts
MAXIFS & MINIFS
TABLES - Add Rows and Columns Formulas
TABLES – Create
TABLES – Referencing
TABLES - Sort & Filter
TABLES - Totals
The SUM Formula

Brian Moriarty

Brian Moriarty is a Microsoft Office Specialist Master who has been automating Office products for more than 20 years; he also teaches employee groups at the corporate level.

Theodor Richardson

Theodor Richardson is the Associate Vice Chancellor for Academic Affairs at South College and has written several books in areas of computer science.

Computer Science; MS Excel; Data Science; Analytics; Business