Excel 101 for Virtual Assistants

The Virtual Assistant’s Guide to Excel

0/5

Excel 101 for Virtual Assistants

What you’ll learn

Familiarize with the Excel interface and basic navigation.
Create and edit basic spreadsheets and cell data.
Perform simple calculations using formulas and functions.
Format cells and sheets for visual appeal and organization.
Sort and filter data in spreadsheets.
Create charts and graphs to represent data.
Use basic conditional formatting to highlight important data.
Implement basic data validation to ensure accurate data entry.
Use templates and save custom templates for future use.

Requirements

No experience required.

Overview

Section 1: Introduction

Lecture 1 How to go about learning Microsoft Excel

Lecture 2 The Microsoft Excel user interface

Lecture 3 Navigating the Microsoft Excel interface

Lecture 4 Three types of clicks!

Lecture 5 Data Types in Excel

Lecture 6 Basic Data Entry

Lecture 7 Introduction to Excel formulae

Lecture 8 Excel formulae and functions

Lecture 9 Absolute cell reference

Lecture 10 Delete and hide cells in a workbook

Lecture 11 What Virtual Assistants should be aware of

Section 2: Formatting in Microsoft Excel

Lecture 12 Basics of formatting

Lecture 13 Formatting with themes

Lecture 14 Tips and Tricks to speed up Data Entry

Lecture 15 Freeze Panes

Lecture 16 Conditional Formatting

Lecture 17 Tips and Tricks for better formatting

Section 3: Filter, sort and custom sort

Lecture 18 Filter

Lecture 19 Custom Sort

Lecture 20 Summary on Filtering, Sorting and Custom Sorting

Section 4: Charts with Microsoft Excel

Lecture 21 Introduction to variables and plotting relationships between variables

Lecture 22 Charts with Categorical Data

Lecture 23 Histograms, boxplots and scatterplots

Lecture 24 Line, bar and pie charts

Section 5: Pivot Tables with Microsoft Excel

Lecture 25 Pivot Tables

Lecture 26 Pivot tables with Slicer

Section 6: Intermediate Excel

Lecture 27 Logical statements in Excel: IF

Lecture 28 Logical statements: Nested IF

Lecture 29 Logical statements: AND & OR

Lecture 30 CHOOSE Statement

Lecture 31 VLOOKUP : Exact Match

Lecture 32 VLOOKUP: Range

Lecture 33 INDEX MATCH Statement

Lecture 34 Data Validation

Lecture 35 Data Validation + Drop Down

Lecture 36 Data Tables

Lecture 37 Use Cases for Data Tables

Lecture 38 Goal seek

Lecture 39 Use Cases for Goal Seek

Lecture 40 Trace precedents and dependents

Lecture 41 Tips and Tricks to get the most out of Excel

Office administrators, support staff, and other professionals who need to manage and analyze data using Excel as part of their day-to-day work.,Anyone who is looking to acquire basic Excel skills for personal or professional use.,Entry-level virtual assistants with little to no prior experience with Microsoft Excel.,Virtual assistants who are looking to improve their skills and become more efficient in handling data and spreadsheets.,Job seekers who are looking to improve their skills in data management and analysis.

Course Information:

Udemy | English | 4h 9m | 2.32 GB
Created by: DatOlympia Learning Solutions

You Can See More Courses in the Office Productivity >> Greetings from CourseDown.com

Scroll to Top