Foresight BI

Introduction

Prerequisites

If you don't have Excel installed and want a Microsoft 365 version

Excel Knowledge Overview

Download Excel files used in the course

Understanding the Excel Environment

Changing Settings in Excel Optios

Saving & Protecting Excel Workbooks

Navigating between Excel Worksheets

Navigating between Excel Workbooks

Intro to Copying & Pasting

Pasting with Options

Using the Paste Option Dialog Box

Pasting from the Clip Board Button

Replicating Worksheet data with Move or Copy tool

Intro to Find & Replace

Find & Replace Options

Find & Replace using * Wild Card

Find & Replace using ? Wild Card

Find & Replace based on Cell Format

Understanding Cells

Increasing Cell Size, Row/Column Height & Width

Understanding Excel Data Types

Dates are treated like Numbers

Intro to Cell Formatting

Intro to Cell Formatting (2)

Intro to Numbers Formatting

Customizing Numbers Formatting

Behavior of Text and Numbers Formatting

Customizing Date Formats

Cell Formatting Sample

Intro to Data Sorting

Basic Data Sorting

Sorting Data that has empty rows or columns

A better way to sort

More sorting options

Advanced Sorting options

Intro to Data Filtering

Clearing Filters & Using Search for Filtering

Filtering data based on rules

Using Advanced Filtering

Freeze Panes

Use Outlines for Expand/Collapsible Buttons

Intro to Autofill and Fill Series

Using Fill Dialog Box

Fill Series with Linear & Growth

Fill Series based on Trends

Using Flash Fill

Intro to Data Validation

Creating Dropdown Lists

Text to Different Columns with Delimiters

Text to Columns using Fixed Width

Introduction to Excel Formulas

Writing simple formulas with primitive values

Introduction to Excel Functions

How to use Functions in Excel

Adding up with SUM function

Using Autosum to save time

Using AVERAGE, MIN, MAX, LARGE and SMALL