Microsoft Office 2021/365 Essentials Bundle

Master Microsoft Office: Excel, PowerPoint, Word & Outlook 2021 - Complete Bundle

Unlock your full potential with this comprehensive Microsoft Office bundle! Designed for both beginners and intermediate users, this five-course bundle from Simon Sez IT provides in-depth training in the essential MS Office programs: Excel 2021, PowerPoint 2021, Word 2021, and Outlook 2021. Become a more productive and confident user of these powerful tools.

Why This Bundle?

Microsoft Office is a cornerstone of the modern workplace, but many users only scratch the surface of its capabilities. This bundle simplifies complex features, empowering you to achieve your goals. Each course is packed with practical exercises and downloadable resources to ensure you gain hands-on experience.

What You'll Learn:

Excel 2021: From Beginner to Intermediate

• Excel 2021 for Beginners:
  • Navigate the new Excel 2021 interface with ease.
  • Master essential keyboard shortcuts for increased efficiency.
  • Create and format Excel spreadsheets.
  • Utilize basic and intermediate Excel formulas and functions.
  • Apply conditional formatting for data visualization.
  • Effectively use Excel lists with sorting and filtering.
  • Manage data with cut, copy, and paste operations.
  • Link worksheets and workbooks for seamless data flow.
  • Analyze data using charts and insert images.
  • Customize page layout and print options.
  • Protect and share your workbooks.
  • Save in various file formats.
• Excel 2021 Intermediate:
  • Design sophisticated spreadsheets with user input control.
  • Employ logical functions for informed business decisions.
  • Construct powerful lookup formulas and utilize Excel tables.
  • Extract unique data values and utilize advanced sorting and filtering.
  • Work with date and time functions and text functions.
  • Import and clean data for accurate analysis.
  • Create interactive PivotTables and PivotCharts.
  • Build dynamic dashboards for key metrics.
  • Audit formulas and troubleshoot common errors.
  • Implement data validation for controlled user input.
  • Utilize What-If analysis to model scenarios.

PowerPoint 2021: Create Engaging Presentations

• Create visually compelling PowerPoint presentations that adhere to best practices.
• Access and utilize a library of free, high-quality resources (images, icons, fonts, videos).
• Boost efficiency with keyboard shortcuts and the Quick Access Toolbar.
• Open, save, and manage presentations.
• Apply slide layouts and duplicate/arrange slides.
• Work with various media types: images, icons, video, text, shapes, and audio.
• Master object alignment and grouping.
• Add engaging animations and transitions.
• Create dynamic summary pages and slide zoom.
• Insert and edit charts, diagrams, and tables.
• Add hyperlinks to internal and external resources.
• Incorporate third-party add-ins.
• Prepare for delivery with speaker notes, headers, footers, and comments.
• Set up custom slide shows and rehearse timings.
• Utilize Presenter View for enhanced delivery.
• Export, share, and print presentations.

Word 2021: Professional Document Creation

• Navigate the Word 2021 interface with ease.
• Customize the Quick Access Toolbar and access Word options.
• Create documents from scratch or templates.
• Format text, paragraphs, and documents using various tools.
• Utilize cut, copy, paste, and advanced pasting options.
• Employ find and replace for efficient text manipulation.
• Apply themes and styles for consistent formatting.
• Insert various content types: shapes, icons, text boxes, 3D images, SmartArt, and charts.
• Organize information using tables.
• Adjust margins, orientation, and insert page breaks.
• Insert headers and footers.
• Create hyperlinks and bookmarks.
• Generate Quick Parts for reusable content.
• Create a table of contents, footnotes, endnotes, and a bibliography.