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
Watch video Microsoft Office Training: 11 Hours of Free Training on Word, Excel, PowerPoint, Outlook, Access online without registration, duration hours minute second in high quality. This video was added by user Kaceli TechTraining 10 August 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 5,040 once and liked it 155 people.