MS Office – Hand On Course

This course offers thorough training in Microsoft Office, focusing on essential tools for the accounting and finance industry. Students will gain practical experience with Word, Excel, PowerPoint, and Outlook, optimizing their efficiency and productivity.

Course Modules:

Module 1: Computer Systems

• Understanding basic computer components and operating systems.
• Navigating and setting up Microsoft Office applications.

Module 2: Exploring Microsoft Office Interface

• Familiarizing with the Ribbon interface and key features.
• Customizing the workspace for increased productivity.

Module 3: Working with Data in Excel

• Entering and organizing data effectively.
• Using basic formulas and functions for calculations.

Module 4: Organizing Data

• Structuring data using tables and named ranges.
• Sorting and filtering data for better analysis.

Module 5: Formatting the Data

• Applying formatting styles to enhance readability.
• Using conditional formatting to highlight key information.

Module 6: Performing Calculations

• Utilizing advanced formulas and functions, including VLOOKUP and IF statements.
• Creating and using PivotTables for data summarization.

Module 7: Collaborate and Protect Data

• Sharing and collaborating on documents with others.
• Implementing data protection and security measures.

Module 8: Formatting Documents

• Applying document styles and layouts in Word.
• Creating professional reports and business correspondence.

Module 9: Columns and Tables

• Designing and managing columns for organized data presentation.
• Creating and formatting tables for structured information.

Module 10: References

• Using citation tools and creating bibliographies.
• Managing references and cross-references in documents.

Module 11: Merging Data with Documents

• Performing mail merges for personalized document creation.
• Combining data from multiple sources into a single document.

Module 12: Creating Slides

• Designing and structuring effective PowerPoint presentations.
• Using slide layouts and themes to create visually appealing slides.

Module 13: Insert and Manage Graphics and Charts

• Adding and formatting images and graphics in presentations.
• Creating and customizing charts for data visualization.

Module 14: Animations and Transitions

• Applying animations to enhance slide presentations.
• Using transitions to create smooth slide changes.

Module 15: Useful Keyboard Shortcuts

• Learning essential keyboard shortcuts for improved efficiency.
• Customizing shortcuts to fit personal workflow needs.