Quickbooks Online & Microsoft Excel Combo Pack Course

QuickBooks Online Video Course: Master Your Business Finances

Learn QuickBooks Online inside and out with this comprehensive video course! No software installation required – take advantage of the free 30-day trial available to US users. If you're in the US, you can also utilize the free version of QuickBooks Accountant.

This step-by-step training provides absolutely clear instructions to navigate every section of QBO. We'll walk through the complete setup process together. You'll gain expertise in:

• Common Transactions: Learn to enter all the essential transaction types for your business.
• Report Management: Master the management and customization of crucial QBO reports.
• Data Entry & Error Correction: Find and fix data entry errors and easily locate any information within your QuickBooks Online account.
• Real-World Projects & Tests: Apply your knowledge to practical scenarios and master QuickBooks Online through hands-on experience.
• Industry-Specific Tasks: Discover how to apply QuickBooks Online to your specific industry.

This course covers the transactions businesses need daily, including:

• Customer Invoicing: Create and manage customer invoices.
• Receipt Management: Record and track business receipts.
• Payment Processing: Manage customer payments.
• Banking & Deposits: Handle deposits and banking transactions within QuickBooks Online.
• Accounts Payable: Enter and manage bills payable.
• Bill Payment: Pay bills efficiently using QuickBooks Online.
• Petty Cash & Refunds: Process petty cash transactions and customer refunds.

Benefit from QuickBooks tips and tricks to gain complete control over your QuickBooks Online entries. Become proficient in the main features of QuickBooks Online and streamline your financial management.

Need help? I'm here to answer your questions and provide support. I hope you enjoy the course!

---

Boost Your Data Analysis Skills with Microsoft Excel Essentials

Ready to unlock the power of Microsoft Excel? This course provides a structured learning path for Excel beginners and those looking to solidify their skills. Developed with 15 years of experience in finance and project management, this course focuses on the most common Excel problems professionals face. I've included hidden tips and tricks – including those learned as an Excel MVP – to help you work faster and more efficiently.

This practical course will help you understand the full potential of each Excel function and use Excel for fast and painless data analysis. You'll learn to leverage powerful Excel formulas and functions to automate your work and achieve more in less time.

What you'll learn:

• Data Entry & Navigation: Efficiently enter data and navigate large tables.
• Excel Hacks: Apply time-saving techniques to accelerate your workflow.
• Formula Mastery: Choose the right Excel formula (VLOOKUP, IF function, ROUND, etc.) to automate data analysis.
• Hidden Features: Utilize Excel's hidden features to transform cluttered data into clear insights.
• Data Analysis & Reporting: Extract answers from your data, organize and clean big data, and create attractive Excel reports using spreadsheet design principles.
• Data Visualization: Transform cluttered data into useful charts.
• Interactive Reporting: Create interactive reports with Excel pivot tables, pivot charts, slicers, and timelines.
• Data Transformation: Import and transform data using Get & Transform (Power Query).

Course Topics:

• Excel Basics: A solid foundation for all future learning.
• Advanced Topics: Explore conditional formatting, Excel spreadsheets, and Power Query.
• Key Formulas: Master essential formulas like VLOOKUP, SUMIFS, and nested IF functions.

Each topic includes practical examples and challenges to test your skills. Downloadable PDF notes provide key takeaways for quick reference.

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

• Enter data and navigate large tables
• Apply hacks in Excel to get work done faster
• Choose the right Excel formula to automate your data analysis (Excel VLOOKUP, IF function, ROUND, etc.)
• Use Excel's hidden features to turn cluttered data into precise notes
• Get answers from your data
• Organize, clean and manage big data
• Create attractive Excel reports following a number of spreadsheet design principles
• Turn cluttered data into useful charts
• Create interactive reports with Excel pivot tables, pivot charts, slicers, and timelines
• Import and transform data using tools like Get & Transform