Techvangelists's Posts
Nairaland Forum › Techvangelists's Profile › Techvangelists's Posts
1 2 (of 2 pages)
In the hottest #technews for the week, @teslamotors electric #cybertruck, @google #cloudprint, @microsoft #windows7 notice reminder. Watch Top Tech Stories ( Nov 17 - 23rd) https://www.youtube.com/watch?v=vNguv_4vPQE |
#Facebook Pay is here, #Google to give slow websites a badge of shame, & more Watch Top Tech Stories (Nov 10 - 16th stories) https://www.youtube.com/watch?v=wfBScS0XDvQ |
Weekly Top Tech Stories (Nov 3rd - Nov 9th, 2019) - AliPay international, African developers & more https://www.youtube.com/watch?v=74YOoJId_O4 |
Weekly Top Tech Stories (Oct 27th - Nov 2nd, 2019) - China's 5G, Iphone 5 warnings & more https://www.youtube.com/watch?v=g9C7P3J8f5E |
Weekly Top Tech Stories (Oct 20th - Oct 26th, 2019) - Apple watch Salvation, Google Smell, S10 Fix https://www.youtube.com/watch?v=LvAdITpkiLo |
Microsoft Excel Foundation: 1.6 - Hiding columns/rows, Freezing columns/rows Topic: Hiding columns/rows, Freezing columns/rows This is the seventh video in the Microsoft Excel Foundation (Beginner) series & the sixth tutorial video in the series. https://www.youtube.com/watch?v=NqDrDtOltoI In this Microsoft Excel tutorial video, I talked about: - How to hide columns and rows - How to unhide columns and rows - How to freeze top row - How to freeze first column - How to freeze panes - How to unfreeze and more... Here is the spreadsheet for this class. Download here - http:///2me6vo1 or visit the video description on Youtube for the link The version used here is Microsoft Excel 2019. This tutorial is also applicable to Microsoft Excel versions 2016, 2013, 2011 on Mac Next Video in the series is about "Excel formulas and functions in Microsoft Excel" |
tapingil:You can download 2019 version here https://products.office.com/en-us/excel |
Weekly Top Tech Stories (Oct 13th - Oct 19th, 2019) - Apple 5G iPhone, Google Pixel 4 unlock & more https://www.youtube.com/watch?v=fNVk9XA-4i8 |
Weekly Top Tech Stories (Oct 6th - Oct 12th,2019) - Electric flying vehicles, Smart iMessages & more https://www.youtube.com/watch?v=pO5VY4gT_KE |
Weekly Top Tech Stories (Sep 29th - Oct 5th, 2019) - New Whatsapp Bug, Siri Integration, Surface Duo https://www.youtube.com/watch?v=o6g1vlivewk |
Weekly Top Tech Stories (Sep 22-28th, 2019) - China 500mp camera, Facebook hiding likes & More https://www.youtube.com/watch?v=WgaqQczbQbw |
Weekly Top Tech Stories (Sep 15-21st, 2019) - Google Assistant without Internet, iOS 13 & More https://www.youtube.com/watch?v=E3tesUwvMCo |
Weekly Top Tech Stories (Sep 8-14th, 2019) - Jack Ma & Alibaba, iPhone 11, Instagram flaw, & More https://www.youtube.com/watch?v=V-IKd4wi1kU |
Microsoft Excel Foundation: 1.5 - Conditional Formatting Topic: Conditional Formatting This is the sixth video in the Microsoft Excel Foundation (Beginner) series & the fifth tutorial video in the series. https://www.youtube.com/watch?v=XyBgOrYTCpY In this Microsoft Excel tutorial video, I talked about: - The various conditional formatting rules in Excel - How to mange the rules applied to cells - How to clear rules and more... The version used here is Microsoft Excel 2019. This tutorial is also applicable to Microsoft Excel versions 2016, 2013, 2011 on Mac Next Video in the series is about "Hiding & Freezing rows & columns in Microsoft Excel" |
Microsoft Excel Foundation: 1.4 - Number Formatting Topic: Number Formatting This is the fifth video in the Microsoft Excel Foundation (Beginner) series & the fourth tutorial video in the series. https://www.youtube.com/watch?v=tdG_t9MQC20 In this Microsoft Excel tutorial video, I talked about: - Number formats in Excel - Format as General - Format as Number - Format as Short date - Format as Long date - Format as Percentage - Format as Time - Format as Text - Format as a Custom Number Type and more... The version used here is Microsoft Excel 2019. This tutorial is also applicable to Microsoft Excel versions 2016, 2013, 2011 on Mac Next Video in the series is about Conditional formatting in Microsoft Excel |
Weekly Top Tech Stories (Sept 1st - 7th, 2019) - Apple Low cost phone, Amazon Hand scanning & more https://www.youtube.com/watch?v=7JP6oYFDK5U |
Weekly Top Tech Stories (Aug 25th-31st, 2019) - AI Robot teachers, Youtube for Kids, Wifi 6 https://www.youtube.com/watch?v=EVLbJvg6ooA |
Microsoft Excel Foundation: 1.3 - Cell Referencing, Autofill, Sort & Filter, Find & Replace Topic: Cell Referencing, Autofill, Sort & Filter, Find & Replace This is the fourth video in the Microsoft Excel Foundation (Beginner) series & the third tutorial video in the series. https://www.youtube.com/watch?v=IqnC_If7Hwo In this Microsoft Excel tutorial video, we talked about: - How to use Microsoft Auto fill for numbers across columns - How to use Microsoft Autofill for texts across columns - How to use Microsoft Autofill for multiple cells across rows and columns - How to reference cells using relative cell referencing in Microsoft Excel - How to reference cells using absolute cell referencing in Microsoft Excel - How to reference cells across different sheets in Microsoft Excel - Sorting alphabetically in Microsoft Excel - Sorting numerically (smallest to largest) in MS Excel - How to perform a custom sort - How to perform a basic filter in Excel - How to perform a find and replace The version used here is Microsoft Excel 2019. This tutorial is also applicable to Microsoft Excel versions 2016, 2013, 2011 on Mac Next Video in the series is about Number formatting in Microsoft Excel If you have any questions, comments and observations, please leave them in the comments section below. Do not forget to subscribe |
Microsoft Excel Foundation: 1.2 - Selection Techniques & Manipulation of Rows, Columns & Cells Topic: Selection Techniques & Manipulation of Rows, Columns & Cells in Microsoft Excel This is the third video in the Microsoft Excel Foundation (Beginner) series & the second tutorial video in the series. https://www.youtube.com/watch?v=tEhvKlUmL5E In this Microsoft Excel tutorial video, we looked at: - Selecting a Cell - Selecting a Range of Connected Cells - Selecting a Range of Non-Connected Cells - Selecting the Entire Worksheet - Selecting a Row - Selecting a Range of Connecting Rows - Selecting a Range of Non-Connected Rows - Selecting a Column - Selecting a Range of Connected Columns - Selecting a Range of Non-Connected Columns - Inserting Rows into a Worksheet - Inserting Columns into a Worksheet - Deleting Rows within a Worksheet - Deleting Columns within a Worksheet - Modifying Column Widths - Modifying Column Widths Using 'Drag and Drop' - Automatically Resizing the Column Width to Fit Contents - Modifying Row Heights - Copying a Cell or Range Contents within a Workbook - Deleting Cell Contents - Moving the Contents of a Cell or Range within a Workbook - Editing Cell Content - Undo and Redo and more... The version used here is Microsoft Excel 2019. This tutorial is also applicable to Microsoft Excel versions 2016, 2013, 2011 on Mac Next Video in the series - Cell Referencing, Autofill, Sort & Filter, Find & Replace |
Microsoft Excel Foundation: 1.1 - Introduction to MS Excel Workbook, Worksheets & Cells Topic: Introduction to MS Excel Workbook, Worksheets & Cells This is the second video in the Microsoft Excel Foundation (Beginner) series & the first tutorial video in the series. https://www.youtube.com/watch?v=zPgTkHafdPg In this Microsoft Excel tutorial video: - How to install Microsoft (MS) Excel on your PC or Mac - How to start MS Excel, - The MS Excel start screen, - What a Workbook, Worksheet is, - How to create new sheets and rename sheets in MS Excel, - The various sections of the MS Excel worksheet, - Basic Introduction to rows, columns and cells in MS Excel, - Entering data into cells, - Formatting the data in cells, - Simple summation in a cell, - How to Save and Save As a Workbook - How to open existing workbooks - Finding help in MS excel and more... The version used here is Microsoft Excel 2019. This tutorial is also applicable to Microsoft Excel versions 2016, 2013, and to 2011 on Mac Next Video in the series - Selection Techniques & Manipulation of Rows, Columns & Cells |
Welcome to the FREE course on Microsoft Excel Foundation (beginner) with Jimoh. Jimoh has been using Microsoft Excel spreadsheet for personal & commercial work since 2008. You can check out his excel thread on nairaland here - https://www.nairaland.com/4365880/professional-automated-ms-excel-spreadsheets & https://www.nairaland.com/1294608/automated-excel-sheets-schools-result & some other amazing unpublished spreadsheets yet like the soccer predictor, stock market predictor, dynamic wish fulfilment sheet,etc This is the first video (Basic introduction) in a series of Microsoft Excel tutorials. https://www.youtube.com/watch?v=ay2vsoOA_eo In this video: Microsoft Excel as a spreadsheet application, What a spreadsheet looks like, Latest Versions of Microsoft Excel for Windows & Mac, Advantages of learning & using Microsoft Excel, Specific uses, Kinds of jobs that require Microsoft Excel spreadsheet administration skills The Next Video is about "The Microsoft Excel Workbook, Worksheets & Cells" The Microsoft Excel Foundation tutorial series and all videos in it are free. We recommend you SUBSCRIBE & turn on Notifications on our channel in-order not to miss an update. You are already past beginner stage & looking for something more advanced? Send a m.ail to the e.mail on the footer |
Weekly Top Tech Stories (Aug 18-24th, 2019) - Russia Fedor Robot, Goodbye Sweet Androids, & More https://www.youtube.com/watch?v=Iak_SI882s8 |
Watch our edition of the week's Top Tech Stories brought to you by Jim (@JimohEOkoh) & Jerry (@PianistProgrammer) Aug 11-17th, 2019 - Huawei 6G Research, Amazon, Password Hacks https://www.youtube.com/watch?v=EIG4UEysP9k |
Watch our edition of the week's Top Tech Stories brought to you by Jim (@JimohEOkoh) & Jerry (@PianistProgrammer) August 4-10th 2019 Apple, Microsoft, Samsung, Huawei HarmonyOS https://www.youtube.com/watch?v=MmBEvi0W6E8 |
1 2 (of 2 pages)