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

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

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.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.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

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"

Please I I can’t find the link where I can get the latest version of excel. Having the 2007 version on my system

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

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"