Teacher: Saad Nadeem

Status: Enrollment Open

Fee/Duration: 5,000 (10 Days)


Course Overview

This course starts from where Excel Intermediate level ends. It covers a variety of topics in Excel, from intermediate to advance. You will learn various Excel features, tips for creating easy-to-read and correct formulas, a series of useful data analysis tools, importing external data into Excel, and tools to make your spreadsheets more professional.

This is an interactive course will consist of live session, recorded lectures, quizzes, assignments, discussion and 24/7 access to the teachers. Student will also have round the clock access to all recordings so to clear any concept they are not able to able to understand. This course is designed for all excel competent users who want to become "expert users".

The following topics and areas will be covered in this course:

  • Overview of basic excel
  1. Customizing common options
  2. Absolute and relative cells
  3. Protecting and un-protecting worksheets & cells

  • Working with functions
  1. Writing conditional expressions (using IF)
  2. Using logical functions (AND, OR, NOT)
  3. Using lookup and reference functions (VLOOKUP, HLOOKUP, MATCH, INDEX)
  4. VlookUP with exact match, approximate match
  5. Nested VlookUP with exact match
  6. VlookUP with tables, dynamic ranges
  7. Nested VlookUP with exact match
  8. Using VLookUP to consolidate data from multiple sheets
  • Data validation
  1. Specifying a valid range of values for a cell
  2. Specifying a list of valid values for a cell
  3. Specifying custom validations based on formula for a cell
  • Working with templates
  1. Designing the structure of a template
  2. Using templates for standardization of worksheet

  • Sorting & filtering data
  1. Sorting tables
  2. Using multiple-level sorting
  3. Using custom sorting
  4. Filtering data for selected view (AutoFilter)
  5. Using advanced filter options

  • Working with reports
  1. Creating subtotals
  2. Multiple-level subtotals
  3. Creating pivot tables
  4. Formatting and customizing pivot tables
  5. Using advanced options of pivot tables
  6. Pivot charts
  7. Consolidating data from multiple sheets and files using Pivot tables
  8. Using external data sources
  9. Viewing subtotal under pivot

  • More functions
  1. Date and time functions
  2. Text functions
  3. Database functions
  4. Power Functions (CountIf, CountIFS, SumIF, SumIfS)

  • Formatting
  1. Using auto formatting option for worksheets
  2. Using conditional formatting option for rows, columns and cells

  • Macros
  1. Relative & absolute macros
  2. Editing macro's

  • WhatIF analysis
  1. Goal seek
  2. Data tables
  3. Scenario manager

  • Charts
  1. Using charts
  2. Formatting charts
  3. Using bar and line chart together
  4. Sharing charts with PowerPoint / MS Word, dynamically


About The Teacher

Mr. Saad Nadeem is a qualified ACCA, BSc (Accounting and Finance UK) and a Certified MS Office Specialist, Associate Certified Financial Accountant, having more than 8 years of diversified industry exposure. He has been associated the industry as specialist practitioner, trainer and consultant. Saad is associated with SKANS School Of Accountancy and KBM Training & Recruitment as Professional Trainer. He has been involved in corporate trainings, workshops, and seminars for MS Outlook, MS Office Data Analysis, and Dashboard Reporting, Microsoft Office Spreadsheets Techniques, Advanced Charting Techniques and Advanced Reports Development. He is an expert in MS Outlook, MS Word and Advanced Microsoft Office building Financial Modeling using Microsoft Office Dynamic Dashboards in Microsoft Office.


How to Register for this Course

  • Create a new account --> http://www.tutocademy.com/login/signup.php?
  • Activate your account via the email sent to your specified email address
  • Deposit payment via one of the methods --> http://bit.ly/2uuWWlC
  • Share proof of payment by send the copy of the payment slip to contact@tutocademy.com
  • Our team will verify you payment details and give you access to the course
  • For any queries, please contact 0343-3783377

courseimage

Teacher: Saad Nadeem

Status: Enrollment Open

Fee/Duration: 3,000 (5 Days)


Course Overview

In this modern world most businesses survival rest on the manipulation and analysis of data and majority of them uses Excel to achieve this. Having known its computing power and capabilities Excel is still the most underutilized tool. Majority of people uses Excel basic functions and use it for nothing more than a spreadsheet for simple bookkeeping. They also know that a lot more can be achieved with this program and its true understanding can yield truly fantastic results for any business in general and data analysis in particular. This Excel training course can help the business and finance user to become smart workers and use this program’s potential to enhance their productivity, efficiency and job enrichment

This is an interactive course will consist of live session, recorded lectures, quizzes, assignments, discussion and 24/7 access to the teachers. Student will also have round the clock access to all recordings so to clear any concept they are not able to able to understand. This course is designed for beginners to intermediate level candidates who want to learn and implement MS Excel.

The following topics and areas will be covered in this course:

  • Knowledge of worksheet (creating multiple sheets and navigating)
  • Printing and exporting to multiple file extensions
  • Layouts (freezing, splitting panes, themes, backgrounds)
  • Data basics (entering data, fill handle, flash fill)
  • Undo & redo, find & replacing data, data validation
  • Formatting (changing cell, font, border, merging & wrapping cells)
  • Alignment, format painter
  • Basic formulas & functions (Sum, Avg, Count, If, SumIF functions)
  • Max & Min functions, cell grouping, etc
  • Tables (creating tables, tables sorting, table filters, etc)
  • Basic graphs
  • Using smart short keys
  • Data filtering techniques
  • Introduction to basics of IF condition
  • Graphical objects (smart art, shapes, screenshots, pictures)
  • Advanced formatting (built in conditional formatting, custom conditional formatting, comments)
  • Security (workbook protection & locking/hiding cells, cell protection)
  • Advanced navigation & handling (Useful shortcuts, hyperlinks, quick analysis)
  • Introduction to intermediate concepts (data & What IF analysis, pivot table)
  • Advanced functions & external data, excel tool development


About The Teacher

Mr. Saad Nadeem is a qualified ACCA, BSc (Accounting and Finance UK) and a Certified MS Office Specialist, Associate Certified Financial Accountant, having more than 8 years of diversified industry exposure. He has been associated the industry as specialist practitioner, trainer and consultant. Saad is associated with SKANS School Of Accountancy and KBM Training & Recruitment as Professional Trainer. He has been involved in corporate trainings, workshops, and seminars for MS Outlook, MS Office Data Analysis, and Dashboard Reporting, Microsoft Office Spreadsheets Techniques, Advanced Charting Techniques and Advanced Reports Development. He is an expert in MS Outlook, MS Word and Advanced Microsoft Office building Financial Modeling using Microsoft Office Dynamic Dashboards in Microsoft Office.


How to Register for this Course

  • Create a new account --> http://www.tutocademy.com/login/signup.php?
  • Activate your account via the email sent to your specified email address
  • Deposit payment via one of the methods --> http://bit.ly/2uuWWlC
  • Share proof of payment by send the copy of the payment slip to contact@tutocademy.com
  • Our team will verify you payment details and give you access to the course
  • For any queries, please contact 0343-3783377

courseimage

Teacher: Zain-ul-Abideen

Status: Enrollment Open

Fee/Duration: 30,000 (2 Month)


Course Overview

SAP Business One is an affordable, small & medium business software management application that helps you run your entire business, including financials, sales, customer relationship management (CRM), inventory management, and operations, all in a single system. In Pakistan, there are over 400 organizations which are currently using SAP Business One, so learning SAP adds a power skill-set to the toolbox of an individual which can help excel their career. 

This course is designed to provide a thorough understanding of SAP Business, one of the leading Enterprise Resource Planner (ERP). The idea is to give a comprehensive training with hands on experience in terms of practical usage. This is a LIVE course meaning that live session will be conducted 3 days week and afterwards students will have access to the recordings of those session. Students will also have access to the literature and will have the opportunity to interact with other participants as well as reach out directly to the teacher.


Who is This Course For?

This course is designed for individuals currently working or aspiring to work in the corporate sector in areas of finance, IT, technical and operations. Ideal for students looking to enter the job market and especially those looking to work abroad.


Course Aim

This course aims to provide the thorough understanding & training of world leading ERP Software for Small & Medium Enterprises (SMEs) i.e. SAP Business One.


Course Objective & Topics

The courses focused on covering following modules

  • Administration (Company Creation, Company setups, Initialization, Approval Procedures, Alerts Management etc.)
  • Financial (Chart of Accounts, Fixed Assets, Journal Entry, Journal Voucher etc.)
  • Sales Opportunities (Customer Relationship Management)
  • Sales A/R (Order to Cash process, Dunning Process, Sales Invoices etc.)
  • Purchase A/P (Procure to Pay Process, Purchase Invoices etc.)
  • Business Partners (Customer, Vendor & Lead data & Configuration)
  • Banking (Incoming & Outgoing Payments, Bank Reconciliation, Deposits, Bad debts etc.)
  • Inventory (Inventory Management, Warehouse Management, Bin Location, Pricing, Pick & Pack Manager, Unit of Measures (UOM), Serial & Batch Management, Bin Location etc.)
  • Production (Bill of Material, Production Process, Backflush Accounting)
  • Resources (Resource Management & Its Integration with Production Process)
  • Human Resources (Employee master Data, Attendance, Employee Probation, Employee Financials etc.)
  • Services (After sales services related to sold items based on Serial Number Management etc.)
  • Reports (Reports related to all above mentioned modules)


Course Procedure

  • Reading material/resources will be uploaded for learners. Recorded lectures will be accessible to learners through their online portals.

  • Assessment will be through activities, assignments and quiz
  • Live training session to be conducted 3 days a week
  • Lecture recording will be available after live session ends
  • Peer discussion and learning is encouraged through the online portal.
  • During the course weeks, participants have direct access to the trainer 24/7 for discussion and chat through online portal.


About The Teacher

Zain-ul-Abideen is a multi-skilled and solution oriented SAP and Excel trainer with good all-round functional expertise. He has the ability to identify the client needs and suggest suitable solution. Having hands on experience of configuring SAP Business One in business environment, he is able better educate participants in terms of practical scenarios.


How to Enroll into This Course?

  • Create a new account --> http://www.tutocademy.com/login/signup.php?
  • Activate your account via the email sent to your specified email address
  • Deposit payment via one of the methods --> http://bit.ly/2uuWWlC
  • Share proof of payment by send the copy of the payment slip to info@tutocademy.com
  • Our team will verify you payment details and give you access to the course
  • For any queries, please contact 0343-3783377

courseimage

Teacher: Omer Farooq

Status: Enrollment Open 

Fee/Duration: 20,000 (2 Mth)


Introduction

The Retail Store Operations (Job Placement Course)  is focused on helping the participants identify, practice, and develop the skills they need to improve the quality of their store operations, reduce expenses, and improve operating profit. This is 2 month certificate program where the passing candidate will get a job offer letter at the completion of the program (however he/she will be required to complete on-job training for 2 months)

The certificate program is designed to educate the participants on broad spectrum of activities, from basic concepts to selling skills, visual merchandising, customer service, stock management and cash management. This is an interactive course, where students will have access to series of lectures, readings, activities and tasks that will be required to be completed in order to qualify for a completion certificate. Participant will also be required to attend physical training sessions at different locations across Pakistan (locations will be shared before the training session).


Who is This Course For?

This course is designed for the individuals who are either currently looking to start a career in retail sector or who are currently working in the retail sector and looking to move to a better organization.


Course Aim

The aim of this course is to go give individuals a thorough understanding of the retail store operation functions and what key areas one needs to focus on to generate results. This course not only focuses on academic part but also requires individuals to practically demonstrate those concept in real life environment through activities which will be conducted on retail stores. So in a nutshell, this course is a good blend of theory and practice to develop skill-set for individuals to enter and excel in the retail sector of Pakistan. 


Course Objective & Topics

The course will cover Module will cover following areas:

  • Basic Concepts in Retail Store Operations - Introduction to retail store management. Basic abbreviations and definitions. What are the responsibilities of retail store manager. Understanding retail store, retail store property management, retail store operations, retail staff management, retail store stock management, retail store sales management.
  • Selling Skills - This segment is designed for the retail store mangers to understand and train the sales team to operate on retail floor. The selling process will help participants to understand the selling transaction process and skills required to improve these steps. The participants will also learn which actions/behaviors should be avoided to present good selling experience to the customer.
  • Visual Merchandising Basics - Basic concepts of visual merchandising, elements of visual merchandising, basic responsibilities of retail store staff with respect of visual merchandising, color keeping, shelve and stock displays, colour theory, basic design fundamentals.
  • Basic Communication Skills for Managers - The communication process, why communication is misunderstood, understanding customer non verbal  messages, understanding the non verbal messages sent to customers. Techniques to improve the verbal communication. Interview skills. Team communication.
  • Customer Services - Basic concepts, what we mean by ‘extra mile’. How to manage expectation. The bounce back strategy. Tough customer handling.
  • Stock Management & Cash Management - Understanding the software (basic training on Candela POS). How to manage stock, stock receiving, stock transfers, stock taking.


Course Procedure

  • Candidate has to deposit Rs 1,000 (non-refundable) fee for test and assessment.
  • Course duration is two months and fee is Rs 20,000 (charged in full after assessment)
  • Please note the location of test carefully. The date and location will not be change, once finalized.
  • Candidate has to qualify (at least 50% marks) for selection.
  • The institute reserves the right not to disclose the assessment criteria.
  • The selected candidates will be given access to the reading material and video support. As soon as the student completes the reading of each module will attempt the assessment.
  • Students will be requested to participate in one day workshop on nearest location mentioned in their registration form.
  • After successful completion, a two months internship will be arranged for students to nearest destination mentioned in their application form. This might follow a permanent job by the same organization.
  • Rs 10,000 will be paid as stipend during the internship.
  • After successful completion of internship students will be given certificate.
  • INSTITUTE DOES NOT GUARANTEE A PERMANENT JOB ASSOCIATED TO THIS PROGRAM.


About The Trainer

Mr Omer Farooq, the COO of Institute of Retails Studies, is a highly qualified professional retail consultant and trainer with over 20 years of experience working with leading high-end fashion brands and huge retails setups. He has held lead roles inside and outside the country driving the quality and customer standards as per the envisioned international best practices. He has deep retail experience in operations, distribution & warehousing, brand management, training & development.


How to Enroll into This Course?

  • Create a new account --> http://www.tutocademy.com/login/signup.php?
  • Activate your account via the email sent to your specified email address
  • Deposit payment via one of the methods --> http://bit.ly/2uuWWlC
  • Share proof of payment by send the copy of the payment slip to info@tutocademy.com
  • Our team will verify you payment details and give you access to the course
  • For any queries, please contact 0343-3783377

courseimage

Teacher: Umair Tariq / Dr Arif Malik

Status: Enrollment Open

Fee/Duration: Free (Unlimited)


Course Overview

This course is designed to to give an extensive overview to the teacher who will be teaching different courses on our platform. The course is a step wise introduction and explanation on the different modules and functionalities offered by www.TutoCademy.com. Essentially teacher will have access to video tutorials on how to setup a course, setup, create content on the platform and use the different reporting tools that give the teacher effective learning and evaluation methods. As this is an interactive course, this will comprise of a series of recorded lectures along with different contents which the teacher will learn to use in his/her courses. The course also has the option of interaction with the teacher via discussion forums, chats sessions or direct message to address any query that needs to be clarified.


About The Teacher

Umair Tariq is the one of the founders of this project and will be taking you through a step by step training tutorial of this platform (www.TutoCademy.com). The objective is give a common platform to all those who will be teaching on this website.

courseimage