UNITY INTERNATIONAL SCHOOLS
- 0
- Login
- ICT Training Hub
- Digital Proficiency Cert.
- ICT Fundamentals Cert.
- MOS Excel Cert.
- IC3 Digital Literacy Cert.
- Cisco Certification
- Full-Stack Development Cert.
- Python Programming Cert.
- ComPTIA Core Certifications.
- ComPTIA Infrastructure Cert.
- ComPTIA Cyber Security Certifications
- ComPTIA Career Advancement Program Certifications
- Java Certification
- JavaScript Certification
- Digital Marketing Certification
- Data Analysis Certification
- Power BI Certification
- Digital Project Management Crtification
- Tableau Certification
- Digital Proficiency Odyssey
- ICT Fundamentals
- Cisco
- Full-Stack Programming
- ComPTIA Career Advancement
- ComPTIA-Core Certifications
- ComPTIA-Cyber Security Cert.
- ComPTIA
- ComPTIA-Infrastructure. Cert.
- Java
- Digital Insights
- …
- ICT Training Hub
- Digital Proficiency Cert.
- ICT Fundamentals Cert.
- MOS Excel Cert.
- IC3 Digital Literacy Cert.
- Cisco Certification
- Full-Stack Development Cert.
- Python Programming Cert.
- ComPTIA Core Certifications.
- ComPTIA Infrastructure Cert.
- ComPTIA Cyber Security Certifications
- ComPTIA Career Advancement Program Certifications
- Java Certification
- JavaScript Certification
- Digital Marketing Certification
- Data Analysis Certification
- Power BI Certification
- Digital Project Management Crtification
- Tableau Certification
- Digital Proficiency Odyssey
- ICT Fundamentals
- Cisco
- Full-Stack Programming
- ComPTIA Career Advancement
- ComPTIA-Core Certifications
- ComPTIA-Cyber Security Cert.
- ComPTIA
- ComPTIA-Infrastructure. Cert.
- Java
- Digital Insights
UNITY INTERNATIONAL SCHOOLS
- ICT Training Hub
- Digital Proficiency Cert.
- ICT Fundamentals Cert.
- MOS Excel Cert.
- IC3 Digital Literacy Cert.
- Cisco Certification
- Full-Stack Development Cert.
- Python Programming Cert.
- ComPTIA Core Certifications.
- ComPTIA Infrastructure Cert.
- ComPTIA Cyber Security Certifications
- ComPTIA Career Advancement Program Certifications
- Java Certification
- JavaScript Certification
- Digital Marketing Certification
- Data Analysis Certification
- Power BI Certification
- Digital Project Management Crtification
- Tableau Certification
- Digital Proficiency Odyssey
- ICT Fundamentals
- Cisco
- Full-Stack Programming
- ComPTIA Career Advancement
- ComPTIA-Core Certifications
- ComPTIA-Cyber Security Cert.
- ComPTIA
- ComPTIA-Infrastructure. Cert.
- Java
- Digital Insights
- …
- ICT Training Hub
- Digital Proficiency Cert.
- ICT Fundamentals Cert.
- MOS Excel Cert.
- IC3 Digital Literacy Cert.
- Cisco Certification
- Full-Stack Development Cert.
- Python Programming Cert.
- ComPTIA Core Certifications.
- ComPTIA Infrastructure Cert.
- ComPTIA Cyber Security Certifications
- ComPTIA Career Advancement Program Certifications
- Java Certification
- JavaScript Certification
- Digital Marketing Certification
- Data Analysis Certification
- Power BI Certification
- Digital Project Management Crtification
- Tableau Certification
- Digital Proficiency Odyssey
- ICT Fundamentals
- Cisco
- Full-Stack Programming
- ComPTIA Career Advancement
- ComPTIA-Core Certifications
- ComPTIA-Cyber Security Cert.
- ComPTIA
- ComPTIA-Infrastructure. Cert.
- Java
- Digital Insights
Microsoft Office Specialist (MOS) - Excel Associate (Level 1), Excel Expert (Level 2) and Excel Master (Level 3)
The Microsoft Office Specialist (MOS) certifications for Excel are distinguished into three levels - Excel Associate (Level 1), Excel Expert (Level 2), and Excel Master (Level 3). Excel Associate is designed for individuals with foundational skills in Excel, covering basic spreadsheet functionalities such as data entry, formatting, and basic formulas. Excel Expert, at Level 2, delves into more advanced topics, including complex functions, data analysis, and proficiency in using PivotTables and PivotCharts. Excel Master, the highest level at Level 3, represents a comprehensive mastery of Excel, encompassing advanced data analysis, intricate formula construction, and the ability to create intricate dashboards.
The professional exams associated with these levels are Exam MO-200 for Excel Associate, Exam MO-201 for Excel Expert, and achieving both Exam MO-200 and MO-201 for Excel Master, providing individuals with recognized certifications that validate their proficiency in various aspects of Microsoft. These certifications are obtained by taking the professional exams mentioned above from the Microsoft. In addition, Unity International School shall award certificates of proficiency on Excel Associate, Expert and Master upon completion of each level from the Hub.
Microsoft Office Specialist (MOS) -
Excel Associate (Level 1),
Excel Expert (Level 2) and
Excel Master (Level 3)
Below are details for your course of interest;
Course
Microsoft Office Specialist (MOS) -
Excel Associate (Level 1),
Excel Expert (Level 2) and
Excel Master (Level 3)
CourseFee:
N 60,000
Duration:
1 1/2 Months(weekdays)
2 months(weekends)
Order Now
Please Check out our products.
Buy nowMOS - Microsoft Excel Master (Level 3)₦80,000.00₦110,000.00Buy nowMOS - Microsoft Excel Expert (Level 2)₦70,000.00₦100,000.00Buy nowMOS Excel - Microsoft Excel Associate (Level 1)₦60,000.00₦90,000.00Microsoft Office Specialist (MOS) - Excel Associate (Level 1)-Module 1, Excel Expert (Level 2)-Module 2 and Excel Master (Level 3)-Module 3
The Microsoft Office Specialist (MOS) - Excel Associate (Level 1) course covers foundational Excel skills such as navigating the interface, data entry, basic formulas, and formatting. In the Excel Expert (Level 2) course, participants advance to complex formula construction, in-depth data analysis using PivotTables, and mastery of advanced Excel features. The Excel Master (Level 3) course is designed for individuals seeking comprehensive proficiency, covering advanced data visualization, intricate formula scenarios, and the ability to create sophisticated dashboards.
Microsoft Excel Associate (Level 1)
Course Outlines
- Introduction to Excel:
- Overview of spreadsheet software.
- Understanding Excel's interface.
- Navigating workbooks, worksheets, cells, rows, and columns.
- Introduction to Ribbon, Tabs, and Commands.
- Basic Data Entry:
- Entering data into cells.
- Editing and deleting data.
- Using AutoFill for quick data entry.
- Formatting Basics:
- Formatting cells (font, color, alignment).
- Applying cell borders and shading.
- Number formatting (currency, dates, percentages).
- Basic Formulas and Functions:
- Understanding basic mathematical operations.
- Introduction to SUM, AVERAGE, MIN, and MAX functions.
- Managing Worksheets:
- Inserting, deleting, and renaming worksheets.
- Moving and copying worksheets.
- Grouping and ungrouping worksheets.
- Basic Charts and Graphs:
- Creating simple charts (bar, pie, line).
- Formatting and customizing charts.
- Adding titles and labels to charts.
- Introduction to Data Analysis:
- Sorting data in Excel.
- Filtering data using AutoFilter.
- Introduction to basic data analysis tools.
- Printing and Page Layout:
- Setting up page layout and orientation.
- Printing worksheets and workbooks.
- Basic Data Protection:
- Introduction to protecting worksheets and workbooks.
- Setting passwords for workbook protection.
- Practical Exercises and Projects:
- Hands-on exercises to reinforce learning.
- Small projects to apply Excel skills in real-world scenarios.
Microsoft Excel Expert (Level 2)
- Course Outlines
- Advanced Formulas and Functions:
- Nested functions and formulas.
- Working with logical functions (IF, AND, OR).
- Lookup functions (VLOOKUP, HLOOKUP, INDEX, MATCH).
- Data Validation:
- Setting up data validation rules.
- Creating drop-down lists for data entry.
- Advanced Data Analysis:
- PivotTables and PivotCharts.
- Slicers for easy data filtering.
- Grouping and outlining data.
- Advanced Charting Techniques:
- Dynamic charts and data ranges.
- Trendlines and sparklines.
- Customizing chart elements.
- Data Consolidation:
- Consolidating data from multiple worksheets.
- Using 3D references.
- Working with External Data:
- Importing data from external sources (text files, databases).
- Linking and updating external data.
- Advanced Data Formatting:
- Custom number formats.
- Conditional formatting with formulas.
- Creating and modifying cell styles.
- Advanced Worksheet Management:
- Cell referencing (absolute, relative, mixed).
- Naming cells and ranges.
- Using the Watch Window for monitoring cells.
- Macros and Automation:
- Introduction to macros.
- Recording and running simple macros.
- Introduction to VBA (Visual Basic for Applications).
- Advanced Data Protection and Security:
- Advanced workbook and worksheet protection.
- Sharing and tracking changes in a workbook.
- Advanced Practical Exercises:
- Hands-on exercises with real-world scenarios.
Projects to apply intermediate Excel skills.
Microsoft Exvel Master (Level 3)
- Advanced Formulas and Functions:
- Array formulas and functions.
- Using the IFERROR and IFNA functions.
- Advanced lookup functions (INDEX-MATCH combination).
- Advanced PivotTable Techniques:
- Calculated fields and items.
- Using Power Pivot for data modeling.
- Connecting to external data sources.
- Advanced Data Analysis Tools:
- Goal Seek and Solver for optimization.
- Scenario Manager for managing multiple scenarios.
- Analysis ToolPak for statistical analysis.
- Dashboard Creation:
- Design principles for effective dashboards.
- Advanced charting for dashboards.
- Using form controls and interactivity.
- Data Visualization Techniques:
- Advanced chart types (radar, bubble, heat map).
- Customizing chart elements for visual impact.
- 3D mapping and geographical visualization.
- Advanced Data Cleaning and Transformation:
- Text-to-columns and Flash Fill techniques.
- Cleaning and transforming data using Power Query.
- Unpivot and pivot data for analysis.
- Power BI Integration:
- Introduction to Power BI.
- Exporting data to Power BI for advanced visualization.
- Creating interactive dashboards.
- Collaboration and Review:
- Advanced features for collaboration.
- Comments and annotations.
- Track Changes and version control.
- Excel Automation with VBA:
- Advanced VBA programming concepts.
- User-defined functions (UDFs).
- Automation of repetitive tasks.
- Advanced Data Protection and Security:
- Digital signatures and encryption.
- Workbook-level security settings.
- Protecting sensitive information.
- Project Work and Case Studies:
- Complex projects simulating real-world scenarios.
- Case studies applying advanced Excel skills
© 2019. Proudly built by UIS.