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 F …
10th Sep 2018
Excel 2016 tutorial on how to apply the AutoFilter feature to your database, allowing you to filter your records by column label, or header.
28th Aug 2017