Advanced MS Excel
Published: 5 December 2022
In the framework of this course candidates will learn about the best practices of working with MS Excel, such as using advanced MS Excel techniques and tools, such as: conditional formatting, graphs, sorting, filters, subtotal, special paste, text import, cell naming, goal seek, date and time functions, mathematical functions, statistical functions, functions text, financial functions, lookup and reference functions, database functions data, use of combined functions, use of new data in one or two tables, what if analysis, pivot table creation, audit scenarios, deployment of comments, view, remove and improve comments, macros.
Training provider
UBT
Duration of training
3 Weeks
Topic of the training
Statistical and financial calculations Managing variables in worksheet templates through scenarios Build scenario reports Compare and contrast different data from Manager Scenario Profit determination through Goal Seek Implementation of consolidation (merger, merger) techniques Summary of data containing the 3-D worksheet Defining the best combination of values to solve complex business problems Designing business trends Creating interactive data reports through Pivot Table Creating macros to facilitate data analysis
Total number of training hours
18 hours
Recurrence of training
3 Times per year
Min. number of participants for starting course
12
Certification upon ending
Certificate
Free / Paid
110€
Opening date/s for registration:
1 December 2022
Accessibility of venue for people with disabilities
Yes
Certification
Certification
Languages
ALB
Duration
Weeks
Level
Intermediary
Topic
Other
Training Provider
UBT
Training Type
Blended
Trainer
Besnik Skeenderi
Contact(s) for registrations/questions
