R is a free language built for data analysis and charts. Six lessons for Excel users: RStudio, vectors and data frames, reading CSV and Excel, dplyr for filtering and summarising, ggplot2 charts and a small analysis project.

1. 1R Lesson 1: Install R and RStudioInstall R and RStudio, find your way around the four panes, run code in the console and scripts, install packages, and set…
2. 2R Lesson 2: Vectors and Data FramesR’s building blocks: vectors and vectorised maths, data frames as tables, selecting rows and columns, and checking structure with str and summary.
3. 3R Lesson 3: Reading CSV and ExcelLoad data into R with readr::read_csv and readxl::read_excel, check columns and types, handle dates and missing values, and write results back out.
4. 4R Lesson 4: dplyr — filter, mutate, summariseAnalyse data with dplyr verbs: filter rows, mutate new columns, arrange, group_by and summarise — the R equivalent of filters, formulas and…
5. 5R Lesson 5: ggplot2 ChartsMake clean charts with ggplot2: the aesthetics-geometry idea, bar and line charts, ordering bars, labels and themes, and saving PNGs for reports.
6. 6R Lesson 6: Project — A Sales Analysis ReportCombine reading, dplyr and ggplot2 into a repeatable analysis: KPIs, product summary, charts and output files, plus a pointer to R Markdown/Quarto…

Related: R for Excel users, ggplot2 charts.