Microsoft Access and Microsoft Excel Mastery Bundle 2016

Unlock the Power of Data: Master Access & Excel for Business Decisions

Transform raw data into actionable insights with this comprehensive 4-course bundle designed to elevate your skills in both Microsoft Access and Excel. Perfect for anyone needing to manage and analyze large datasets to drive better business outcomes. You'll gain lifetime access to these in-depth video tutorials and practice exercises.

Access 2016: From Beginner to Advanced

This course takes you from the fundamentals of Access 2016 to advanced database management.

• Access 2016 Basics:

  • Understand the new features in Access 2016.
  • Learn to add, save, and delete data efficiently.
  • Set up both desktop and web databases.
  • Navigate the Ribbon interface and utilize touch device functionality.
  • Create and manage forms and sub-forms for streamlined data entry.
  • Sort data and run powerful queries.
  • Utilize macros to automate tasks.
  • Import data from external sources.

• Access 2016 Advanced:

  • Link to external data sources effectively.
  • Split databases for optimal performance (frontend/backend).
  • Package your application for distribution.
  • Create, update, and maintain macros.
  • Explore the power of Visual Basic for Applications (VBA).
  • Master advanced form and query options.

Excel 2016: Boost Your Data Analysis

This course equips you with the skills to leverage Excel 2016 for sophisticated data analysis and visualization.

• Excel 2016 Basics:

  • Get started with workbooks using mouse and touch devices.
  • Explore new and improved features in Excel 2016.
  • Create sophisticated charts and graphs with custom visuals.
  • Personalize your Excel experience.
  • Use autofill and flash fill for rapid data entry.
  • Apply themes and cell styles for professional presentations.
  • Implement backup and recovery methods for Excel spreadsheets.
  • Format dates and numbers effectively.

• Excel 2016 Advanced:

  • Create advanced charts and graphs.
  • Utilize lookup and advanced lookup functions.
  • Apply financial functions (interest, depreciation).
  • Leverage statistical functions.
  • Connect to external workbooks and datasets (e.g., Access, web).
  • Create compelling visualizations with sparklines and data bars.
  • Master PivotTables and Pivot Charts.
  • Employ Scenario Manager, Goal Seek, and Solver for data analysis.
  • Create advanced chart types (Surface, Radar, Bubble, Stock).

What's Included:

• 4 comprehensive courses: Excel & Access 2016
• 36 hours of video tutorials
• 240+ individual video lectures
• Exercise files for hands-on practice
• Demo files used by the trainer
• Certificate of Completion

What Students Are Saying:

"I was able to pick up Access very quickly with this video course. The course flowed very nicely and started with the very basic information first before moving on to more complicated tasks." - Greg Wehner

"I feel that I master the basics, but also all the little details very useful that simplifies life." - Gabriel Beaulieu

"Brilliant. Enjoyed it immensely. Learned everything I needed to know." - Brenda Bell

Explore More from Simon Sez IT:

Simon Sez IT offers a wide range of software training, including: Microsoft Excel, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Microsoft Outlook, QuickBooks, Photoshop Elements, Web Development Languages, and more!