Solving real-life problems in Excel
Short Office Administration
0% Completed
Module 1: INTRODUCTION TO OFFICE ADMINISTRATION
Office administration is about controlling over all the departments activities in an organization. Its a process which handles day-to-day operations of an office. This department helps other departments on their work. They do centralized work for other departments.
Module 2: MICROSOFT WORD/GOOGLE DOCS
In this week, you will learn how to format text, save and share documents, modify line and paragraph spacing, use tables and columns, and do more with your documents.
Creating Google Docs
Video - 00:00:00 mins
Getting Started with MS Word
Video - 00:03:40 mins
Formatting Text
Video - 00:02:58 mins
Modifying Page Layout/Printing
Reading
Styles and Themes
Video - 00:3:15 mins
Working with Headers and Footers
Video - 00:03:33 mins
Reviewing Documents
Video - 00:5:37 mins
Working with Tables
Video - 00:4:51 mins
Using Mail Merge
Video - 00:00:00 mins
WK 2 Quiz
Quiz
Module 3: MICROSOFT POWERPOINT/GOOGLE SLIDES
You learn how to use themes and background styles, add pictures and clip art, modify charts and lists, and do more to create standout presentations.
Module 4: ONLINE SAFETY
This topic will provide you with strategies, skills, and a mindset needed to protect yourself, your computer, and your privacy online.
Module 5: INTRODUCTION TO GOOGLE SUITE
You can do a lot with a Google account these days, from using Google Drive to create and share documents, spreadsheets, and presentations to using Google Maps to find your way around.
Module 6: MICROSOFT EXCEL/GOOGLE SHEETS
Getting Started with Google Sheets
Video - 00:02:30 mins
Working with columns, rows, and cells
Video - 00:03:32 mins
Creating Simple Formulas
Video - 00:03:19 mins
Functions
Video - 00:05:10 mins
Complex Formulas
Video - 00:05:9 mins
Solving real-life problems in Excel
Video - 00:4:17 mins
Understanding Number Formats
Video - 00:05:40 mins
VLOOKUP, HLOOKUP, AND XLOOKUP
Video - 00:32:00 mins
Wk 8 Quiz
Quiz
Module 7: INTRODUCTION TO GMAIL AND OUTLOOK
Module 8: USING AI FOR PRODUCTIVITY
You're Almost There
Please complete previous Lesson first
Continue Previous Lesson
1 step remaining to unlock this lesson
