Advanced MS Excel

UBT
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

Apply Now