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

*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