Learn Excel for Data Entry: A Beginner’s Guide!
Sadiq Umar, Virtual Assistant Coach
Regardez ce cours et des milliers d'autres
Regardez ce cours et des milliers d'autres
Leçons de ce cours
-
-
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
-
-
- --
- Niveau débutant
- Niveau intermédiaire
- Niveau avancé
- Tous niveaux
Généré par la communauté
Le niveau est déterminé par l'opinion majoritaire des apprenants qui ont évalué ce cours. La recommandation de l'enseignant est affichée jusqu'à ce qu'au moins 5 réponses d'apprenants soient collectées.
15
apprenants
--
projet
À propos de ce cours
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!
Rencontrez votre enseignant·e
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.
Voir le profil completProjet de cours pratique
In this class, you will learn everything you need to know about using Excel/Google Sheets to perform Data Entry tasks for clients.
Notes attribuées au cours
Pourquoi s'inscrire à Skillshare ?
Suivez des cours Skillshare Original primés
Chaque cours comprend de courtes leçons et des travaux pratiques
Votre abonnement soutient les enseignants Skillshare
Apprenez, où que vous soyez
Suivez des cours où que vous soyez avec l'application Skillshare. Suivez-les en streaming ou téléchargez-les pour les regarder dans l'avion, dans le métro ou tout autre endroit où vous aimez apprendre.
