Learn advance Microsoft excel and vba macro programming with finance examples
Àpd 19 € /h
This course will help to build your skill in MS excel advance formulas like vlookup, hlookup, sumifs, countifs. Also we will look on analytics side covering Excel pivoting. We will also build small application covering excel formulas, vba macros and finally see the results via pivot reporting. Finally we will cover excel dashboarding also.
Lieu
En ligne depuis Allemagne
Age
Enfants (7-12 ans)
Adolescents (13-17 ans)
Adultes (18-64 ans)
Seniors (65+ ans)
Niveau du Cours
Débutant
Intermédiaire
Avancé
Durée
60 minutes
Enseigné en
anglais
hindi
Compétences
Disponibilité semaine type
(GMT -05:00)
New York
Mon
Tue
Wed
Thu
Fri
Sat
Sun
00-04
04-08
08-12
12-16
16-20
20-24
You can learn programming basics, object oriented programming basics. For beginners start with basic programming concepts and then gradually advancing to advance real world projects based on advance modelling approached or based AI ML solutions.
In this class I start with teaching simple SQL like joins, cte functions etc. Later we will jump to advance sql like writing stored procedures, stored functions etc. Also I will cover very basic database designing concepts. Like the approach how to design good data base depending on the volume, performance etc.
Voir plus
Garantie Le-Bon-Prof