
Develop basic data entry and document creation skills for day-to-day tasks and expense reporting. Learn budgeting and flier creation with Microsoft Word to boost competitiveness in the job market.
Explore how to access basic data entry tools without Microsoft Office by using Google Drive, Google Docs, Sheets, and Slides after signing up for a Google account.
Learn how to access a free Microsoft 365-like software from the official site by creating an account, using a Word-like interface, and avoiding a paid subscription.
Open the Word app from the start menu to explore the ribbons, title bar, and tabs like file, home, insert, and layout in Microsoft Word.
Learn three methods to convert a pdf to a word document: typing, copying and pasting with ctrl+c and ctrl+v, and using Adobe Acrobat export; always format and verify the result.
Master basic editing through the home menu and ribbons, applying fonts, paragraphs, styles, and editing tools, including Arial 18, bold, italic, underline, highlight, color, and find and replace.
Use the insert tab to set headers and footers, insert date and time, set a title scatter graph, adjust the font to 20, and include page numbers on every page.
Open the review tab to check spelling and grammar. Use the review button to spot errors and correct them on the spot for accurate data entry.
Master table basics for data entry, including inserting tables, centering text, and organizing federal, state, and local deadlines in tax documents.
Use the design tab to add a watermark, choosing a confidential watermark for every page. See the watermark 'confidential' appear across all pages when you print the document.
Master inserting and formatting pictures in Word from this device, stock images, and online sources, with resizing and text-wrapping for polished presentations.
Learn how to insert and manage hyperlinks in a document, including linking words to web pages, files, and email addresses, and remove hyperlinks.
Learn how to convert a document into a pdf using a pdf converter and Adobe tools. Save the result with a version label, such as version three, after conversion.
Explore basic printing features, including printer property settings, page range, and collate options, adjust margins, and switch between two-page and one-page layouts to preview printouts.
Create a folder on the desktop and save a copy there. Save your work regularly to prevent data loss if the computer crashes.
Practice using Microsoft Word by applying skills from two documents: a PDF gig work file and a scatter graph, through step-by-step typing to build basic data entry skills.
Explore how to open the Excel app from the start menu, navigate the ribbon and title bar, and understand tabs, groups, and common features in a blank workbook.
Convert pdf or image data into excel for export to the database. Ensure fields like first name, last name, address, city, state, zip code, and phone are formatted as text.
Learn to use tables in Excel by inserting a table, defining headers, and sorting data alphabetically to manage large datasets efficiently.
Develop web research and data entry skills by gathering bakery listings in a town, verifying websites or Facebook pages, and recording addresses and phone numbers in Excel.
Learn to use essential Excel functions for data entry, including add, subtract, multiply, and divide, plus auto sum, average, and fill series to streamline monthly totals, and drag and fill.
Adjust column widths to view all rows and columns, bold the header, and freeze the top row to keep names, addresses, zip codes, phones, emails, and websites visible.
Learn to use the summation and if formulas to total across large spreadsheets, applying criteria by column, handle true/false logic to calculate net losses and allowable deductions.
Master header and footer design in Excel by using page layout and header options to add company names, file paths, sheet names, page numbers, and logos.
Master print preview and page setup to present data entry sheets clearly, repeat header rows, set landscape, adjust margins, and fit content on fewer pages.
Preview and print Excel reports by adjusting page setup, margins, headers, and orientation; fit to one page, toggle gridlines, and set a print area for gross profit.
Learn to create and use pivot tables to analyze sales data by year and by salesperson, using recommended options to view sums in a new sheet for quick decisions.
Create a sales graph in Excel by selecting year and sales, inserting a clustered column chart, and adding a moving average trend line for clear presentation.
Use a Microsoft Word loan amortization template to input loan data and preview payments and payoff for mortgage or debt, illustrated with 150,000 at 4% and 7,500 at 15%.
Practice is key to mastering excel and data entry; download samples from the course, apply each lesson, and use a google drive spreadsheet with a gmail account to practice.
Master essential data entry shortcuts for Word and Excel by using cut, copy, paste, open new document, and undo commands, all the basic keys every user should have handy.
Master essential Excel formulas like max, min, today, now, and subtotal to streamline data entry tasks; learn to insert dates and expand your basic formula skills.
Use the q&a button to ask a new question, and choose between two options: data entry content or other. Post projects to share, and my assistant will help you out.
Explore an entry-level data entry job posting on Upwork. Learn how to build a state-by-state contact database in Excel, handling copy-paste challenges and showcasing a sample with a resume.
Welcome to the data entry course for beginners. This course is going to teach you basic data entry skills that will help you become a data entry professional, virtual assistant, or someone who is ready to enter the work force for clerical positions.
I am Padma Vaidyanathan, the developer and instructor of this course. I am an employer and I have been in business for over 25 years. During that period, I have hired and trained a lot of data entry professionals. Some of the staff that I had to trained lacked the basic skills that they needed to hit the ground running. It is out of that experience that I have decided to create and teach this course to enable intending data entry professionals to learn the basic skills before seeking employment.
I am going to teach you how to complete some basic data entry tasks that will immediately qualify you for data entry jobs in any industry. These are the basic skill sets we look for when we hire you as an employee or remote hire. This will allow you to have confidence in your basic skill so you too can apply for entry level data entry positions.
At the end of the course, you will be able to do the following with the skills you will learn:
Convert a PDF/image file into word
Edit and format in Microsoft Word or other word processors
Create custom headers and footers or insert prepopulated ones such as the date function
Create tables in Microsoft Word and use watermarks in your documents
Create an excel data base from PDF files
Use web research to create a Microsoft Excel data base
Perform page setups and print preview functions in Microsoft Excel
Files are provided for your practice.
After watching and working along with me with each segment, you will get the confidence to move forward and start looking for basic data entry skill jobs.