The complete training on Microsoft Office: Word, Excel, PowerPoint, Outlook, and Microsoft Access. The tutorial is based off Office 2016.
➡️ WORKSHEETS / WORKING FILES:
- Word: https://kaceli.com/a/word2019/
- Access: https://kaceli.com/a/access2016files/
- Excel: https://kaceli.com/a/excel-2016-data-...
- Word, Excel, Access: https://kaceli.com/a/exercises-data-f...

TIME MARKERS:

EXCEL:
00:00 Getting Started
01:31: Components of Excel
02:16 Spreadsheet Concepts
05:19 Using Functions for Calculations
15:52 Conditional Formatting
19:04 Subtraction, Multiplication, Division
29:46 Data Sorting and Filtering
43:11 Charts
51:42 Cross References | Named References
57:52 Calculating Percentages
01:05 Financial Calculations
01:18:00 Conditional Functions IF
01:24:00 Forecasting
01:26:31 Pivot Tables
01:32:00 Data Gathering
01:35:10 Financial Charts
01:36:32 3D maps Data Visualization
01:38:29 Freeze Panes
01:40:23 Print Area
01:43:00 Data Validation
01:46:23 Linking Excel and Word | Importing Data

WORD :
01:56:35 Getting Started
01:59:00 Templates, New Documents
02:06:00 Formatting Documents
02:10:35 Styles
02:27:35 Format Painter Search and Replace
02:33:14 Graphics
02:42:00 Tables & Charts
02:50:00 Online Videos
02:54:43 Headers Footers
02:59:28 Merging Docs
03:02:53 Merging Docs
03:16:44 Footnotes
03:27:10 Works cited bibliography
03:28:17 Mail Merges

POWERPOINT
04:06:53 Overview
04:13:17 Creating Slides
04:24:51 Designer
04:44:15 Images and Multimedia, Charts
05:10:37 Advanced Features
05:27:52 Recoding Narrating
05:36:44 Timing
05:39:47 Notes
05:43:22 Presenting and Presenter View
05:51:11 Emailing, Sharing, Video Recording, Best Practices to Design PPTs
ACCESS
06:17:31 Overview
06:31:08 Tables and Components
06:50:12 Forms
06:56:38 Queries
07:18:12 Linking Tables
07:29:35 Forms and Subforms
07:42:17 Queries in-depth
08:19:14 Reports

OUTLOOK
08:37:17 Overview
08:52:18 All About Email and Multimedia
09:29:55 Rules
09:47:29 Calendar, Meetings, Tracking; Sharing; Delegate Access; Shared Calendars
10:06:42 Contacts and Lists
10:28:00 Tasks


➡️ Keep in touch:
For a listing of other tutorials and guides please check my website: http://kaceli.com
If you wan to take a course and get a certificate of completion visit: https://learn.kaceli.com
➡️The link to the YouTube Channel is:    / kacelitechtraining  .

You appreciate this work? Say thanks by clicking on the Thanks button below the video, give us a 'thumbs up', leave some comments, subscribe or simply spread the word via your social media.


Copyright notice: These videos may not be downloaded or distributed in any way without permission from Sali Kaceli. Contact me if you have such a need.

#msoffice #MicrosoftWord #KaceliTechTraining