Information Technology
Category
17
Modules
83
Coursewares
₱3,000.00
Course Fee
Course Description

Microsoft Office Excel has been widely used for data management as well as storage. Since we are in the Information Age, data is one of the most valuable asset a company could have thus proper collection, manipulation, and analyzation data is a priority. Passing this course guarantees you to receive MOS Excel Certificate.

Lecture Slide Data Files
Start Excel
Quick Access Toolbar
Split Feature
Changing Workbook View
Navigating a Worksheet
Saving Workbooks
Introduction to Excel
Knowledge Check
Create a workbook from scratch
Name and Save a workbook
Save to your OneDrive
Save a Workbook Under a Different Name
Save a Workbook in a Previous Excel Format
Save in Different File Formats
Enter Basic Data in a Worksheet
Change the Column Width
Edit a Cell’s Contents
Delete and Clear a Cell’s Contents
Enter Dates
Fill a Series with Auto Fill
Copy a Data Series with the Mouse
Move a Data Series with the Mouse
Working with MS Excel
Knowledge Check
Set the Print Area
Print Selected Worksheet
Print an Entire Workbook
Apply Print Options
Customize the Quick Access Toolbar
Customize the Ribbon
Select a Template from the New Tab
Using Office Backstage
Knowledge Check
Display Formulas
Understand Order of Operations
Use Relative Cell References in a Formula
Use an Absolute Cell Reference in a Formula
Use a Mixed Cell Reference in a Formula
Refer to Data in Another Worksheet
Name a Range of Cells
Create a Formula that Operates on a Named Range
Using Basic Formulas
Knowledge Check
Use the SUM Function
Use the COUNT, COUNTA, and COUNTBLANK Functions
Use the AVERAGE Function
Use the MIN Function
Use the MAX Function
Using Functions
Knowledge Check
Formatting Cells and Ranges
Knowledge Check
Formatting Worksheets
Knowledge Check
Managing Worksheets
Knowledge Check
Working with Data and Macros
Knowledge Check
Using Advanced Formulas
Knowledge Check
Securing Workbooks
Knowledge Check
Creating Charts
Knowledge Check
Adding Pictures and Shapes to a Worksheet
Knowledge Check
Final Assessment
Final Assessment Data Files
Project 1
Project 2
Project 3
Project 4
Project 5
Project 6
Project 7
Project 1
Project 2
Project 3
Project 4
Project 5
Project 6
Project 7

Oops!

You can't enroll using this account. Please register as a student by clicking the Sign Up button.

Oops!

Please complete your profile before you can start enrolling to courses.

Oops! Your email is not yet verified.

Didn't get an email? Click here to resend email verification or contact us at admin@apptitude.xyz

Close
Previous Step

Sorry, we can't verify your identity.

Please upload a clearer ID or retake your photo.

We have successfully verified your identity!

Select mode of payment

Enrollment Successful

Thank you for completing your enrollment. You can now access the course.

[[ message ]]
Course Amount
MOS Excel 2019 Review ₱[[ course.fee.toLocaleString(undefined, {minimumFractionDigits: 2, maximumFractionDigits: 2}) ]]
Value-Added Tax ₱[[ course.tax.toLocaleString(undefined, {minimumFractionDigits: 2, maximumFractionDigits: 2}) ]]
Payment Gateway Fee ₱[[ gateway_fee.toLocaleString(undefined, {minimumFractionDigits: 2, maximumFractionDigits: 2}) ]]
Discount ₱[[ discount.toLocaleString(undefined, {minimumFractionDigits: 2, maximumFractionDigits: 2}) ]]
Total ₱[[ total.toLocaleString(undefined, {minimumFractionDigits: 2, maximumFractionDigits: 2}) ]]
Note that the payment gateway fee is paid to a third-party payment facilitator (DragonPay); a separate convenience fee for bank transactions and M. Lhuillier will be charged. The separate fee ranges from ₱10.00 to ₱100.00 and is excluded from the total amount above.

Select class

Class Name Schedule
No classes available.

GENERAL NOTICE

A.M. 19-10-16-SC requires random photo validation. Please proceed with this course indoors, in a well-lit room to facilitate authentication.

This content is only available for consumption on the platform. No part of this module may be captured, copied, stored, distributed, or otherwise used without permission.

Continue

Hello, Welcome Back!

Forgot Password

Oh no! That's not a valid email address.

Sign Up

By signing up, you agree to our Terms of Use and Privacy Policy.