₦airaland Forum

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:
Please I I can’t find the link where I can get the latest version of excel. Having the 2007 version on my system

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