This class includes Outlook, Windows, Excel, PowerPoint and Word skills.
Skills learned include developing new workbooks, password protection, hyperlinks, formatting, column formulas, paste special…
Microsoft Excel PivotTables, PivotCharts and Macros
Analysis of Variance, Mean squares of errors, Correlation, Exponential Smoothing, Histogram
You will put formulas to work in this course. Nested if-statements, DSUM, Data Validations, Match, VLookups, HLookups, Project Day Formulas, Templates…
Power Query, Power Pivot, DAX Formulas, Relationships in Excel, Calculated Columns, Measures…
Connecting to any data, Tableau Prep, Workflow,s Cleaning, Shaping and Combining data, Grouping data, Visualizations
Data Science For Business – SQL, Python, R, Visual Studio, RStudio, GGPLOT2, Violin Plots, Pear Plots…