"Getting Started With Microsoft Excel: A Step-By-Step Guide

Formulas and Functions: Understanding how to use formulas and functions to calculate and analyze data.

What you'll learn

How to create and format worksheets and workbooks

How to use formulas and functions for calculations

How to use data analysis and visualization tools to analyze data

How to automate tasks and create macros for efficiency

Requirements

The prerequisites for taking our Excel course are basic computer skills, such as using a mouse, typing, and navigating the internet. Additionally, we recommend that you have some basic Microsoft Excel knowledge, such as knowing how to open and save a file, format cells, and use formulas. If you do not have this basic knowledge, we suggest reviewing our Excel Basics course prior to taking the new video course.

Description

Microsoft Excel is a powerful and versatile spreadsheet application that is part of the Microsoft Office suite of productivity software. It is used for data analysis, managing large sets of data, and creating charts and graphs. It is also used for financial modeling, budgeting, and forecasting.Excel is a widely used tool in nearly all business and academic settings, so it is important to understand its features and capabilities. In this course, you will learn the basics of Excel, including how to create and enter data, manipulate data, use formulas, and create charts and graphs.This course is designed for people with little to no experience with Microsoft Excel. We will start off by introducing you to the basics of the program, including the ribbon, cells, and menus. You will then learn how to enter and format data, as well as use formulas and functions. We will also cover how to create charts and graphs, and how to analyze and manipulate data.By the end of this course, you will be comfortable using the basic features of Excel, and you will have the knowledge and skills necessary to create and manage spreadsheets. This course is designed to help you learn quickly and efficiently, so that you can start using Excel right away.We will cover the following topics:• Introduction to Microsoft Excel• Entering and Formatting Data• Using Formulas and Functions• Creating Charts and Graphs• Analyzing and Manipulating Data• Advanced FeaturesThis course is designed to help you learn quickly and efficiently, so that you can start using Excel right away. With the in-depth knowledge and expertise you will gain from this course, you will be able to create and manage spreadsheets with ease.

Overview

Section 1: Introduction

Lecture 1 Introduction

Lecture 2 Episode 2 MS Excel - Basics

Lecture 3 MS Excel - Copying and Filling - Tricks

Lecture 4 MS Excel - Editing Data

Lecture 5 MS Excel - Working with Worksheets

Lecture 6 MS Excel - Adjusting worksheet

Lecture 7 MS Excel - Basic Formulas

Lecture 8 MS Excel - Name Range

Lecture 9 MS Excel - Name Range with Formulas

Lecture 10 MS Excel - Statistical Functions

Lecture 11 MS Excel - Create & Close Files

Lecture 12 MS Excel - Tabs & Groups

Lecture 13 MS Excel - Characteristics of Cell

Lecture 14 MS Excel - Cell Reference

Lecture 15 MS Excel - Speak Cells

Lecture 16 MS Excel - Text to Columns

Lecture 17 MS Excel - Formatting - Copy

Lecture 18 MS Excel - Advanced Conditional Formatting

Lecture 19 MS Excel - Advanced Fill

Lecture 20 MS Excel - Advanced Filters

Lecture 21 MS Excel - Advanced Table

Lecture 22 MS Excel - AND Function

Lecture 23 Excel - Auditing Tools

Lecture 24 MS Excel - Basic Table

Lecture 25 MS Excel - Column Chart

Lecture 26 MS Excel - Comments

Lecture 27 MS Excel - Comments

Lecture 28 MS Excel - Conditional Formatting Part 1

Lecture 29 MS Excel - Conditional Formatting Part 2

Lecture 30 MS Excel - Consolidation Extended

Lecture 31 MS Excel - Consolidation

Lecture 32 MS Excel - Count Functions

Lecture 33 MS Excel - Create Objects

Lecture 34 MS Excel - Custom View

Lecture 35 MS Excel - Data Sorting

Lecture 36 MS Excel - Data Validation Error Alert

Lecture 37 MS Excel - Data Validation

Lecture 38 37 MS Excel - Date Functions Part 1

Lecture 39 MS Excel - Date Functions Part 2

Lecture 40 MS Excel - Date Functions Part 3

Lecture 41 MS Excel - Dependent Dropdown List

Lecture 42 MS Excel - Design a Column Chart Part_2

Lecture 43 MS Excel - Fill Series

Lecture 44 MS Excel - Filtering Data

Lecture 45 MS Excel - Flash Fill

Lecture 46 MS Excel - Formatting

Lecture 47 MS Excel - Header & Footer

Lecture 48 MS Excel - H-Lookup

Lecture 49 MS Excel - Hyperlink to File

Lecture 50 MS Excel - Hyperlink to Sheet

Lecture 51 MS Excel - Hyperlink to Update

Lecture 52 MS Excel - Hyperlink to Webpage

Lecture 53 MS Excel - IF Function

Lecture 54 MS Excel - Import Live Data From Web to Excel

Lecture 55 MS Excel - Index Function

Lecture 56 MS Excel - Insert Objects

Lecture 57 MS Excel - Logical Test

Lecture 58 MS Excel - Lookup Full Record

Lecture 59 MS Excel - Lookup Function

Lecture 60 MS Excel - Match Function

Lecture 61 MS Excel - Maths & Trigonometry

Lecture 62 MS Excel - Nested IF

Lecture 63 MS Excel - Not and If Error

Lecture 64 MS Excel - Pie, Bar, Column & Line Chart

Lecture 65 MS Excel - Pivot Chart

Lecture 66 MS Excel - Pivot Table Example 1 Video Tutorials

Lecture 67 MS Excel - Pivot Table Example 2

Lecture 68 MS Excel - Pivot Table Example 3

Lecture 69 MS Excel - Pivot Table Grouping

Lecture 70 MS Excel - Pivot Table Slice

Lecture 71 MS Excel - Print Page Setup & Print Data Tips

Lecture 72 MS Excel - Protect Cells

Lecture 73 MS Excel - Protect File

Lecture 74 Excel - Protect Sheet

Lecture 75 Excel - Protect Workbook

Lecture 76 MS Excel - Shortcuts Alt+A to Alt+Z

Lecture 77 MS Excel - Shortcuts Alt+F1 to Alt+F12

Lecture 78 MS Excel - Shortcuts Ctrl + Shift + Single Key

Lecture 79 MS Excel - Shortcuts Ctrl + Shift + Special Characters

Lecture 80 MS Excel - Shortcuts Ctrl + Special Characters

Lecture 81 MS Excel - Shortcuts Ctrl+A to Ctrl+Z

Lecture 82 MS Excel - Shortcuts Ctrl+F1 to Ctrl+F12

Lecture 83 MS Excel - Shortcuts Ctrl+Shift+A To Ctrl+Shift+Z

Lecture 84 MS Excel - Shortcuts Ctrl+Shift+F1 to Ctrl+Shift+F12

Lecture 85 MS Excel - Shortcuts Ctrl+Single Key

Lecture 86 MS Excel - Shortcuts F1 to F12

Lecture 87 MS Excel - Shortcuts Shift+F1 to Shift+F12

Lecture 88 MS Excel - Shortcuts Shift+Single Key

Lecture 89 MS Excel - Shortcuts Single Key

Lecture 90 MS Excel - Spark Line Chart

Lecture 91 MS Excel - Subtotal

Lecture 92 MS Excel - Text Functions

Lecture 93 MS Excel - View Files Side by Side

Lecture 94 MS Excel - Viewing Worksheets

Lecture 95 MS Excel - VLookup Approximate Match

Lecture 96 MS Excel - Vlookup in Excel Video Tutorials

Lecture 97 MS Excel - VLookup Rules

Lecture 98 MS Excel - VLookup with Trim

Lecture 99 MS Excel - XY Scatter Chart

This course is designed for people who are new to using Microsoft Excel and want to learn the basics. It covers topics such as creating spreadsheets, formatting cells, using formulas, and creating charts and graphs.