Microsoft Office

Microsoft Office
This program is suitable for beginners and basic learners, easy, fast, and ready for work.

Microsoft Office is a suite of applications designed to help with productivity and completing common tasks on a computer. You can create and edit documents containing text and images, work with data in spreadsheets and databases, and create presentations and posters.

The most common Office applications are Word, Excel, PowerPoint, and Access. Other apps include Publisher, Outlook and OneNote.

Sumatera Computer Centre provides courses according to your needs. We also teach you from the beginning to become proficient in the field of Microsoft Office

Syllabus

WINDOWS
1. Introduction to Windows
2. Control Panel
3. Accessories
4. Paint
5. Taskbar

MICROSOFT OFFICE WORD
1. Introduction to Microsoft Office Word
2. Document Editing, Font, Manipulating, Border, Tabulation
3. Document Formats, Combining & Find Pages, Dates
4. Drop Cap, Line Spacing, Bullet & Numbering, Setting Paragraph
5. Header and Footer, Symbols, Page Number
6. Text Group
7. Illustration Group
8. Table & Table of Contents (Create, Edit, Delete)
9. Insert Text Box, Word Art, Clip Art, Image, Table, etc
10. Equation
11. Form Field
12. Macro
13. Mail Marge
14. Autocorrect
15. Style
16. Printing

MICROSOFT OFFICE EXCEL
1. Introduction to Microsoft Office Excel
2. File Processing
3. Cell Editing in a Worksheet
4. Workbook and Worksheet Display Settings
5. Data Validations, Subtotal, Outline, Group
6. Worksheet Settings
7. Changing Cell Format
8. Database Processing
9. Worksheet Functions Basic: Sum, Min, Max Average, Product, Count, Counta, etc.
10. Worksheet Functions Statistic: Average, Median, Mode, Min, Max, Count, Var, Stdev, Varp. Stdevp, etc
11. Worksheet Functions Financial: Pv, Fv, Pmt, Sln, etc
12. Worksheet Functions Logical: If, And, Or, Not, etc
13. Worksheet Functions Math: Abs, Floor, Ceiling, Mod. etc
14. Worksheet Functions Math Advanced: Logarithm, Trigonometry, etc
15. Worksheet Functions Text (I): Left, Mid, Right, Rept, Len, Find, Substitute, Textsplit, Trim, etc
16. Worksheet Functions Text (II): Char, Code, Concatenate, Upper, Lower, Proper, etc.
17. Worksheet Functions Date: Eomonth, Edate, Today, Networkday, Workday, etc
18. Worksheet Functions Find, Search, Vlookup, Hlookup, Transpose, Index & Match, Filter
19. Worksheet Functions Dynamic Array: Sort, Unique, Sequence, Sortby, etc
20. Worksheet Functions Database: Subtotal, Daverage, Dcount, Dcounta, Dget, Dmax, Dmin, Dsum, etc
21. Graphics Processing: Create, Edit, Format Arrangement, etc
22. Application Merging, Import External Data
23. Management Database: Data Table, Goal Seek, Graphic Chart
24. Multiple Workbooks
25. Merge Application & OLE, Image, Clipart, From File, AutoShape, Hyperlink
26. Dashboard, Filtering & Analyze Data, Conditional Formatting
27. Automation (Macro)
28. Creating Pivot Table
29. Report Printing
30. Case Studies & Real Project Work Simulation (Sales, Inventory, Financial, HR, Budget Plan, etc)


MICROSOFT OFFICE POWER POINT
1. Introduction to Microsoft Office Power Point
2. Slide Show Settings
3. Create & Organize Presentation
4. Drawing
5. Manipulating Slide & Text: Add, Edit, Arrange Table, Graphic, Animations, Audio & Videos

MICROSOFT OFFICE ACCESS
1. Introduction to Microsoft Office Access
2. Query
3. Form
4. Reports
5. Macro

__________________________________________________________

This program is suitable for intermediate learners.

As the company continues to grow and operational challenges become increasingly complex, it strives to enhance performance and efficiency through the development of high-quality human resources. In this regard, proficiency in productivity software such as advanced Microsoft Excel has become essential and plays a crucial role in ensuring the smooth execution of daily operational activities by Analyzing, Planning, Making Best & Quick Decision.


MICROSOFT EXCEL ADVANCED
1. Advanced Excel Formulas and Functions.
2. Data Cleaning & Normalization
3. Data Validation and Subtotal.
4. Application Merging, Import External Data
5. Data Analysis, Visualization and Business Intelligence.
6. Interactive Dashboard & Presentation
7. Logical Analysis.
8. Pivot Table Advanced.
9. Power Query, Forecasting, Prediction/ Forecasting
10. Automation (Macro)
11. Collaboration and Security in Excel.
12. Shortcut Key, Tips and Tricks in Excel.
13. Automation Report
14. Case Studies & Real Project Work Simulation (Sales, Inventory, Financial, HR, Budget Plan, etc)


__________________________________________________________

This program is suitable for intermediate learners.

The use of Power Query, Power BI, and Excel VBA enables automation, efficient processing of large volumes of data in a fast and organized manner, and the presentation of data in the form of easily understandable Advanced Interactive dashboards to support quick and accurate business decision-making.

Power Query- Power BI- VBA
Excel Data visualizations, Storytelling with data, Data Analytics, Predictive analytics, Automation

Learn business analytics that helps transform data into actionable insights. Whether you are a business user, report creator, or developer, you will learn how to connect, visualize, and share data across your organization

SYLLABUS

A. Power Query
1. Introduction & Power Query Mindset which differs from standard Excel.
2. Data Extraction
3. Data Transformation
4. Combining Data & Queries
5. Data Loading & Automation
6. Introduction to "M" Language
7. Handling large Excel datasets—which are typically heavy and slow—making them much lighter and faster.
8. Visualize and Analyze data professionally to drive business decisions.

B. Power BI
1. Introduction & Power BI Ecosystem
2. Data Connection & Transformation
3. Data Modeling
4. DAX (Data Analysis Expressions).
5. Data Visualization, Prediction/ Forecasting & Decision Making
6. Presenting specific and detailed data reports within a single visual layout that is easy and quick for audiences to understand.

C. VBA Excel
1. Introduction to VBA & Macro Recorder
2. Fundamentals of VBA Programming
3. Objects and Collections in VBA
4. User Interaction & User Forms
5. Automate the cleaning of messy data, merge multiple reports, and build reporting systems quickly
6. Automate repetitive tasks.

D. Case Studies & Real Project Work Simulation (Sales, Inventory, Financial, HR, Budget Plan, etc)