Khpalwaak - Advanced MS Excel - Khpalwaak

ABOUT TEAM

AAT Level 2 AAT Level 3 AAT Level 4

ACCA Level 1 ACCA Level 2 ACCA Level 3 ACCA Other Qualifications

AAT (Coming Soon)

Management Accountant Self-Assessment Corporation Tax Return 600 Construction Industry Scheme

Advanced Excel Accounts Assistant Basic to Intermediate Excel Payroll

Final Accounts VAT Bookkeeping

CONTACT US

Advanced Microsoft Excel

Pivot tables
Use of Pivot Table
Summing Techniques
Slicer
SumIF
IF, AND /OR functions
Basic Macros
Scenarios
Goal Seek
Database Formulas
Conditional Formatting
Charts & Graphs
Data Tables
Line charts & Column
IFERROR
Using lookup and reference functions (VLOOKUP, HLOOKUP)
VlookUP with Exact Match, Approximate Match
Outlining & Groupings
Filtering data for selected view
Using advanced filter options
Data Validation
Hyperlinks
Preparation of advance excel spreadsheet

Software in use

MS - Excel

Use by and Duration

Worldwide

6 hours lecture & 4 hours practice

Training mode

online/hybrid/office based

Enquire