Translated by Google
In-person or virtual classes in basic,
From 14.67 Fr /h
Basic Excel: Concepts, Data, Spreadsheets, Data Types, Insert, Cell Format, Basic Formulas, Print Design, Images, Hierarchy of Operations, Basic Statistical Functions, AutoFilters, etc.
Intermediate Excel: Basic Operations, Mathematical and Statistical Functions, Date and Time Functions, Logical Tests, If Function, Special and Advanced Functions, Advanced Filters, Data Validation, Conditional Formatting, Subtotals, Dynamic Tables and Charts, etc.
Advanced Excel: Logical and Nested Functions, Search and Reference Functions, Logical and Nested Search Functions, Set Functions, Data Tables, etc.
Medellin Colombia
Intermediate Excel: Basic Operations, Mathematical and Statistical Functions, Date and Time Functions, Logical Tests, If Function, Special and Advanced Functions, Advanced Filters, Data Validation, Conditional Formatting, Subtotals, Dynamic Tables and Charts, etc.
Advanced Excel: Logical and Nested Functions, Search and Reference Functions, Logical and Nested Search Functions, Set Functions, Data Tables, etc.
Medellin Colombia
Extra information
Classes can be both in person at my home or the student's home, as well as virtual.
Location
At student's location :
- Around Medellín, Colombia
About Me
I am a Production Engineer with knowledge of Excel, SQL and Power Bi, the latter being a tool that tells us where the company is and what its areas of improvement are.
Basic, Intermediate and Advanced Excel classes and jobs, Power BI and SQL Server, Power Query, Power Pivot
Basic, Intermediate and Advanced Excel classes and jobs, Power BI and SQL Server, Power Query, Power Pivot
Education
EAFIT University, University of Medellín, UPB
Basic Excel: Concepts, Data, Spreadsheets, Data Types, Insert, Cell Format, Basic Formulas, Print Design, Images, Hierarchy of Operations, Basic Statistical Functions, AutoFilters, etc.
Intermediate Excel: Basic Operations, Mathematical and Statistical Functions, Date and Time Functions, Logical Tests, If Function, Special and Advanced Functions, Advanced Filters, Data Validation, Conditional Formatting, Subtotals, Dynamic Tables and Charts, etc.
Advanced Excel: Logical and Nested Functions, Search and Reference Functions, Logical and Nested Search Functions, Set Functions, Data Tables, etc.
Basic Excel: Concepts, Data, Spreadsheets, Data Types, Insert, Cell Format, Basic Formulas, Print Design, Images, Hierarchy of Operations, Basic Statistical Functions, AutoFilters, etc.
Intermediate Excel: Basic Operations, Mathematical and Statistical Functions, Date and Time Functions, Logical Tests, If Function, Special and Advanced Functions, Advanced Filters, Data Validation, Conditional Formatting, Subtotals, Dynamic Tables and Charts, etc.
Advanced Excel: Logical and Nested Functions, Search and Reference Functions, Logical and Nested Search Functions, Set Functions, Data Tables, etc.
Experience / Qualifications
Information about Power BI classes:
*Query Editor: Connecting our data to Power BI, cleaning and transforming our data, Exploring the different data sources in Power BI.
*Connections to data sources, Transformations with Power Query, Data Modeling and Visual Objects
*Data Modeling, Cross Filter Detail and Hierarchies - tooltips in visuals, Types of visuals and their properties.
*Visuals, Report Details, Tool Information
*DAX Functions - Measurements, Calculated Columns
*Folder Read, Combine queries with double column, Additional DAX functions
*Scatter Plot, Choropleth Map, Main Menu, Insert Buttons
*Visualization (Indicator Meter), Measurement Summary (Minimum, Maximum, Median, Average), Mobile Design, Import Visual Object
*Power BI Service Licenses License Comparison, Dashboard Publishing
*Connection, Power Query, Transformation, Calculated Fields, Measures, Visualizations, Bookmarks
Information about SQL Server classes:
*When Excel is sometimes insufficient for managing Databases, it is necessary to use other types of programs such as SQL Server to carry out processes from both applications and speed up information transformations.
*Databases in Excel
*Database theory
*Databases in SQL Server
*Query Editor: Connecting our data to Power BI, cleaning and transforming our data, Exploring the different data sources in Power BI.
*Connections to data sources, Transformations with Power Query, Data Modeling and Visual Objects
*Data Modeling, Cross Filter Detail and Hierarchies - tooltips in visuals, Types of visuals and their properties.
*Visuals, Report Details, Tool Information
*DAX Functions - Measurements, Calculated Columns
*Folder Read, Combine queries with double column, Additional DAX functions
*Scatter Plot, Choropleth Map, Main Menu, Insert Buttons
*Visualization (Indicator Meter), Measurement Summary (Minimum, Maximum, Median, Average), Mobile Design, Import Visual Object
*Power BI Service Licenses License Comparison, Dashboard Publishing
*Connection, Power Query, Transformation, Calculated Fields, Measures, Visualizations, Bookmarks
Information about SQL Server classes:
*When Excel is sometimes insufficient for managing Databases, it is necessary to use other types of programs such as SQL Server to carry out processes from both applications and speed up information transformations.
*Databases in Excel
*Database theory
*Databases in SQL Server
Age
Children (7-12 years old)
Teenagers (13-17 years old)
Adults (18-64 years old)
Seniors (65+ years old)
Student level
Beginner
Intermediate
Advanced
Duration
60 minutes
90 minutes
120 minutes
The class is taught in
Spanish
English
Skills
Reviews
Availability of a typical week
(GMT -05:00)
New York
At student's home
Mon
Tue
Wed
Thu
Fri
Sat
Sun
00-04
04-08
08-12
12-16
16-20
20-24
*Query Editor: Connecting our data to Power BI, cleaning and transforming our data, Exploring the different data sources in Power BI.
*Connections to data sources, Transformations with Power Query, Data Modeling and Visual Objects
*Data Modeling, Cross Filter Detail and Hierarchies - tooltips in visuals, Types of visuals and their properties.
*Visuals, Report Details, Tool Information
*DAX Functions - Measurements, Calculated Columns
*Folder Read, Combine queries with double column, Additional DAX functions
*Scatter Plot, Choropleth Map, Main Menu, Insert Buttons
*Visualization (Indicator Meter), Measurement Summary (Minimum, Maximum, Median, Average), Mobile Design, Import Visual Object
*Power BI Service Licenses License Comparison, Dashboard Publishing
*Connection, Power Query, Transformation, Calculated Fields, Measures, Visualizations, Bookmarks
*Connections to data sources, Transformations with Power Query, Data Modeling and Visual Objects
*Data Modeling, Cross Filter Detail and Hierarchies - tooltips in visuals, Types of visuals and their properties.
*Visuals, Report Details, Tool Information
*DAX Functions - Measurements, Calculated Columns
*Folder Read, Combine queries with double column, Additional DAX functions
*Scatter Plot, Choropleth Map, Main Menu, Insert Buttons
*Visualization (Indicator Meter), Measurement Summary (Minimum, Maximum, Median, Average), Mobile Design, Import Visual Object
*Power BI Service Licenses License Comparison, Dashboard Publishing
*Connection, Power Query, Transformation, Calculated Fields, Measures, Visualizations, Bookmarks
Good-fit Instructor Guarantee
Contact Cristian