Officeshortcuts

OfficeshortcutsOfficeshortcutsOfficeshortcuts
  • Home
  • My Story
  • Word
  • Excel and Sage 50
  • Cyber Power
  • Pro Tips
  • Attila farkas
  • Contact Us
  • More
    • Home
    • My Story
    • Word
    • Excel and Sage 50
    • Cyber Power
    • Pro Tips
    • Attila farkas
    • Contact Us

Officeshortcuts

OfficeshortcutsOfficeshortcutsOfficeshortcuts
  • Home
  • My Story
  • Word
  • Excel and Sage 50
  • Cyber Power
  • Pro Tips
  • Attila farkas
  • Contact Us

Sage 50 and Excel Perfect together

Welcome

Sage 50 and Microsoft Excel compliment each other in the complex and challenging world of accounting. You will find two videos on this page that will introduce you to basic navigation methods in Sage 50 and also show you the must-know features of importing and exporting data. Let's start our accounting adventure with these two videos. Please leave a comment and let me know if you have learned anything new or useful from the videos and suggest topics for future videos.

Video

Sage 50 navigation

Gigi is planning something dark and sinister...

Sage 50 Export and import

Export and import and what can go wrong...

Seven Ways Excel is Better than Google Sheets

 

Microsoft Excel: Advantages and Exercises


 Seven Ways Excel is Better than Google Sheets

1. Power Query for Data Analysis

  • Example: Automate the process of importing, cleaning, and transforming data from multiple sources.
  • Exercise: Use Power Query to import data from a CSV file, clean up missing values, and merge it with another data source.

2. PivotTables for Advanced Data Summarization

  • Example: Create interactive data summaries and analyses.
  • Exercise: Generate a PivotTable from sales data to summarize total sales by region and product category.

3. Data Analysis ToolPak

  • Example: Perform complex statistical analysis using built-in tools.
  • Exercise: Use the Data Analysis ToolPak to run a regression analysis on a dataset and interpret the output.

4. Advanced Charting Options

  • Example: Create detailed and customizable charts, including combo charts and waterfall charts.
  • Exercise: Create a combo chart that combines a column chart with a line chart to visualize sales data and growth trends.

5. VBA (Visual Basic for Applications) for Automation

  • Example: Automate repetitive tasks and create custom functions.
  • Exercise: Write a VBA script that automatically formats a report, applying consistent styles and generating summary statistics.

6. Power Pivot for Data Modeling

  • Example: Create complex data models and relationships between large datasets.
  • Exercise: Use Power Pivot to create a data model that integrates multiple tables and build a report using this model.

7. What-If Analysis Tools

  • Example: Use Scenario Manager, Goal Seek, and Data Tables to perform sensitivity analysis.
  • Exercise: Use Goal Seek to determine the required sales to achieve a target profit, then use Scenario Manager to analyze different business scenarios. 

Site Content

An Excel worksheet that will reward your kids when they clean their room.

Excel Training

Multimillion dollar companies struggle with Excel spreadsheets and are looking for solutions. How do I know this? I'm helping those companies find solutions. 

What will you learn?

You'll discover how to use an IF function that can play music to persuade your children to tidy up their rooms. You will discover how to quickly analyze 10,000 numbers and how to reduce costs for both your business and yourself.

Testimonials

"I want to thank you for making my return to school experience so rewarding and memorable! Cheers to the most compassionate, sincere, and knowledgeable teacher there is! "Who knows what I could have accomplished if I had you in high school?” Marnie Newbery 


I have had many teachers over my academic career, and while I remember almost all of them, none stand out quite as much as Attila Farkas. I met Attila in 2015, when I was enrolled in the Medical Office Administrator program at CTS—Canadian Career College in Barrie, Ontario. Attila genuinely cares about the people he teaches and sees them as people, not just students or numbers. "Any person who has him as an instructor, even if only for one course, should count themselves among the luckiest people in the world.”Sarah Mueller  

Customized Training Packages

If you tell me the top twenty things you want to learn, I'll make a video for you that is enjoyable and educational that you can watch step-by-step.

Keywords: Microsoft Excel, spreadsheet software, tips, tricks, expert-led, easy-to-follow, educational videos.

The subjects covered by the educational videos include:

  • Basic and advanced formulas
  • Pivot Tables
  • Charts and graphs
  • Data analysis and visualization
  • Macro programming
  • Automation techniques
  • And much more!

Small businesses and individuals: Upgrade your skills and take control of your data with my comprehensive guide to Microsoft Excel!


Copyright © 2025 Office Shortcuts - All Rights Reserved.

Powered by

This website uses cookies.

We use cookies to analyze website traffic and optimize your website experience. By accepting our use of cookies, your data will be aggregated with all other user data.

DeclineAccept