Project Description

Overview

At SOPS, we offer you the best MS Excel training and SAGE-50 (Peachtree) accounting software as add-on to the course. Among the computer programs which exist, Microsoft Excel is one of the most important because of the key role it plays in many sectors. SAGE-50 is a highly suitable and versatile accounting solution for SMBs and being used across a wide cross-section of professionals including bookkeepers, accountants and financial managers.

KEY POINTS

  • ADVANCED MS EXCEL SAGE-50
  • Sorting and Filtering
  • Setting-up a Company
  • Text to Columns
  • Design a Chart of Accounts
  • Conditional Formatting
  • Vendor & Customer
  • Paste Special Option Management
  • Data Validation & Protection
  • Inventory & Services
  • Consolidation Data & List Management Management
  • Pivot Table Creation & Modification
  • Employees & Payroll
  • Advanced Charting & Dashboard Reports Management
  • What-If-Analysis
  • Report Customization
  • Introduction to Visual Basic and Macros
Bilal Tufail
Bilal TufailCourse Tutor
Bilal Tufail is an accounting professional, who has been in career for over 8 years now. He worked as Project accountant for Weatherford Oil & Tool, Middle East over several billion-dollar projects. He has developed advanced skills-set in various software’s, one of them is Microsoft Excel that plays a vital role in performing formula-based arithmetic’s and calculations which suits to any business nature in organizing their financial data.
Register Now