Loading...

News Flash

(WS-704) Workshop on Unlock the Secrets of Sales Tax on Goods in Pakistan (Live Online)
March 26, 2024
10:00 am to 01:00 PM
Live Online through Webinar
For more detail, Click here


Certificate in Taxation Laws (Lahore)
8 Weeks Practical Training Course

Monday & Tuesday - 6 PM to 9 PM
Batch 230th starting from 22nd April
at Softax House, Lawrance Road
Call: 0300-0090835
Click here for more details


Taxation Laws in Pakistan
Annual Package for live online workshops on Taxation Laws in Pakistan

Second Tuesday of Every Month
11:00 AM to 01:00 PM
Call: 0321-5596119
Click here for more details


Certificate in Taxation Laws (Karachi)
8 Weeks Practical Training Course

Thursday & Friday - 6 PM to 9 PM
Batch 228 starting from 25th April
at Gulshan-e-Iqbal Block-8.
Call: 0321-5596119
Click here for more details


Certificate in Taxation Laws (Online Recorded)
8 Weeks Practical Training Course

Join through video lectures on days and time of your choice
Click here for more details


Banks Extend Operations for March 2024 Tax Collection
Pkrevenue
Friday, 29-03-2024, Read more


LTO Karachi Achieves Historic Rs 13 Billion Single Tax Recovery
Pkrevenue
Friday, 29-03-2024, Read more


Illicit Cigarette Manufacturers Exploit Exports Quota to Evade Tax
Pkrevenue
Friday, 29-03-2024, Read more


LCCI says has reservations over FBR’s ‘Tajir Dost’ plan
Business Recorder
Friday, 29-03-2024, Read more


Field formations to remain open on 30th & 31st
Business Recorder
Friday, 29-03-2024, Read more


‘The Federation, in light of Entry 50, cannot tax the capital value of immovable property at all’
Business Recorder
Friday, 29-03-2024, Read more


SPARC urges govt to increase taxes on cigarettes
Business Recorder
Friday, 29-03-2024, Read more


Banks to Observe Extended Working Hours on March 30, 31 for Tax Collection
Propakistani
Friday, 29-03-2024, Read more


Plan underway to digitize tax system: PM Shehbaz Sharif
ARY News
Friday, 29-03-2024, Read more


Old news January 2011 to March 28, 2024
Archived
Click here to view



Register Now  Brouchure
6-Weeks Training Course on ADVANCE EXCEL FOR BUSINESS ANALYSIS (AEBA)
Date August 23, 2017 Fee Rs. 8,495/-
Venue Softax House, 51/A-2, Lawrance Road, Lahore City Lahore

COURSE CONTENTS

1.Introduction to Excel

a.Overview of Excel

b.Excel for Beginners 

2.Excel Formulas

a.Relative & Absolute Cell References

b.Using IF Formula, Nesting IF Formulas

c.COUNTIF, SUMIF Formulas

d.Excel Text Formulas

e.VLOOKUP formula, INDEX, MATCH Formulas

f.Advanced VLOOKUP Tricks Advanced

g.How to Get Unique Values from a List using Formulas Advanced

h.Date Formulas

i.OFFSET Formula Advanced

j.SUMPRODUCT Formula Advanced

k.SUMIFS Formula, COUNTIFS Formula

l.SMALL, LARGE Formulas Advanced

m.ROWS, COLUMNS Formulas

n.Formula Editing Tips and Tricks

o.Formula Debugging/Auditing

3.Excel Formatting

a.Formatting Paste Special

b.Conditional Formatting

4.Charting

a.How to Select Correct Chart

b.Introduction to Excel Charts

c.Chart Formatting – Tips

d.Bar & Column Chart Formatting

e.Advanced Charting in Excel

f.Dynamic Charts

g.Interactive Charts In Excel Advanced

5.Class Project # 1

6.Working with Tables & Pivot Tables

a.Excel Tables

b.Excel Pivot Tables

c.Pivot Table Tricks

7.Data Filters, Sorting & Data Validation

a.Data Filters & Sorting

b.Data Validation

8.Importing External Data, Exporting Excel Workbooks

a.Importing External Data

b.Export Excel to Other Formats

c.Excel Access Integration

9.Advanced Formulas

a.Named Ranges

b.Using Formula Audit Tools

c.3D References (example: consolidate sales data)

d.Array Formulas - What are they? (Example: MAXIF, MINIF)

e.Circular References - What are they?

f.Various Calculation Modes and How to use them.

g.Formula Errors and how to handle them

10.Macros & VBA

a.Introduction to Macros

11.Class Project # 2

12.Additional Topics

a.Working with Complex Worksheets

13.Excel Dashsboard

a.What is a Dashboard?

b.Dashboard Creation Process

c.Making Excel Dashboards

d.Dashboard Design – Tips & Tricks

Register Now Brouchure