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
Microsoft Outlook 2016 training video on how to modify the AutoCorrect feature which is set to automatically corrects typing errors from a list of the most commonly misspelled words in its database.
10th Sep 2018
Access 2016 training video on how to use the Form Wizard to create a Form quickly for your database.
7th Nov 2017
Access 2016 training video on the basic introduction to Access 2016 as a relational database, or a database that breaks the data down into its smallest most meaning parts, or tables and then links those tables in a relationship to pull data as needed, and thereby making process more efficient for both user and computer. …
14th Sep 2017
Excel 2016 tutorial on the top 6 design flaws when it comes to creating a database in Excel so it's recognized by Excel as a database. For example, where Excel will be able to sort and keep all your records together in your database and not split, or break it up from a poorly designed database. …
26th Aug 2017