Becoming An Expert In Data Analysis With Excel

By: JJ Technologies

Introduction to Excel for Data Analysis:

Excel is a powerful and versatile spreadsheet software that goes beyond basic number-crunching and data management. It has become a fundamental tool for data analysis in various fields and industries due to its user-friendly interface and a wide array of features.

This course will make you an expert in data analysis using excel

#2,000.00

>>> Learn This Now View Cart

Use Text Editor here

Course Details

This course shall be treated under chapters such as;

1. Introduction. which will cover what excel can do in data analysis and how to achieve such

2. How to use various keys to navigate from row to row, column to column, sheet to sheet and workbook to workbook using menus and short cuts

3. Preparation of data for analysis. This is tagged data cleaning in this course.

4. Various data analysis

5. Formating of outputs and how to structure workbooks.

In all, you shall be listening to at least 40 (forty) short videos.

You are encouraged to open your excel sheet while listening to this course videos.

Course Content

Chapter 1: Introduction

Title	Type	Note	Lesson	Duration	Completed?
Lesson 1: Introduction	Video	View Note Intro to: Introduction Here, two sections will be intoduced. The cheat sheet section where all that will be covered in the course will be introduced chapter by chapter and the sample workbook section which tells you how to use the sample workbook attached to this course. Download the sample wookbook and use as a guide along with other course materials.	Enroll For Course First	1.11	A PHP Error was encountered Severity: Notice Message: Undefined index: user_id Filename: views/view_course_detail.php Line Number: 371 Backtrace: File: /home/rdivinev/learnthisnow.com.ng/application/views/view_course_detail.php Line: 371 Function: _error_handler File: /home/rdivinev/learnthisnow.com.ng/application/controllers/Course.php Line: 115 Function: view File: /home/rdivinev/learnthisnow.com.ng/index.php Line: 315 Function: require_once A PHP Error was encountered Severity: Notice Message: Undefined index: user_id Filename: views/view_course_detail.php Line Number: 374 Backtrace: File: /home/rdivinev/learnthisnow.com.ng/application/views/view_course_detail.php Line: 374 Function: _error_handler File: /home/rdivinev/learnthisnow.com.ng/application/controllers/Course.php Line: 115 Function: view File: /home/rdivinev/learnthisnow.com.ng/index.php Line: 315 Function: require_once ">

Chapter 2: How to Navigate

Title	Type	Note	Lesson	Duration	Completed?
Lesson 1: Shortcuts to quickly navigate a workbook	Video	View Note Intro to: Shortcuts to quickly navigate a workbook Letting out of bag the shortcuts to navigate aroung workbooks	Enroll For Course First	2.48	A PHP Error was encountered Severity: Notice Message: Undefined index: user_id Filename: views/view_course_detail.php Line Number: 371 Backtrace: File: /home/rdivinev/learnthisnow.com.ng/application/views/view_course_detail.php Line: 371 Function: _error_handler File: /home/rdivinev/learnthisnow.com.ng/application/controllers/Course.php Line: 115 Function: view File: /home/rdivinev/learnthisnow.com.ng/index.php Line: 315 Function: require_once A PHP Error was encountered Severity: Notice Message: Undefined index: user_id Filename: views/view_course_detail.php Line Number: 374 Backtrace: File: /home/rdivinev/learnthisnow.com.ng/application/views/view_course_detail.php Line: 374 Function: _error_handler File: /home/rdivinev/learnthisnow.com.ng/application/controllers/Course.php Line: 115 Function: view File: /home/rdivinev/learnthisnow.com.ng/index.php Line: 315 Function: require_once ">
Lesson 2: Insert or delete rows, columns, and sheets	Video	View Note Intro to: Insert or delete rows, columns, and sheets Learning how to Insert or delete rows, columns, and sheets	Enroll For Course First	6.02	A PHP Error was encountered Severity: Notice Message: Undefined index: user_id Filename: views/view_course_detail.php Line Number: 371 Backtrace: File: /home/rdivinev/learnthisnow.com.ng/application/views/view_course_detail.php Line: 371 Function: _error_handler File: /home/rdivinev/learnthisnow.com.ng/application/controllers/Course.php Line: 115 Function: view File: /home/rdivinev/learnthisnow.com.ng/index.php Line: 315 Function: require_once A PHP Error was encountered Severity: Notice Message: Undefined index: user_id Filename: views/view_course_detail.php Line Number: 374 Backtrace: File: /home/rdivinev/learnthisnow.com.ng/application/views/view_course_detail.php Line: 374 Function: _error_handler File: /home/rdivinev/learnthisnow.com.ng/application/controllers/Course.php Line: 115 Function: view File: /home/rdivinev/learnthisnow.com.ng/index.php Line: 315 Function: require_once ">
Lesson 3: How to Move and copy sheets	Video	View Note Intro to: How to Move and copy sheets Moving and copying sheets in a workbook	Enroll For Course First	2.30	A PHP Error was encountered Severity: Notice Message: Undefined index: user_id Filename: views/view_course_detail.php Line Number: 371 Backtrace: File: /home/rdivinev/learnthisnow.com.ng/application/views/view_course_detail.php Line: 371 Function: _error_handler File: /home/rdivinev/learnthisnow.com.ng/application/controllers/Course.php Line: 115 Function: view File: /home/rdivinev/learnthisnow.com.ng/index.php Line: 315 Function: require_once A PHP Error was encountered Severity: Notice Message: Undefined index: user_id Filename: views/view_course_detail.php Line Number: 374 Backtrace: File: /home/rdivinev/learnthisnow.com.ng/application/views/view_course_detail.php Line: 374 Function: _error_handler File: /home/rdivinev/learnthisnow.com.ng/application/controllers/Course.php Line: 115 Function: view File: /home/rdivinev/learnthisnow.com.ng/index.php Line: 315 Function: require_once ">
Lesson 4: How to Split screen and freeze pane	Video	View Note Intro to: How to Split screen and freeze pane Learning how to split screen and freeze pane	Enroll For Course First	4.26	A PHP Error was encountered Severity: Notice Message: Undefined index: user_id Filename: views/view_course_detail.php Line Number: 371 Backtrace: File: /home/rdivinev/learnthisnow.com.ng/application/views/view_course_detail.php Line: 371 Function: _error_handler File: /home/rdivinev/learnthisnow.com.ng/application/controllers/Course.php Line: 115 Function: view File: /home/rdivinev/learnthisnow.com.ng/index.php Line: 315 Function: require_once A PHP Error was encountered Severity: Notice Message: Undefined index: user_id Filename: views/view_course_detail.php Line Number: 374 Backtrace: File: /home/rdivinev/learnthisnow.com.ng/application/views/view_course_detail.php Line: 374 Function: _error_handler File: /home/rdivinev/learnthisnow.com.ng/application/controllers/Course.php Line: 115 Function: view File: /home/rdivinev/learnthisnow.com.ng/index.php Line: 315 Function: require_once ">
Lesson 5: How to open new window of the same Excel file	Video	View Note Intro to: How to open new window of the same Excel file This lets you now how to view data in a quick way	Enroll For Course First	2.10	A PHP Error was encountered Severity: Notice Message: Undefined index: user_id Filename: views/view_course_detail.php Line Number: 371 Backtrace: File: /home/rdivinev/learnthisnow.com.ng/application/views/view_course_detail.php Line: 371 Function: _error_handler File: /home/rdivinev/learnthisnow.com.ng/application/controllers/Course.php Line: 115 Function: view File: /home/rdivinev/learnthisnow.com.ng/index.php Line: 315 Function: require_once A PHP Error was encountered Severity: Notice Message: Undefined index: user_id Filename: views/view_course_detail.php Line Number: 374 Backtrace: File: /home/rdivinev/learnthisnow.com.ng/application/views/view_course_detail.php Line: 374 Function: _error_handler File: /home/rdivinev/learnthisnow.com.ng/application/controllers/Course.php Line: 115 Function: view File: /home/rdivinev/learnthisnow.com.ng/index.php Line: 315 Function: require_once ">
Lesson 6: Entering and exit cell using F2	Video	View Note Intro to: Entering and exit cell using F2 Use of F2 in excel	Enroll For Course First	0.50	A PHP Error was encountered Severity: Notice Message: Undefined index: user_id Filename: views/view_course_detail.php Line Number: 371 Backtrace: File: /home/rdivinev/learnthisnow.com.ng/application/views/view_course_detail.php Line: 371 Function: _error_handler File: /home/rdivinev/learnthisnow.com.ng/application/controllers/Course.php Line: 115 Function: view File: /home/rdivinev/learnthisnow.com.ng/index.php Line: 315 Function: require_once A PHP Error was encountered Severity: Notice Message: Undefined index: user_id Filename: views/view_course_detail.php Line Number: 374 Backtrace: File: /home/rdivinev/learnthisnow.com.ng/application/views/view_course_detail.php Line: 374 Function: _error_handler File: /home/rdivinev/learnthisnow.com.ng/application/controllers/Course.php Line: 115 Function: view File: /home/rdivinev/learnthisnow.com.ng/index.php Line: 315 Function: require_once ">

Chapter 3: How to clean data

Title	Type	Note	Lesson	Duration	Completed?
Lesson 1: How to Insert filters, multiple sort	Video	View Note Intro to: How to Insert filters, multiple sort Inserting filters and multiple sorting fof data	Enroll For Course First	6.11	A PHP Error was encountered Severity: Notice Message: Undefined index: user_id Filename: views/view_course_detail.php Line Number: 371 Backtrace: File: /home/rdivinev/learnthisnow.com.ng/application/views/view_course_detail.php Line: 371 Function: _error_handler File: /home/rdivinev/learnthisnow.com.ng/application/controllers/Course.php Line: 115 Function: view File: /home/rdivinev/learnthisnow.com.ng/index.php Line: 315 Function: require_once A PHP Error was encountered Severity: Notice Message: Undefined index: user_id Filename: views/view_course_detail.php Line Number: 374 Backtrace: File: /home/rdivinev/learnthisnow.com.ng/application/views/view_course_detail.php Line: 374 Function: _error_handler File: /home/rdivinev/learnthisnow.com.ng/application/controllers/Course.php Line: 115 Function: view File: /home/rdivinev/learnthisnow.com.ng/index.php Line: 315 Function: require_once ">
Lesson 2: Create tables	Video	View Note Intro to: Create tables Create tables to sort data	Enroll For Course First	2.50	A PHP Error was encountered Severity: Notice Message: Undefined index: user_id Filename: views/view_course_detail.php Line Number: 371 Backtrace: File: /home/rdivinev/learnthisnow.com.ng/application/views/view_course_detail.php Line: 371 Function: _error_handler File: /home/rdivinev/learnthisnow.com.ng/application/controllers/Course.php Line: 115 Function: view File: /home/rdivinev/learnthisnow.com.ng/index.php Line: 315 Function: require_once A PHP Error was encountered Severity: Notice Message: Undefined index: user_id Filename: views/view_course_detail.php Line Number: 374 Backtrace: File: /home/rdivinev/learnthisnow.com.ng/application/views/view_course_detail.php Line: 374 Function: _error_handler File: /home/rdivinev/learnthisnow.com.ng/application/controllers/Course.php Line: 115 Function: view File: /home/rdivinev/learnthisnow.com.ng/index.php Line: 315 Function: require_once ">
Lesson 3: Find and replace data	Video	View Note Intro to: Find and replace data Find and replace data	Enroll For Course First	1.54	A PHP Error was encountered Severity: Notice Message: Undefined index: user_id Filename: views/view_course_detail.php Line Number: 371 Backtrace: File: /home/rdivinev/learnthisnow.com.ng/application/views/view_course_detail.php Line: 371 Function: _error_handler File: /home/rdivinev/learnthisnow.com.ng/application/controllers/Course.php Line: 115 Function: view File: /home/rdivinev/learnthisnow.com.ng/index.php Line: 315 Function: require_once A PHP Error was encountered Severity: Notice Message: Undefined index: user_id Filename: views/view_course_detail.php Line Number: 374 Backtrace: File: /home/rdivinev/learnthisnow.com.ng/application/views/view_course_detail.php Line: 374 Function: _error_handler File: /home/rdivinev/learnthisnow.com.ng/application/controllers/Course.php Line: 115 Function: view File: /home/rdivinev/learnthisnow.com.ng/index.php Line: 315 Function: require_once ">
Lesson 4: IFERROR for calculations	Video	View Note Intro to: IFERROR for calculations Learning IFERROR condition for calculations	Enroll For Course First	2.13	A PHP Error was encountered Severity: Notice Message: Undefined index: user_id Filename: views/view_course_detail.php Line Number: 371 Backtrace: File: /home/rdivinev/learnthisnow.com.ng/application/views/view_course_detail.php Line: 371 Function: _error_handler File: /home/rdivinev/learnthisnow.com.ng/application/controllers/Course.php Line: 115 Function: view File: /home/rdivinev/learnthisnow.com.ng/index.php Line: 315 Function: require_once A PHP Error was encountered Severity: Notice Message: Undefined index: user_id Filename: views/view_course_detail.php Line Number: 374 Backtrace: File: /home/rdivinev/learnthisnow.com.ng/application/views/view_course_detail.php Line: 374 Function: _error_handler File: /home/rdivinev/learnthisnow.com.ng/application/controllers/Course.php Line: 115 Function: view File: /home/rdivinev/learnthisnow.com.ng/index.php Line: 315 Function: require_once ">
Lesson 5: IFS for creating buckets in a new column	Video	View Note Intro to: IFS for creating buckets in a new column IFS condition for creating buckets in a new column	Enroll For Course First	4.04	A PHP Error was encountered Severity: Notice Message: Undefined index: user_id Filename: views/view_course_detail.php Line Number: 371 Backtrace: File: /home/rdivinev/learnthisnow.com.ng/application/views/view_course_detail.php Line: 371 Function: _error_handler File: /home/rdivinev/learnthisnow.com.ng/application/controllers/Course.php Line: 115 Function: view File: /home/rdivinev/learnthisnow.com.ng/index.php Line: 315 Function: require_once A PHP Error was encountered Severity: Notice Message: Undefined index: user_id Filename: views/view_course_detail.php Line Number: 374 Backtrace: File: /home/rdivinev/learnthisnow.com.ng/application/views/view_course_detail.php Line: 374 Function: _error_handler File: /home/rdivinev/learnthisnow.com.ng/application/controllers/Course.php Line: 115 Function: view File: /home/rdivinev/learnthisnow.com.ng/index.php Line: 315 Function: require_once ">
Lesson 6: LEFT RIGHT LEN SEARCH for manipulating text	Video	View Note Intro to: LEFT RIGHT LEN SEARCH for manipulating text LEFT RIGHT LEN SEARCH for manipulating text	Enroll For Course First	3.21	A PHP Error was encountered Severity: Notice Message: Undefined index: user_id Filename: views/view_course_detail.php Line Number: 371 Backtrace: File: /home/rdivinev/learnthisnow.com.ng/application/views/view_course_detail.php Line: 371 Function: _error_handler File: /home/rdivinev/learnthisnow.com.ng/application/controllers/Course.php Line: 115 Function: view File: /home/rdivinev/learnthisnow.com.ng/index.php Line: 315 Function: require_once A PHP Error was encountered Severity: Notice Message: Undefined index: user_id Filename: views/view_course_detail.php Line Number: 374 Backtrace: File: /home/rdivinev/learnthisnow.com.ng/application/views/view_course_detail.php Line: 374 Function: _error_handler File: /home/rdivinev/learnthisnow.com.ng/application/controllers/Course.php Line: 115 Function: view File: /home/rdivinev/learnthisnow.com.ng/index.php Line: 315 Function: require_once ">
Lesson 7: LEFT RIGHT LEN SEARCH for manipulating text (advanced)	Video	View Note Intro to: LEFT RIGHT LEN SEARCH for manipulating text (advanced) LEFT RIGHT LEN SEARCH for manipulating text (advanced)	Enroll For Course First	1.58	A PHP Error was encountered Severity: Notice Message: Undefined index: user_id Filename: views/view_course_detail.php Line Number: 371 Backtrace: File: /home/rdivinev/learnthisnow.com.ng/application/views/view_course_detail.php Line: 371 Function: _error_handler File: /home/rdivinev/learnthisnow.com.ng/application/controllers/Course.php Line: 115 Function: view File: /home/rdivinev/learnthisnow.com.ng/index.php Line: 315 Function: require_once A PHP Error was encountered Severity: Notice Message: Undefined index: user_id Filename: views/view_course_detail.php Line Number: 374 Backtrace: File: /home/rdivinev/learnthisnow.com.ng/application/views/view_course_detail.php Line: 374 Function: _error_handler File: /home/rdivinev/learnthisnow.com.ng/application/controllers/Course.php Line: 115 Function: view File: /home/rdivinev/learnthisnow.com.ng/index.php Line: 315 Function: require_once ">
Lesson 8: Cleaning dates	Video	View Note Intro to: Cleaning dates Cleaning dates	Enroll For Course First	1.10	A PHP Error was encountered Severity: Notice Message: Undefined index: user_id Filename: views/view_course_detail.php Line Number: 371 Backtrace: File: /home/rdivinev/learnthisnow.com.ng/application/views/view_course_detail.php Line: 371 Function: _error_handler File: /home/rdivinev/learnthisnow.com.ng/application/controllers/Course.php Line: 115 Function: view File: /home/rdivinev/learnthisnow.com.ng/index.php Line: 315 Function: require_once A PHP Error was encountered Severity: Notice Message: Undefined index: user_id Filename: views/view_course_detail.php Line Number: 374 Backtrace: File: /home/rdivinev/learnthisnow.com.ng/application/views/view_course_detail.php Line: 374 Function: _error_handler File: /home/rdivinev/learnthisnow.com.ng/application/controllers/Course.php Line: 115 Function: view File: /home/rdivinev/learnthisnow.com.ng/index.php Line: 315 Function: require_once ">
Lesson 9: Using Excel's Smart Autofill feature	Video	View Note Intro to: Using Excel's Smart Autofill feature Using Excel's Smart Autofill feature	Enroll For Course First	2.15	A PHP Error was encountered Severity: Notice Message: Undefined index: user_id Filename: views/view_course_detail.php Line Number: 371 Backtrace: File: /home/rdivinev/learnthisnow.com.ng/application/views/view_course_detail.php Line: 371 Function: _error_handler File: /home/rdivinev/learnthisnow.com.ng/application/controllers/Course.php Line: 115 Function: view File: /home/rdivinev/learnthisnow.com.ng/index.php Line: 315 Function: require_once A PHP Error was encountered Severity: Notice Message: Undefined index: user_id Filename: views/view_course_detail.php Line Number: 374 Backtrace: File: /home/rdivinev/learnthisnow.com.ng/application/views/view_course_detail.php Line: 374 Function: _error_handler File: /home/rdivinev/learnthisnow.com.ng/application/controllers/Course.php Line: 115 Function: view File: /home/rdivinev/learnthisnow.com.ng/index.php Line: 315 Function: require_once ">

Chapter 4: Various Analysis

Title	Type	Note	Lesson	Duration	Completed?
Lesson 1: Calculating AVERAGE, MAX, MIN, MEDIAN	Video	View Note Intro to: Calculating AVERAGE, MAX, MIN, MEDIAN CALCULATING AVERAGE, MAX, MIN, MEDIAN	Enroll For Course First	1.10	A PHP Error was encountered Severity: Notice Message: Undefined index: user_id Filename: views/view_course_detail.php Line Number: 371 Backtrace: File: /home/rdivinev/learnthisnow.com.ng/application/views/view_course_detail.php Line: 371 Function: _error_handler File: /home/rdivinev/learnthisnow.com.ng/application/controllers/Course.php Line: 115 Function: view File: /home/rdivinev/learnthisnow.com.ng/index.php Line: 315 Function: require_once A PHP Error was encountered Severity: Notice Message: Undefined index: user_id Filename: views/view_course_detail.php Line Number: 374 Backtrace: File: /home/rdivinev/learnthisnow.com.ng/application/views/view_course_detail.php Line: 374 Function: _error_handler File: /home/rdivinev/learnthisnow.com.ng/application/controllers/Course.php Line: 115 Function: view File: /home/rdivinev/learnthisnow.com.ng/index.php Line: 315 Function: require_once ">
Lesson 2: CALCULATING PERCENTILES	Video	View Note Intro to: CALCULATING PERCENTILES CALCULATING PERCENTILES	Enroll For Course First	1.42	A PHP Error was encountered Severity: Notice Message: Undefined index: user_id Filename: views/view_course_detail.php Line Number: 371 Backtrace: File: /home/rdivinev/learnthisnow.com.ng/application/views/view_course_detail.php Line: 371 Function: _error_handler File: /home/rdivinev/learnthisnow.com.ng/application/controllers/Course.php Line: 115 Function: view File: /home/rdivinev/learnthisnow.com.ng/index.php Line: 315 Function: require_once A PHP Error was encountered Severity: Notice Message: Undefined index: user_id Filename: views/view_course_detail.php Line Number: 374 Backtrace: File: /home/rdivinev/learnthisnow.com.ng/application/views/view_course_detail.php Line: 374 Function: _error_handler File: /home/rdivinev/learnthisnow.com.ng/application/controllers/Course.php Line: 115 Function: view File: /home/rdivinev/learnthisnow.com.ng/index.php Line: 315 Function: require_once ">
Lesson 3: COUNT, COUNTA, COUNTIFS	Video	View Note Intro to: COUNT, COUNTA, COUNTIFS COUNT, COUNTA, COUNTIFS	Enroll For Course First	5.25	A PHP Error was encountered Severity: Notice Message: Undefined index: user_id Filename: views/view_course_detail.php Line Number: 371 Backtrace: File: /home/rdivinev/learnthisnow.com.ng/application/views/view_course_detail.php Line: 371 Function: _error_handler File: /home/rdivinev/learnthisnow.com.ng/application/controllers/Course.php Line: 115 Function: view File: /home/rdivinev/learnthisnow.com.ng/index.php Line: 315 Function: require_once A PHP Error was encountered Severity: Notice Message: Undefined index: user_id Filename: views/view_course_detail.php Line Number: 374 Backtrace: File: /home/rdivinev/learnthisnow.com.ng/application/views/view_course_detail.php Line: 374 Function: _error_handler File: /home/rdivinev/learnthisnow.com.ng/application/controllers/Course.php Line: 115 Function: view File: /home/rdivinev/learnthisnow.com.ng/index.php Line: 315 Function: require_once ">
Lesson 4: SUMIFS, AVERAGEIFS	Video	View Note Intro to: SUMIFS, AVERAGEIFS Conditions SUM and AVERAGE	Enroll For Course First	1.50	A PHP Error was encountered Severity: Notice Message: Undefined index: user_id Filename: views/view_course_detail.php Line Number: 371 Backtrace: File: /home/rdivinev/learnthisnow.com.ng/application/views/view_course_detail.php Line: 371 Function: _error_handler File: /home/rdivinev/learnthisnow.com.ng/application/controllers/Course.php Line: 115 Function: view File: /home/rdivinev/learnthisnow.com.ng/index.php Line: 315 Function: require_once A PHP Error was encountered Severity: Notice Message: Undefined index: user_id Filename: views/view_course_detail.php Line Number: 374 Backtrace: File: /home/rdivinev/learnthisnow.com.ng/application/views/view_course_detail.php Line: 374 Function: _error_handler File: /home/rdivinev/learnthisnow.com.ng/application/controllers/Course.php Line: 115 Function: view File: /home/rdivinev/learnthisnow.com.ng/index.php Line: 315 Function: require_once ">
Lesson 5: Calculating SUMPRODUCT	Video	View Note Intro to: Calculating SUMPRODUCT CALCULATING SUMPRODUCT	Enroll For Course First	1.21	A PHP Error was encountered Severity: Notice Message: Undefined index: user_id Filename: views/view_course_detail.php Line Number: 371 Backtrace: File: /home/rdivinev/learnthisnow.com.ng/application/views/view_course_detail.php Line: 371 Function: _error_handler File: /home/rdivinev/learnthisnow.com.ng/application/controllers/Course.php Line: 115 Function: view File: /home/rdivinev/learnthisnow.com.ng/index.php Line: 315 Function: require_once A PHP Error was encountered Severity: Notice Message: Undefined index: user_id Filename: views/view_course_detail.php Line Number: 374 Backtrace: File: /home/rdivinev/learnthisnow.com.ng/application/views/view_course_detail.php Line: 374 Function: _error_handler File: /home/rdivinev/learnthisnow.com.ng/application/controllers/Course.php Line: 115 Function: view File: /home/rdivinev/learnthisnow.com.ng/index.php Line: 315 Function: require_once ">
Lesson 6: Pivot tables	Video	View Note Intro to: Pivot tables Pivot tables	Enroll For Course First	6.27	A PHP Error was encountered Severity: Notice Message: Undefined index: user_id Filename: views/view_course_detail.php Line Number: 371 Backtrace: File: /home/rdivinev/learnthisnow.com.ng/application/views/view_course_detail.php Line: 371 Function: _error_handler File: /home/rdivinev/learnthisnow.com.ng/application/controllers/Course.php Line: 115 Function: view File: /home/rdivinev/learnthisnow.com.ng/index.php Line: 315 Function: require_once A PHP Error was encountered Severity: Notice Message: Undefined index: user_id Filename: views/view_course_detail.php Line Number: 374 Backtrace: File: /home/rdivinev/learnthisnow.com.ng/application/views/view_course_detail.php Line: 374 Function: _error_handler File: /home/rdivinev/learnthisnow.com.ng/application/controllers/Course.php Line: 115 Function: view File: /home/rdivinev/learnthisnow.com.ng/index.php Line: 315 Function: require_once ">
Lesson 7: Pivot tables vs. advanced COUNTIFS	Video	View Note Intro to: Pivot tables vs. advanced COUNTIFS Pivot tables vs. advanced COUNTIFS	Enroll For Course First	5.12	A PHP Error was encountered Severity: Notice Message: Undefined index: user_id Filename: views/view_course_detail.php Line Number: 371 Backtrace: File: /home/rdivinev/learnthisnow.com.ng/application/views/view_course_detail.php Line: 371 Function: _error_handler File: /home/rdivinev/learnthisnow.com.ng/application/controllers/Course.php Line: 115 Function: view File: /home/rdivinev/learnthisnow.com.ng/index.php Line: 315 Function: require_once A PHP Error was encountered Severity: Notice Message: Undefined index: user_id Filename: views/view_course_detail.php Line Number: 374 Backtrace: File: /home/rdivinev/learnthisnow.com.ng/application/views/view_course_detail.php Line: 374 Function: _error_handler File: /home/rdivinev/learnthisnow.com.ng/application/controllers/Course.php Line: 115 Function: view File: /home/rdivinev/learnthisnow.com.ng/index.php Line: 315 Function: require_once ">
Lesson 8: Index match	Video	View Note Intro to: Index match Index match	Enroll For Course First	8.10	A PHP Error was encountered Severity: Notice Message: Undefined index: user_id Filename: views/view_course_detail.php Line Number: 371 Backtrace: File: /home/rdivinev/learnthisnow.com.ng/application/views/view_course_detail.php Line: 371 Function: _error_handler File: /home/rdivinev/learnthisnow.com.ng/application/controllers/Course.php Line: 115 Function: view File: /home/rdivinev/learnthisnow.com.ng/index.php Line: 315 Function: require_once A PHP Error was encountered Severity: Notice Message: Undefined index: user_id Filename: views/view_course_detail.php Line Number: 374 Backtrace: File: /home/rdivinev/learnthisnow.com.ng/application/views/view_course_detail.php Line: 374 Function: _error_handler File: /home/rdivinev/learnthisnow.com.ng/application/controllers/Course.php Line: 115 Function: view File: /home/rdivinev/learnthisnow.com.ng/index.php Line: 315 Function: require_once ">

Chapter 5: How to format output

Title	Type	Note	Lesson	Duration	Completed?
Lesson 1: Format numbers quickly, set decimal points	Video	View Note Intro to: Format numbers quickly, set decimal points Format numbers quickly, set decimal points	Enroll For Course First	2.48	A PHP Error was encountered Severity: Notice Message: Undefined index: user_id Filename: views/view_course_detail.php Line Number: 371 Backtrace: File: /home/rdivinev/learnthisnow.com.ng/application/views/view_course_detail.php Line: 371 Function: _error_handler File: /home/rdivinev/learnthisnow.com.ng/application/controllers/Course.php Line: 115 Function: view File: /home/rdivinev/learnthisnow.com.ng/index.php Line: 315 Function: require_once A PHP Error was encountered Severity: Notice Message: Undefined index: user_id Filename: views/view_course_detail.php Line Number: 374 Backtrace: File: /home/rdivinev/learnthisnow.com.ng/application/views/view_course_detail.php Line: 374 Function: _error_handler File: /home/rdivinev/learnthisnow.com.ng/application/controllers/Course.php Line: 115 Function: view File: /home/rdivinev/learnthisnow.com.ng/index.php Line: 315 Function: require_once ">
Lesson 2: Using detailed formatting options in Ctr + 1	Video	View Note Intro to: Using detailed formatting options in Ctr + 1 Using detailed formatting options in Ctr + 1	Enroll For Course First	1.23	A PHP Error was encountered Severity: Notice Message: Undefined index: user_id Filename: views/view_course_detail.php Line Number: 371 Backtrace: File: /home/rdivinev/learnthisnow.com.ng/application/views/view_course_detail.php Line: 371 Function: _error_handler File: /home/rdivinev/learnthisnow.com.ng/application/controllers/Course.php Line: 115 Function: view File: /home/rdivinev/learnthisnow.com.ng/index.php Line: 315 Function: require_once A PHP Error was encountered Severity: Notice Message: Undefined index: user_id Filename: views/view_course_detail.php Line Number: 374 Backtrace: File: /home/rdivinev/learnthisnow.com.ng/application/views/view_course_detail.php Line: 374 Function: _error_handler File: /home/rdivinev/learnthisnow.com.ng/application/controllers/Course.php Line: 115 Function: view File: /home/rdivinev/learnthisnow.com.ng/index.php Line: 315 Function: require_once ">
Lesson 3: Conditional formatting	Video	View Note Intro to: Conditional formatting Conditional formatting	Enroll For Course First	2.28	A PHP Error was encountered Severity: Notice Message: Undefined index: user_id Filename: views/view_course_detail.php Line Number: 371 Backtrace: File: /home/rdivinev/learnthisnow.com.ng/application/views/view_course_detail.php Line: 371 Function: _error_handler File: /home/rdivinev/learnthisnow.com.ng/application/controllers/Course.php Line: 115 Function: view File: /home/rdivinev/learnthisnow.com.ng/index.php Line: 315 Function: require_once A PHP Error was encountered Severity: Notice Message: Undefined index: user_id Filename: views/view_course_detail.php Line Number: 374 Backtrace: File: /home/rdivinev/learnthisnow.com.ng/application/views/view_course_detail.php Line: 374 Function: _error_handler File: /home/rdivinev/learnthisnow.com.ng/application/controllers/Course.php Line: 115 Function: view File: /home/rdivinev/learnthisnow.com.ng/index.php Line: 315 Function: require_once ">
Lesson 4: Align text, font colo	Video	View Note Intro to: Align text, font colo Align text, font colo	Enroll For Course First	1.35	A PHP Error was encountered Severity: Notice Message: Undefined index: user_id Filename: views/view_course_detail.php Line Number: 371 Backtrace: File: /home/rdivinev/learnthisnow.com.ng/application/views/view_course_detail.php Line: 371 Function: _error_handler File: /home/rdivinev/learnthisnow.com.ng/application/controllers/Course.php Line: 115 Function: view File: /home/rdivinev/learnthisnow.com.ng/index.php Line: 315 Function: require_once A PHP Error was encountered Severity: Notice Message: Undefined index: user_id Filename: views/view_course_detail.php Line Number: 374 Backtrace: File: /home/rdivinev/learnthisnow.com.ng/application/views/view_course_detail.php Line: 374 Function: _error_handler File: /home/rdivinev/learnthisnow.com.ng/application/controllers/Course.php Line: 115 Function: view File: /home/rdivinev/learnthisnow.com.ng/index.php Line: 315 Function: require_once ">
Lesson 5: Adding cell borders	Video	View Note Intro to: Adding cell borders Adding cell borders	Enroll For Course First	1.55	A PHP Error was encountered Severity: Notice Message: Undefined index: user_id Filename: views/view_course_detail.php Line Number: 371 Backtrace: File: /home/rdivinev/learnthisnow.com.ng/application/views/view_course_detail.php Line: 371 Function: _error_handler File: /home/rdivinev/learnthisnow.com.ng/application/controllers/Course.php Line: 115 Function: view File: /home/rdivinev/learnthisnow.com.ng/index.php Line: 315 Function: require_once A PHP Error was encountered Severity: Notice Message: Undefined index: user_id Filename: views/view_course_detail.php Line Number: 374 Backtrace: File: /home/rdivinev/learnthisnow.com.ng/application/views/view_course_detail.php Line: 374 Function: _error_handler File: /home/rdivinev/learnthisnow.com.ng/application/controllers/Course.php Line: 115 Function: view File: /home/rdivinev/learnthisnow.com.ng/index.php Line: 315 Function: require_once ">
Lesson 6: Cell highlights	Video	View Note Intro to: Cell highlights Cell highlights	Enroll For Course First	0.38	A PHP Error was encountered Severity: Notice Message: Undefined index: user_id Filename: views/view_course_detail.php Line Number: 371 Backtrace: File: /home/rdivinev/learnthisnow.com.ng/application/views/view_course_detail.php Line: 371 Function: _error_handler File: /home/rdivinev/learnthisnow.com.ng/application/controllers/Course.php Line: 115 Function: view File: /home/rdivinev/learnthisnow.com.ng/index.php Line: 315 Function: require_once A PHP Error was encountered Severity: Notice Message: Undefined index: user_id Filename: views/view_course_detail.php Line Number: 374 Backtrace: File: /home/rdivinev/learnthisnow.com.ng/application/views/view_course_detail.php Line: 374 Function: _error_handler File: /home/rdivinev/learnthisnow.com.ng/application/controllers/Course.php Line: 115 Function: view File: /home/rdivinev/learnthisnow.com.ng/index.php Line: 315 Function: require_once ">
Lesson 7: Use Paste Special to copy formats from another cell	Video	View Note Intro to: Use Paste Special to copy formats from another cell Use Paste Special to copy formats from another cell	Enroll For Course First	2.45	A PHP Error was encountered Severity: Notice Message: Undefined index: user_id Filename: views/view_course_detail.php Line Number: 371 Backtrace: File: /home/rdivinev/learnthisnow.com.ng/application/views/view_course_detail.php Line: 371 Function: _error_handler File: /home/rdivinev/learnthisnow.com.ng/application/controllers/Course.php Line: 115 Function: view File: /home/rdivinev/learnthisnow.com.ng/index.php Line: 315 Function: require_once A PHP Error was encountered Severity: Notice Message: Undefined index: user_id Filename: views/view_course_detail.php Line Number: 374 Backtrace: File: /home/rdivinev/learnthisnow.com.ng/application/views/view_course_detail.php Line: 374 Function: _error_handler File: /home/rdivinev/learnthisnow.com.ng/application/controllers/Course.php Line: 115 Function: view File: /home/rdivinev/learnthisnow.com.ng/index.php Line: 315 Function: require_once ">
Lesson 8: Clear formatting from cells	Video	View Note Intro to: Clear formatting from cells Clear formatting from cells	Enroll For Course First	1.50	A PHP Error was encountered Severity: Notice Message: Undefined index: user_id Filename: views/view_course_detail.php Line Number: 371 Backtrace: File: /home/rdivinev/learnthisnow.com.ng/application/views/view_course_detail.php Line: 371 Function: _error_handler File: /home/rdivinev/learnthisnow.com.ng/application/controllers/Course.php Line: 115 Function: view File: /home/rdivinev/learnthisnow.com.ng/index.php Line: 315 Function: require_once A PHP Error was encountered Severity: Notice Message: Undefined index: user_id Filename: views/view_course_detail.php Line Number: 374 Backtrace: File: /home/rdivinev/learnthisnow.com.ng/application/views/view_course_detail.php Line: 374 Function: _error_handler File: /home/rdivinev/learnthisnow.com.ng/application/controllers/Course.php Line: 115 Function: view File: /home/rdivinev/learnthisnow.com.ng/index.php Line: 315 Function: require_once ">
Lesson 9: Insert and delete comments from cells	Video	View Note Intro to: Insert and delete comments from cells Insert and delete comments from cells	Enroll For Course First	2.10	A PHP Error was encountered Severity: Notice Message: Undefined index: user_id Filename: views/view_course_detail.php Line Number: 371 Backtrace: File: /home/rdivinev/learnthisnow.com.ng/application/views/view_course_detail.php Line: 371 Function: _error_handler File: /home/rdivinev/learnthisnow.com.ng/application/controllers/Course.php Line: 115 Function: view File: /home/rdivinev/learnthisnow.com.ng/index.php Line: 315 Function: require_once A PHP Error was encountered Severity: Notice Message: Undefined index: user_id Filename: views/view_course_detail.php Line Number: 374 Backtrace: File: /home/rdivinev/learnthisnow.com.ng/application/views/view_course_detail.php Line: 374 Function: _error_handler File: /home/rdivinev/learnthisnow.com.ng/application/controllers/Course.php Line: 115 Function: view File: /home/rdivinev/learnthisnow.com.ng/index.php Line: 315 Function: require_once ">
Lesson 10: Set row width and column height, Use autofit	Video	View Note Intro to: Set row width and column height, Use autofit Set row width and column height, Use autofit	Enroll For Course First	3.36	A PHP Error was encountered Severity: Notice Message: Undefined index: user_id Filename: views/view_course_detail.php Line Number: 371 Backtrace: File: /home/rdivinev/learnthisnow.com.ng/application/views/view_course_detail.php Line: 371 Function: _error_handler File: /home/rdivinev/learnthisnow.com.ng/application/controllers/Course.php Line: 115 Function: view File: /home/rdivinev/learnthisnow.com.ng/index.php Line: 315 Function: require_once A PHP Error was encountered Severity: Notice Message: Undefined index: user_id Filename: views/view_course_detail.php Line Number: 374 Backtrace: File: /home/rdivinev/learnthisnow.com.ng/application/views/view_course_detail.php Line: 374 Function: _error_handler File: /home/rdivinev/learnthisnow.com.ng/application/controllers/Course.php Line: 115 Function: view File: /home/rdivinev/learnthisnow.com.ng/index.php Line: 315 Function: require_once ">
Lesson 11: Show and hide gridlines	Video	View Note Intro to: Show and hide gridlines Show and hide gridlines	Enroll For Course First	0.58	A PHP Error was encountered Severity: Notice Message: Undefined index: user_id Filename: views/view_course_detail.php Line Number: 371 Backtrace: File: /home/rdivinev/learnthisnow.com.ng/application/views/view_course_detail.php Line: 371 Function: _error_handler File: /home/rdivinev/learnthisnow.com.ng/application/controllers/Course.php Line: 115 Function: view File: /home/rdivinev/learnthisnow.com.ng/index.php Line: 315 Function: require_once A PHP Error was encountered Severity: Notice Message: Undefined index: user_id Filename: views/view_course_detail.php Line Number: 374 Backtrace: File: /home/rdivinev/learnthisnow.com.ng/application/views/view_course_detail.php Line: 374 Function: _error_handler File: /home/rdivinev/learnthisnow.com.ng/application/controllers/Course.php Line: 115 Function: view File: /home/rdivinev/learnthisnow.com.ng/index.php Line: 315 Function: require_once ">
Lesson 12: Color the tabs in your workbook	Video	View Note Intro to: Color the tabs in your workbook Color the tabs in your workbook	Enroll For Course First	0.47	A PHP Error was encountered Severity: Notice Message: Undefined index: user_id Filename: views/view_course_detail.php Line Number: 371 Backtrace: File: /home/rdivinev/learnthisnow.com.ng/application/views/view_course_detail.php Line: 371 Function: _error_handler File: /home/rdivinev/learnthisnow.com.ng/application/controllers/Course.php Line: 115 Function: view File: /home/rdivinev/learnthisnow.com.ng/index.php Line: 315 Function: require_once A PHP Error was encountered Severity: Notice Message: Undefined index: user_id Filename: views/view_course_detail.php Line Number: 374 Backtrace: File: /home/rdivinev/learnthisnow.com.ng/application/views/view_course_detail.php Line: 374 Function: _error_handler File: /home/rdivinev/learnthisnow.com.ng/application/controllers/Course.php Line: 115 Function: view File: /home/rdivinev/learnthisnow.com.ng/index.php Line: 315 Function: require_once ">

Chapter 6: How to structure workbook

Title	Type	Note	Lesson	Duration	Completed?
Lesson 1: How to structure your workbook tabs	Video	View Note Intro to: How to structure your workbook tabs How to structure your workbook tabs	Enroll For Course First	3.26	A PHP Error was encountered Severity: Notice Message: Undefined index: user_id Filename: views/view_course_detail.php Line Number: 371 Backtrace: File: /home/rdivinev/learnthisnow.com.ng/application/views/view_course_detail.php Line: 371 Function: _error_handler File: /home/rdivinev/learnthisnow.com.ng/application/controllers/Course.php Line: 115 Function: view File: /home/rdivinev/learnthisnow.com.ng/index.php Line: 315 Function: require_once A PHP Error was encountered Severity: Notice Message: Undefined index: user_id Filename: views/view_course_detail.php Line Number: 374 Backtrace: File: /home/rdivinev/learnthisnow.com.ng/application/views/view_course_detail.php Line: 374 Function: _error_handler File: /home/rdivinev/learnthisnow.com.ng/application/controllers/Course.php Line: 115 Function: view File: /home/rdivinev/learnthisnow.com.ng/index.php Line: 315 Function: require_once ">
Lesson 2: How to structure your Analysis sheet	Video	View Note Intro to: How to structure your Analysis sheet How to structure your Analysis sheet	Enroll For Course First	1.58	A PHP Error was encountered Severity: Notice Message: Undefined index: user_id Filename: views/view_course_detail.php Line Number: 371 Backtrace: File: /home/rdivinev/learnthisnow.com.ng/application/views/view_course_detail.php Line: 371 Function: _error_handler File: /home/rdivinev/learnthisnow.com.ng/application/controllers/Course.php Line: 115 Function: view File: /home/rdivinev/learnthisnow.com.ng/index.php Line: 315 Function: require_once A PHP Error was encountered Severity: Notice Message: Undefined index: user_id Filename: views/view_course_detail.php Line Number: 374 Backtrace: File: /home/rdivinev/learnthisnow.com.ng/application/views/view_course_detail.php Line: 374 Function: _error_handler File: /home/rdivinev/learnthisnow.com.ng/application/controllers/Course.php Line: 115 Function: view File: /home/rdivinev/learnthisnow.com.ng/index.php Line: 315 Function: require_once ">
Lesson 3: Use dynamic formulas	Video	View Note Intro to: Use dynamic formulas Use dynamic formulas	Enroll For Course First	2.12	A PHP Error was encountered Severity: Notice Message: Undefined index: user_id Filename: views/view_course_detail.php Line Number: 371 Backtrace: File: /home/rdivinev/learnthisnow.com.ng/application/views/view_course_detail.php Line: 371 Function: _error_handler File: /home/rdivinev/learnthisnow.com.ng/application/controllers/Course.php Line: 115 Function: view File: /home/rdivinev/learnthisnow.com.ng/index.php Line: 315 Function: require_once A PHP Error was encountered Severity: Notice Message: Undefined index: user_id Filename: views/view_course_detail.php Line Number: 374 Backtrace: File: /home/rdivinev/learnthisnow.com.ng/application/views/view_course_detail.php Line: 374 Function: _error_handler File: /home/rdivinev/learnthisnow.com.ng/application/controllers/Course.php Line: 115 Function: view File: /home/rdivinev/learnthisnow.com.ng/index.php Line: 315 Function: require_once ">
Lesson 4: Color code your analysis output numbers	Video	View Note Intro to: Color code your analysis output numbers Color code your analysis output numbers	Enroll For Course First	5.28	A PHP Error was encountered Severity: Notice Message: Undefined index: user_id Filename: views/view_course_detail.php Line Number: 371 Backtrace: File: /home/rdivinev/learnthisnow.com.ng/application/views/view_course_detail.php Line: 371 Function: _error_handler File: /home/rdivinev/learnthisnow.com.ng/application/controllers/Course.php Line: 115 Function: view File: /home/rdivinev/learnthisnow.com.ng/index.php Line: 315 Function: require_once A PHP Error was encountered Severity: Notice Message: Undefined index: user_id Filename: views/view_course_detail.php Line Number: 374 Backtrace: File: /home/rdivinev/learnthisnow.com.ng/application/views/view_course_detail.php Line: 374 Function: _error_handler File: /home/rdivinev/learnthisnow.com.ng/application/controllers/Course.php Line: 115 Function: view File: /home/rdivinev/learnthisnow.com.ng/index.php Line: 315 Function: require_once ">

Chapter 7: Conclusion

Title	Type	Note	Lesson	Duration	Completed?
Lesson 1: Conclusion message	Text	View Note Intro to: Conclusion message Conclusion message.	Enroll For Course First	---	A PHP Error was encountered Severity: Notice Message: Undefined index: user_id Filename: views/view_course_detail.php Line Number: 371 Backtrace: File: /home/rdivinev/learnthisnow.com.ng/application/views/view_course_detail.php Line: 371 Function: _error_handler File: /home/rdivinev/learnthisnow.com.ng/application/controllers/Course.php Line: 115 Function: view File: /home/rdivinev/learnthisnow.com.ng/index.php Line: 315 Function: require_once A PHP Error was encountered Severity: Notice Message: Undefined index: user_id Filename: views/view_course_detail.php Line Number: 374 Backtrace: File: /home/rdivinev/learnthisnow.com.ng/application/views/view_course_detail.php Line: 374 Function: _error_handler File: /home/rdivinev/learnthisnow.com.ng/application/controllers/Course.php Line: 115 Function: view File: /home/rdivinev/learnthisnow.com.ng/index.php Line: 315 Function: require_once ">

Get To Or Schedule Online Meeting With Course Instructor

Enroll For Course First

Course Instructor:

JJ Technologies
JJ Technologies is there to make available to all and sundry new technologies at very affordable price

JJ Technologies is registered to provide technological services to small and medium scale businesses in Nigeria and West Africa.

She has being n this business for over 8 years and have clients al over various industries and places.

View Detail

LearnthisNow

Becoming An Expert In Data Analysis With Excel

Home All Courses Data Analysis Becoming An Expert In Data Analysis With Excel

Becoming An Expert In Data Analysis With Excel

By: JJ Technologies

Course Details

Course Content

A PHP Error was encountered

A PHP Error was encountered

A PHP Error was encountered

A PHP Error was encountered

A PHP Error was encountered

A PHP Error was encountered

A PHP Error was encountered

A PHP Error was encountered

A PHP Error was encountered

A PHP Error was encountered

A PHP Error was encountered

A PHP Error was encountered

A PHP Error was encountered

A PHP Error was encountered

A PHP Error was encountered

A PHP Error was encountered

A PHP Error was encountered

A PHP Error was encountered

A PHP Error was encountered

A PHP Error was encountered

A PHP Error was encountered

A PHP Error was encountered

A PHP Error was encountered

A PHP Error was encountered

A PHP Error was encountered

A PHP Error was encountered

A PHP Error was encountered

A PHP Error was encountered

A PHP Error was encountered

A PHP Error was encountered

A PHP Error was encountered

A PHP Error was encountered

A PHP Error was encountered

A PHP Error was encountered

A PHP Error was encountered

A PHP Error was encountered

A PHP Error was encountered

A PHP Error was encountered

A PHP Error was encountered

A PHP Error was encountered

A PHP Error was encountered

A PHP Error was encountered

A PHP Error was encountered

A PHP Error was encountered

A PHP Error was encountered

A PHP Error was encountered

A PHP Error was encountered

A PHP Error was encountered

A PHP Error was encountered

A PHP Error was encountered

A PHP Error was encountered

A PHP Error was encountered

A PHP Error was encountered

A PHP Error was encountered

A PHP Error was encountered

A PHP Error was encountered

A PHP Error was encountered

A PHP Error was encountered

A PHP Error was encountered

A PHP Error was encountered

A PHP Error was encountered

A PHP Error was encountered

A PHP Error was encountered

A PHP Error was encountered

A PHP Error was encountered

A PHP Error was encountered

A PHP Error was encountered

A PHP Error was encountered

A PHP Error was encountered

A PHP Error was encountered

A PHP Error was encountered

A PHP Error was encountered

A PHP Error was encountered