MS Office; Excel, Word, Access & PowerPoint 2019 - Beginners

Master Microsoft Office: Excel, PowerPoint, Word & Access 2019 – Unlock your productivity potential with this comprehensive 4-course bundle from Office experts Simon Sez IT. Learn essential skills in Excel, PowerPoint, Word, and Access 2019, the core programs for modern professionals. This Microsoft Office Beginners bundle is designed to make these powerful tools easy to understand, regardless of your current skill level.

What You'll Learn:

Excel 2019:

• Data Management: Creating workbooks, entering and formatting text, numbers, and dates.
• Navigation & Organization: Mastering workbook navigation, page setup, and working with rows, columns, and cells.
• Formula & Function Mastery: Cut, copy, paste, and learn fundamental Excel formulas and functions, including logical and lookup functions.
• Data Visualization: Creating compelling charts and graphs to analyze data.
• Data Analysis: Sorting, filtering, and utilizing PivotTables for insightful data summaries.
• Formatting: Advanced formatting techniques for cells and numbers.

PowerPoint 2019:

• Presentation Design: Effective presentation dos and don'ts.
• Content Creation: Text and bulleted lists, utilizing graphics, images, objects, and SmartArt.
• Visual Communication: Working with charts and graphs, and leveraging Master Slides for consistent design.
• Multimedia Integration: Adding audio and video to enhance presentations.
• Slide Transitions & Animation: Creating engaging slideshows with transitions, animations, and motion paths.
• Presentation Delivery: Mastering slideshow options and effective presentation preparation.
• PowerPoint Backstage: Printing and utilizing the backstage area.

Word 2019:

• Word Processing Fundamentals: Navigation, editing, and saving documents.
• Text Formatting: Character formatting, the Format Painter, and AutoCorrect.
• Paragraph & List Management: Working with bullets, numbering, and paragraph formatting.
• Table Creation & Manipulation: Formatting tables, converting data, and using formulas.
• Page Layout: Page breaks, watermarks, styles, and sectioning documents.
• Image & Object Insertion: Inserting graphics, pictures, shapes, icons, and 3D models.
• Mail Merge & Labels: Creating envelopes and labels for efficient communication.
• Document Review & Printing: Reviewing, printing, and protecting Word documents.
• Basic Macros: Introduction to automating tasks with macros.

Microsoft Access:

• Access Basics: Getting started with Microsoft Access, including template usage.
• Data Import & Management: Importing data and utilizing the datasheet view.
• Database Relationships: Understanding how tables work and creating relationships between them.
• Form & Query Creation: Building forms and sub-forms to efficiently manage data.
• Querying Data: Running queries to extract specific information.
• Data Validation & Calculations: Setting up validations and calculations using expressions.
• Printing from Access: Printing database information.
• Macros & Web App: Introduction to macros and the Access web app.
• Exporting & Reporting: Exporting data and creating reports.

Course Features:

• Lifetime Access: Enjoy unlimited access to the course materials.
• 29+ Hours of Video Tutorials: In-depth video instruction covering all essential topics.
• 300+ Individual Video Lectures: Easy-to-follow lessons broken down into manageable segments.
• Exercise & Demo Files: Practical files to reinforce your learning.
• Certificate of Completion: Demonstrate your newfound skills.

What Our Students Are Saying:

"Highly recommended this course to everyone. This is the best course I ever had. Good English that we can understand. Superb..... I understood every lesson in the course." - Yunesh Garusinghe
"I really love the way you describe all the things. The language of the instructions were really simple. I really gain a new knowledge and understanding from this course. I am really looking forward to apply this all in my work. Thank you." - Cavin Macwan
"Nervous at first, had no idea how to do or work it. The instructor made it easy to follow along!" - Coreen Teoh

Simon Sez IT also offers courses in:

• Microsoft Excel
• Microsoft PowerPoint
• Microsoft Word
• Microsoft Project
• Microsoft Outlook