Learn advance Microsoft excel and vba macro programming with finance examples
A partir de 22.95 $ /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.
Lugar
Conectado desde Alemania
Edad
Niños (7-12 años)
Adolescentes (13-17 años)
Adultos (18-64 años)
Tercera edad (65+ años)
Nivel del estudiante
Principiante
Intermedio
Avanzado
Duración
60 minutos
La clase se imparte en
inglés
hindi
Habilidades
Disponibilidad en una semana típica.
(GMT -04:00)
Nueva 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.
Mostrar más
Garantía del Buen Profesor