1 Course Structure Overview.mp4 (101.54 MB) MP4 1 Install R.mp4 (105.02 MB) MP4 2 Setup RStudio, R and Python, Git.mp4 (249.97 MB) MP4 3 Posit R Package Manager for Version Control (Optional).mp4 (93.84 MB) MP4 1 Github Repository With the Codebase.mp4 (81.08 MB) MP4 1 1 ExcelAutomationRChatGPT-main.zip (21.78 KB) ZIP 1 OpenXLSX Package for Custom R Reporting with Excel.mp4 (130.7 MB) MP4 10 Custom Number Formatting Styles.mp4 (124.35 MB) MP4 2 Generating Dummy Data for Reporting and Analytics.mp4 (235 MB) MP4 3 Understanding Data Classes and Types for Reporting.mp4 (107 MB) MP4 4 Create a Workbook Object and Write as Excel File.mp4 (252.66 MB) MP4 5 Write Tables with Excel Styles using tableStyle and writeDataTable.mp4 (159.46 MB) MP4 6 Read Excel files and Import workbooks to your RStudio environment.mp4 (272.23 MB) MP4 7 Introduction to Styles in R to customize the outline of your Excel Report.mp4 (157.32 MB) MP4 8 Advanced Style Customization.mp4 (158.13 MB) MP4 9 Date and Time Objects - Custom Styles.mp4 (216.21 MB) MP4 1 Basic Excel Analytics and Reporting with R and ChatGPT.mp4 (388.67 MB) MP4 2 Introduction to Projects.mp4 (19.61 MB) MP4 4 Bulk Excel Reporting with R and RStudio.mp4 (212.98 MB) MP4 5 Advanced Excel Reporting with custom Styles and Multiple Sheets.mp4 (344.34 MB) MP4 1 Practical ChatGPT for Data Analytics.mp4 (116.11 MB) MP4 2 Main Metrics - Aggregations - Sum - Mean - Median - Percentiles.mp4 (306.25 MB) MP4 3 Rolling Metrics - Moving Averages.mp4 (226.54 MB) MP4 5 Statistics Reporting and Customization with R and Excel.mp4 (152.59 MB) MP4 1 Conditional Formatting of Excel Reports.mp4 (249.27 MB) MP4 2 Page Customization for Printing.mp4 (149.65 MB) MP4 3 Images and Plots using R and ggplot2.mp4 (303.17 MB) MP4 4 Plots using mscharts and openxlsx2.mp4 (219.59 MB) MP4 5 Writing Formulas in Excel using R code.mp4 (292.64 MB) MP4 6 Remove Functions for Advanced Customization.mp4 (66.23 MB) MP4 7 Workbook Settings Configuration.mp4 (197.7 MB) MP4