• Title Subjects
  • Data

Excel Functions and Formulas Video Tutorials

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. Moriarty and Theodor Richardson are co-authors of the best-selling book, Microsoft Excel 2019/365 Functions and Formulas.

Theodor Richardson

Theodor Richardson is the Assistant Dean for the College of Business/Online at a private university. Richardson and Brian Moriarty are co-authors of the best-selling book, Microsoft Excel 2019/365 Functions and Formulas.

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