Excel formulas and functions are very important to learn. In this 2020 video, I will show you how to use the vlookup function in Microsoft Excel. This vlookup tutorial for beginners will show you how to create and use the vlookup function. Improve your excel skills and quickly get the data you need from your table using the vlookup. Learning the vlookup function can save you a lot of time and is easy to use. Download sample data used in the video: https://drive.google.com/open?id=1T1foXuyw1NMUcxHd5QO2HzSbQYf8NgkP
Microsoft Excel is a powerful spreadsheet tool that is part of Microsoft Office. This is a detailed beginners tutorial, the below timestamps will help you navigate through the lessons that are covered. Looking for more? Let me know in the comments below what types of things you would like to learn in Microsoft Excel
This video tutorial will show you how to use Microsoft Word for beginners level 1. For level 2 click here: https://www.ganjing.com/video/1fjqljb0dtc352IGsIfapgfXg1fk1c Microsoft Word is a powerful word processing tool that is part of Microsoft Office. This is a detailed beginners tutorial, the below timestamps will help you navigate through the lessons that are covered. Looking for more? Let me know in the comments below what types of things you would like to learn in Microsoft Word 2016. 0:00 Start 0:50 Starting up 1:14 Recent documents and pinning documents 2:00 Templates 2:53 Layout - Tabs, ribbons and groups in Microsoft Word 5:33 Change Views 6:34 Using Tell Me 7:25 Insert, select and edit text 9:24 Using styles in Microsoft Word 10:31 Line spacing 11:25 Number and bullet list 12:28 Increase indent in lists 13:30 Spelling, grammar and thesaurus 14:58 Hyperlinking text 15:58 Add a Drop Cap in Microsoft Word 16:13 WordArt 17:39 Insert and format pictures 20:43 Insert shapes 21:23 Image order 22:20 Group images 23:15 Customizing margins and page layout 25:04 Page breaks, adding blank pages 25:49 Insert Header or Footer 26:40 Insert page numbers in Word 27:33 Printing 27:58 Save as PDF in Microsoft Word
This video tutorial will show you how to use Microsoft Excel for beginners. Microsoft Excel is a powerful spreadsheet tool that is part of Microsoft Office. This is a detailed beginners tutorial, the below timestamps will help you navigate through the lessons that are covered. Looking for more? Let me know in the comments below what types of things you would like to learn in Microsoft Excel. 0:00 Start 1:07 Starting up 1:27 Recent documents and pinning documents 1:54 Templates 2:34 Layout - Tabs, ribbons, and groups in Microsoft Excel 3:48 Rows, Columns, Cells and Ranges 5:49 Worksheets in Microsoft Excel 6:52 View and zooming 7:30 Inputting Data 10:56 Formatting Data 13:38 Wrapping Text 14:22 Insert Row/ Merge & Center cells 15:41 Currency formatting 16:20 Print view 17:02 Add cell borders and colors 18:18 Basic formulas in Microsoft Excel 21:17 Copy formula 23:45 Freeze Pane 24:52 Basic Microsoft Excel functions 28:59 “Tell Me” in Microsoft Excel 29:43 Inserting charts in Microsoft Excel

















