Learn Excel for Data Entry: A Beginner’s Guide!
Sadiq Umar, Virtual Assistant Coach
Ve esta clase y miles más
Ve esta clase y miles más
Lecciones en esta clase
-
-
1.
Welcome & Course Introduction
2:21
-
2.
What is Data Entry? (VA context)
3:20
-
3.
Types of data entry tasks VAs do
5:37
-
4.
Why clients outsource data entry
2:45
-
5.
How to access Microsoft Excel (Web/Desktop)
6:00
-
6.
Navigating the Excel interface
2:59
-
7.
Understanding rows, columns, cells, and sheets
2:24
-
8.
Saving your work (local & cloud)
2:54
-
9.
Typing and editing text and numbers
3:59
-
10.
Copy, cut, paste & undo/redo
7:55
-
11.
Using Find and Replace
3:25
-
12.
Basic formulas: SUM, AVERAGE, COUNT
6:06
-
13.
Formatting text (bold, underline, colors)
3:24
-
14.
Adjusting column width & row height
6:17
-
15.
Aligning and wrapping text
3:27
-
16.
Number formatting (currency, date, percentage)
4:44
-
17.
Freezing panes
2:22
-
18.
Creating and formatting tables
3:56
-
19.
Sorting and filtering data
5:55
-
20.
Removing duplicates
3:06
-
21.
Inserting and deleting rows/columns/sheets
7:30
-
22.
Protecting cells and sheets from edits
4:18
-
23.
Share Access
3:40
-
24.
Recording survey responses or customer feedback
6:58
-
25.
Entering product information for an eCommerce store
5:14
-
-
- --
- Nivel principiante
- Nivel intermedio
- Nivel avanzado
- Todos los niveles
Generado por la comunidad
El nivel se determina según la opinión de la mayoría de los estudiantes que han dejado reseñas en esta clase. La recomendación del profesor o de la profesora se muestra hasta que se recopilen al menos 5 reseñas de estudiantes.
16
Estudiantes
1
Proyectos
Acerca de esta clase
Do you want to become a Virtual Assistant but feel stuck because you don’t know Excel?
This beginner-friendly course is designed specifically for aspiring Virtual Assistants who want to learn data entry using Excel — one of the most in-demand skills clients are hiring for today.
By the end of this course, you'll go from Excel beginner to confidently completing real-world data entry tasks for clients — even if you've never opened a spreadsheet before.
What You’ll Learn:
-
What data entry really means in the VA world
-
The types of data entry tasks clients outsource
-
How to use Excel (Web/Desktop) for data entry projects
-
Formatting, formulas, and organizing data the right way
-
How to sort, filter, and manage large data sets
-
How to complete real client-like tasks (e.g. surveys, product info, real estate data)
Who This Course Is For:
-
Beginner Virtual Assistants (or freelancers) who want to offer Excel data entry as a service
-
Anyone new to Excel who wants to work remotely doing simple but valuable tasks
-
Self-learners and job seekers looking to upskill for admin/data entry roles
What You’ll Need:
-
A computer or laptop (Windows or Mac)
-
Microsoft Excel (either desktop or free web version)
No prior Excel experience required!
Conoce a tu profesor(a)
I am Sadiq Umar. I started freelancing in 2019 and later transitioned to working as a Virtual Assistant. I have been a full-time Virtual Assistant since 2021.
I achieved a Top-Rated badge on Upwork with a 100% Job Success Score and reached Level 2 on Fiverr with a full 5-star client rating. Working as a freelancer and full-time Virtual Assistant, I have acquired extensive knowledge and experience in starting and succeeding in these fields.
I am passionate about teaching complete beginners how to start and succeed as freelancers and Virtual Assistants.
Ver perfil completoProyecto de clase práctica
In this class, you will learn everything you need to know about using Excel/Google Sheets to perform Data Entry tasks for clients.
Valoración de la clase
¿Por qué unirse a Skillshare?
Mira las galardonadas Skillshare Originals
Cada clase tiene lecciones cortas y proyectos prácticos
Tu membresía apoya a los profesores de Skillshare
Aprende desde cualquier lugar
Ve clases sobre la marcha con la aplicación de Skillshare. Progresa en línea o descarga las clases para verlas en el avión, el metro o donde sea que aprendas mejor.
