Excel For Beginners & Refresher For All

Master the Basics - Formulas, Referencing, Printing, VLOOKUP, Pivot Tables, Charts, Basic Analytics & Much More

What you'll learn

Learn the essential skills and knowledge needed to confidently navigate and utilize Excel for your everyday tasks.

Learn basic spreadsheet navigation, data entry, and formatting to create organized and visually appealing Excel documents efficiently.

Understand essential Excel functions, formulas, and calculations to perform data analysis and automate calculations for better decision-making.

Gain proficiency in creating and modifying charts and graphs to effectively visualize and communicate data trends and insights in Excel.

Explore data sorting & filtering techniques to efficiently manage and analyze large datasets with accuracy.

Master essential Excel tips and tricks for increased productivity, including keyboard shortcuts, cell referencing, and time-saving features.

Requirements

No experience needed. You must know the basics of using a computer.

Computer Literacy: Participants should have basic computer skills, including file management, navigating the operating system, and using a keyboard and mouse.

Desire to Learn: A positive attitude and a willingness to explore and learn new concepts are essential. No prior Excel knowledge is required, making this course suitable for beginners.

Description

Master the Basics  of Microsoft Excel. Learn Important Formulas & Functions, Absolute & Relative Referencing, Printing & Page Setup for Large Workbooks, Functions like VLOOKUP, Pivot Tables for Quick Summary of Data, Basic Analytics & Much More… in Just about 2 Hours. Are you new to Excel and looking to build a strong foundation in this powerful software? Look no further! Our Excel for Beginners course is designed to provide you with the essential skills and knowledge needed to confidently navigate and utilize Excel for your everyday tasks. In this course, you will learn the basics of Excel, including how to create and format spreadsheets, enter and manipulate data, and perform calculations using formulas and functions. You will also discover how to effectively organize and analyze your data using features such as sorting, filtering. Plus, we also cover how to Analyze the data using Pivot Tables.Throughout the course, you will have hands-on practice exercises and real-world examples to reinforce your learning. By the end, you will have gained the skills to create professional-looking spreadsheets, efficiently manage data, and become more productive in your work. Whether you are a student, professional, or just someone wanting to enhance their Excel skills, this course is the perfect starting point for you.Master the fundamentalsWhether you're a business user, owner, executive, student, or teacher, you'll quickly become more competent and comfortable using Excel. You'll understand when and why to use different buttons and menus.This course also acts as a good refresher for intermediate and advanced users of Excel, who might have missed out on some of the settings, options, short cuts and features or functions of Excel.Going through the short byte sized lessons will give you the required knowledge, tips, tricks to quickly navigate Excel,customize Excel,create, rename worksheets and workbooks,use Keyboard Shortcuts,Write Formulas and Functions,Master VLOOKUP & XLOOKUP,Use Tables in Excel,Sort & Filter data confidently,Pivot Tables to summarize and analyze data quickly.What you get:60+ Video Lessons Over two hours of downloadable content.Learn the key features, functions, shortcuts, tips and tricks that you need to know in Excel.Exercise Files Learn by doing and follow along the video lessons with practice files. You receive a blank file as well as a completed file to check your progress.

Overview

Section 1: Introduction

Lecture 1 Introduction

Lecture 2 What is Excel

Lecture 3 How To Get Excel?

Section 2: Excel Fundamentals

Lecture 4 Opening Excel for the first time

Lecture 5 Excel Ribbon, Tab, Rows, Columns, Zoom

Lecture 6 Navigate to different cells in Excel

Lecture 7 Workbooks & Worksheets

Lecture 8 Quick Access Toolbar

Section 3: Excel Shortcuts

Lecture 9 Excel Exercise Book

Lecture 10 Shortcuts to move to Different Sheets

Lecture 11 Quickly Move Within a Worksheet

Lecture 12 Move to Beginning or End of the Data

Section 4: Worksheet Fundamentals

Lecture 13 Insert & Rename a Sheet

Lecture 14 Column Width Adjustments

Lecture 15 Change Data Entry Direction

Lecture 16 Text & Number Alignment

Lecture 17 Accessing Help in Excel

Section 5: Data Entry in Excel + Quick Tips

Lecture 18 Using Right Click Menus

Lecture 19 Using Flash Fill

Lecture 20 Flash Fill for Months

Lecture 21 Delete Multiple Cells

Lecture 22 Row & Column Height

Section 6: Formatting Dates in Excel

Lecture 23 Format Dates & Times

Lecture 24 Getting a Date and time Stamp in Excel

Section 7: Editing Data in Excel

Lecture 25 Ways to Edit a Cell

Lecture 26 Cut, Copy and Paste within a Cell

Lecture 27 Move single or multiple cells

Lecture 28 Merge and Centre

Lecture 29 Changing Fonts & Colors

Section 8: Save Excel Files - Locally or in the Cloud

Lecture 30 Save a Workbook

Lecture 31 Benefits of Saving in the Cloud

Section 9: Formatting Data in Excel & Worksheet Magic

Lecture 32 Inserting & Deleting Cells

Lecture 33 Changing Tab Color

Lecture 34 Move or Copy Worksheets

Lecture 35 Rename a Worksheet

Lecture 36 Format & Alignment of Text

Lecture 37 Number Formatting & Decimal Places

Lecture 38 Formatting a Date

Section 10: Formulas & Functions in Excel

Lecture 39 Use Excel as a Calculator

Lecture 40 Order of Precedence

Lecture 41 Simple Formulas in Excel

Lecture 42 Introduction to Excel Functions

Lecture 43 Inbuilt Functions in Excel, like SUM

Lecture 44 Average Function in Excel

Lecture 45 Maximum Function

Lecture 46 Minimum Function

Lecture 47 Count Function in Excel

Lecture 48 Absolute & Relative Referencing

Lecture 49 Absolute References in-depth

Lecture 50 VLOOKUP Function

Lecture 51 VLookup Simplified

Lecture 52 XLOOKUP Function

Section 11: Creating & Using Tables in Excel

Lecture 53 How to Create a Table in Excel

Lecture 54 Sorting a Table

Lecture 55 Filtering a Table

Section 12: Creating Charts in Excel

Lecture 56 Create Simple Charts

Lecture 57 Sales Trend in a Chart

Section 13: Pivot Tables in Excel

Lecture 58 Creating a Pivot Table in Excel

Lecture 59 Using Filters in Pivot Tables

Lecture 60 Creating Pivot Charts in Excel

Section 14: Printing Excel Worksheets To Create Great Looking Reports

Lecture 61 Formatting & Printing a Worksheet

Lecture 62 Repeating Headers in Printouts

Section 15: EXTRA: Quick Data Analysis in Excel

Lecture 63 Basic Data Analysis in Excel

Beginner Excel Users, New Employees, Students, Managers, Stay at home people, who don't have any formal knowledge or experience of working with Excel.