MYOB Accounting + Advance Excel Combo Pack Basic to Advance

Master MYOB Bookkeeping & Excel Data Analysis

MYOB Training Course: Essential Bookkeeping Skills

Gain practical skills in managing your business finances with this comprehensive MYOB training course. This course is designed for all levels, particularly beneficial for those with basic accounting skills and small business owners. Learn to confidently create your own company files and handle day-to-day bookkeeping tasks.

What You'll Learn:

• Company File Setup: Learn the process of preparing and organizing your company files within MYOB.
• Day-to-Day Operations: Master managing your business through MYOB, including creating accounts for:
  • Services
  • Inventory
  • Customers
  • Suppliers
• Invoicing & Payments: Create professional invoices, manage both sales and purchases, and handle transfers effectively.
• Order & Payment Management: Learn to place orders, pay invoices, and accurately record sales and payments received.
• Inventory Tracking: Effectively track your inventory levels within MYOB.
• Banking Tasks: Manage all your essential banking tasks within the MYOB platform.
• Advanced MYOB Features: Explore advanced topics such as:
  • Prepayments
  • Write-offs
  • Bad Debts
  • GST Adjustments (Retrievals & Refunds)
• Reporting: Generate various business reports to gain valuable financial insights.

By completing this MYOB online course, you'll gain a clear understanding of how to manage your company finances daily and access the financial information needed for business success.

---

Microsoft Excel Essentials: Data Analysis & Productivity

Unlock the power of Microsoft Excel with this practical course designed for data analysis. Whether you're a beginner or looking to enhance your existing skills, this course covers the most essential Excel skills used by data analysts.

What You'll Discover:

• Excel Fundamentals: A solid foundation in Excel, perfect for beginners.
• Data Entry & Navigation: Efficiently enter and navigate large datasets.
• Formula Mastery: Learn and apply crucial Excel formulas, including:
  • VLOOKUP
  • SUMIFS
  • IF functions
  • ROUND function
• Data Analysis Techniques: Automate data analysis using Excel's powerful functions.
• Hidden Features & Tips: Discover time-saving tips and tricks from an Excel MVP with 15+ years of experience in finance and project management.
• Data Cleaning & Organization: Transform cluttered data into precise and usable information.
• Data Visualization: Create compelling charts and reports to communicate your findings.
• Pivot Tables & Slicers: Master Excel pivot tables, pivot charts, slicers, and timelines for interactive reporting.
• Power Query: Import and transform data using Power Query for efficient data management.
• Conditional Formatting: Enhance data readability and highlight key information.
• Spreadsheet Design: Create professional and visually appealing Excel spreadsheets.

Course Highlights:

• Practical Examples: Understand the full potential of each Excel function through real-world examples.
• Problem-Solving: Learn to solve common Excel challenges faced by professionals.
• Challenges & Exams: Test your skills with integrated challenges and exams.
• Downloadable Resources: Access PDF notes for quick reference.

By the end of this course, you'll be able to:

• Quickly analyze data
• Automate data analysis tasks
• Extract insights from complex datasets
• Create professional Excel reports
• Improve your productivity with Excel