Warning: A non-numeric value encountered in /home/rocketex/public_html/wp-content/themes/Divi/functions.php on line 5763
Select Page

Articles

Structured and in-depth material helps you focus your learning

Examples

Real-life examples with detailed steps included in every post

Z

Quizzes

Quizzes will test your knowledge and remind key learnings This module will introduce you to some Excel basics and help acquire some crucial skills you would need in later modules

1. Introduction to Excel. You will get high-level knowledge of what is Microsoft Excel, what it is used for, and also look through a quick example of how Excel can help you in your everyday life.
2. Excel workbook. This post will explain what is an Excel workbook and what its key elements are. You will also learn how to perform some basic operations with a workbook, like creating a new workbook, saving or opening it.
3. Excel worksheet. You will learn what is an Excel worksheet and how to perform some basic tasks with worksheets: selecting worksheets, creating a new worksheet, renaming, copying, and moving a worksheet.
4. Excel cells. This part explains what is a cell in Excel and different ways to select cells, including selecting multiple cells – or ranges. This knowledge will be crucial when we start learning about Excel formulas and functions in the next module. A separate post will explain how to merge cells in Excel
5. How to add cells. This is a transition to the next module, where you would learn how to write formulas in Excel. You will learn at least four different ways to add values in Excel, including two involving your first Excel formulas This module would introduce you to the world of Excel formulas – one of the major functionalities that Excel is known for

1. Introduction to Excel formulas. Definition of Excel formulas and Excel functions. The short list of most frequently used Excel functions: SUM, COUNT, SUMIFS, IF, MIN, MAX, VLOOKUP, and basic arithmetic operators. Some of these functions are also explained in more detail later.
2. Logical functions. This post will explain the overall functionality of logical functions in Excel, as well as describe some most popular logical functions: IF, AND, OR, NOT.
3. String functions. You will learn how to manipulate text strings in Excel with some most basic string functions: CONCATENATE, LEFT, RIGHT, LEN. A separate post explains how to use TEXT function to convert any values to text
4. Other helpful functions. Some other useful functions will be explained here. For example, ISNA function will be very helpful when working with VLOOKUP and similar functions. This module would introduce you to different tools for analyzing data in Excel:

1. Conditional formatting. You will learn what is conditional formatting and how to use it for different analytical goals you might have. Also, separate posts will introduce you to:
2. Pivot tables. This part will explain what is a pivot table and what pivot tables are used for. A quick example will explain how to create your first pivot table in Excel

How to create a pivot table in Excel

What is an Excel pivot table and how to create one. Brief introduction to the concept with description, quick example, and step-by-step instructions

Excel string functions: CONCATENATE, LEFT, RIGHT, LEN

Introduction to the most basic Excel string functions: CONCATENATE, LEFT, RIGHT, and LEN. Definition, syntax, quick examples, and step-by-step instructions.

Logical functions in Excel: IF, AND, OR, NOT

Introduction to logical functions in Excel: IF, AND, OR, and NOT. Description, potential uses, step-by-step instructions, quick examples

7 most useful Excel formulas and functions

The list of 7 most useful Excel formulas and functions: introduction to Excel formulas and functions, definition, step-by-step instructions, screenshots

How to add cells in Excel

Detailed explanation of how to add cells in Excel, including both most popular methods and some additional tips like using Quick Analysis or Excel Status bar

What is a cell in Excel and how to select cells

Description of a cell in Excel and basic methods for selecting cells: selecting a single cell, multiple cells, rectangular cell areas

Excel worksheet

Quick introduction to the concept of Excel worksheet: definition; key elements; selecting and renaming; copying and creating a worksheet

Excel workbook

Brief introduction to the concept of an Excel workbook: workbook definition, creating a new workbook, saving and opening Excel workbooks