Microsoft Excel 2016 Tutorial for Beginners – How to Use Excel Part 7

Описание

This is a Microsoft Excel 2016 Basic Tutorial for beginners. In this basic course Excel video tutorial, you’ll learn how to create Array Formulas including single and multiple Arrays, create Tables to more easily organize your data and remove duplicate records fast, modifying and formatting Tables, how to create a Custom Table Style, sorting and filtering Table records, DSUM, DAVAERAGE and DCOUNT database functions, date and time functions, sorting a database and the Top Excel Database Design Flaws, applying AutoFilter, using the Advanced Filter and using the Subtotals feature and Subtotal Function.

1. Single and Multiple Array Formulas
2. Create Tables
3. Modifying Tables
4. Custom Table Styles
5. Table Sorting and Filtering
6. DSUM, DAVERAGE and DCOUNT
7. Date and Time Functions
8. Database Sorting and Top Database Design Flaws
9. AutoFilter
10. Advanced Filter
11. Subtotals Feature and Subtotals Function

All 160 of my Excel 2016 training videos contain everything you need to help pass both the Microsoft Office Excel 2016 Core (77-727), and Expert (77-728) exams and become certified!





DVD & DOWNLOAD AVAILABLE:
https://www.DreamForce.us

SUBSCRIBE to learn more Microsoft Office tips, tricks and shortcuts!
http://www.youtube.com/subscription_center?add_user=videotrainingpro

LET'S CONNECT!
-- http://www.linkedin.com/in/kirt-kershaw-33874410