
Learn how Excel handles dates, auto fills date sequences, and converts year, month, and day into a proper date using the built-in date function.
Use Excel's logical operators to compare strings across columns a and b, returning true or false to identify equal values and differences.
Explore how brackets and the order of operations in Excel govern calculations, with a practical tax example showing why parentheses matter and how multiplication interacts with addition.
Use pivot tables to summarize data and insert a slicer to filter by country and year, then view production totals for cereals, crops, and livestock like beef, pork, and poultry.
Create a basic bar chart to visualize discrete data in tonnes per hectare, using bar plots and pie charts, with data labels and chart titles for Belgium's food items.
Explore how to activate and use Excel add-ins, including the analysis tool pack and solver, to perform basic statistics and data analysis.
Explore the relationship between two quantitative variables using scatterplots and correlation, identify positive or negative association, and recognize that correlation does not imply causation.
Explore how adding independent variables inflates R-squared in regression and learn how adjusted R-squared corrects for variables and observations to reveal true importance.
Choose between SQL and NoSQL databases for data analysis, applying a quick rule to decide when SQL data fits.
If You Are…..
A business intelligence (BI) practitioner
Data analyst
Interested in gaining insights from data (especially financial, geographic, demographic and socio-economic data)
Excel Is Your Friend for Common Business Data Analysis Tasks
I’m Minerva Singh, and I’m an expert data scientist. I’ve graduated from 2 of the world's best universities: an MPhil from Oxford University (Geography and Environment) and a PhD holder in Computational Ecology from Cambridge University. I have several years of experience in data analytics and data visualization.
My course aims to help you start with no prior/limited exposure to data analysis and become proficient in producing powerful visualizations and analyses with Microsoft Excel. You don't need prior exposure to data analytics and visualization to start with MS Excel. So if you have struggled with Excel, worry no more. After finishing my course, you will be able to:
Read in and clean messy data in MS Excel.
Carry out common business data analytic tasks, including filtering
Carry out pre-processing and data summarization to glean insights from the data
Develop powerful visualisations with MS Excel
Carry out basic statistical analysis using MS Excel
If you take this course and it ever feels like a disappointment, feel free to ask for a refund within 30 days of your purchase, and you will get it at once. Become an expert in Data Analytics and Visualization with a new and powerful tool by taking up this course today!