Store

Microsoft Excel Bundle: Basics + Intermediate + Advanced

500
RM97.00
In stock
1
Product Details
Brand: Microsoft Office
Microsoft Excel is the most effective tool for data analysis, computation, and visualization. It can access any database and is an effective tool for creating models, doing statistical studies, and calculating financials.
EXCEL BUNDLE: What'll you learn

Excel Basics

1) Introduction to the Microsoft
2) Excel Application
3) Interface of Microsoft Excel
4) Introduction of File Menu Part 1
5) Introduction of File Menu Part 2
6) Introduction to the Home Menu
7) Introduction to Insert Menu
8) Introduction to Page Layout Menu
9) Formulas Menu
10) Data Menu
11) Data Menu Part 2
12) Review Menu
13) View Menu
14) Templates for new workbook
15) Formatting the dates
16) Formatting the numbers
17) Formatting the text
18) Conducting the calculations
19) Setting up your workbook for print
20) Setting up your workbook for print Part 2
21) Conclusion
Excel Intermediate
1) Introduction
2) Excel 101
3) Customizing Worksheets
4) How to Clean Up Your Data through Sorting
5) Adding Fully Automated
6) Customized Formatting Part1
7) Adding Fully Automated
8) Customized Formatting Part2
9) Extract the Information You 10) Need – The Fast Route, Part I - Combining cells using formulas
11) Extract the Information You Need – The Fast Route, Part II - 12) Splitting cells, text to columns
13) Extract the Information You Need – The Fast Route, Part III - 14) Extract important information by using filters
15) 15 Quick Excel Functions You Wish You Had Always Known

Excel Advanced
1) Overview
2) Calculations - Absolute References
3) Calculations - Relative References
4) Using Logical Formulas
5) Using Text Formulas
6) Using Lookup Formulas
7) Using Financial Formulas
8) Using Date and Time Formulas
9) Formatting Data as Charts
10) Formatting As Data as Maps
11) Formatting Data as Formal Reports
12) Formatting Data for Other Office Documents
13) Cell Protection and Collaboration
14) Cell Protection and Collaboration - Part 2
15) Interface with Google Sheets
16) Conclusion
17) Bonus Video
18) V Look Up Additional Video 19) Tutorial 1

20) How to create Pivot Tables

Save this product for later
WhatsApp chat