Course
Intro to Data Analysis with Excel
Professionals who make the best decisions are the ones who know how to work with data. With AI tools like Microsoft Copilot built directly into Excel, knowing how to analyze data has never been more accessible.
This course guides you through an AI-assisted data analysis workflow so you can make sense of your findings and rely on them to make better decisions. You’ll learn how to prepare, organize, and analyze data using Excel and Copilot, and build visualizations and dashboards that make your results clear and your decisions easy to defend.
IMPORTANT NOTE
You will be required to do 5-10 hours of work per week outside of class time. If you have little or no prior knowledge, you might need extra time to gain familiarity with the concepts. But don’t worry. You’ve got this!
Your takeaways
This course is a great way to help you:
• Analyze and manage complex information using Microsoft Excel and Copilot with greater speed and accuracy
• Apply advanced Excel analytics techniques, including Power Query, Power Pivot, and Python, to extract meaning from multiple data sources
• Create dynamic dashboards and visualizations to easily communicate trends, KPIs, and business insights
• Apply AI-assisted features in formula generation, data cleaning, and automated summaries to improve efficiency and accuracy in your work
• Produce data-driven reports that facilitate business decision-making
Our approach
Through hands-on exercises and industry case studies, you’ll learn from seasoned professionals and practice using Excel and Copilot in situations you’re likely to encounter at work. Participants should expect to spend 5-6 hours practicing between sessions to reinforce what they’ve learned in class.
Who benefits the most?
• Business professionals and managers seeking AI and Excel tools to make data-driven decisions
• Professionals seeking advanced analytics and visualization techniques to produce clearer reporting and simplify decision-making
• Entrepreneurs and project leaders looking to use Excel-based analytics to make more strategic decisions
• IT and technical professionals transitioning into data analytics roles who want to better understand AI-assisted workflows
Important details
There are a couple of easy yet crucial specifications needed to function in class:
1. Computer / laptop equipped with Windows 10 and Microsoft Excel (2019, English)
2. Processor - 1.6 Ghz, 2-core processor
3. Memory (RAM) - 4 GB (for Windows 64 bit) or 2 GB (Windows 32 bit)
4. Hard Disk Space - 4 GB available disk space
5. BYOD - Students need to request 1) Concordia email 2) free Excel license via Microsoft
6. As a benefit of being a Concordia student, you can access Microsoft 365.
CCE Loyalty Discount
Students will receive a 10% discount on their CCE course or workshop tuition fees if they meet any of the following criteria:
- They previously completed a CCE, undergraduate or graduate course at Concordia University.
- They completed a language proficiency test at CCE.
- They completed a CCE Professional Development Seminar/Workshop.
This discount is based on the information maintained in the Concordia University student information system.
NOTE: The discount does not apply to application fees for admission to a CCE program, language proficiency test enrollment, or AI for Decision-Makers in Advanced Manufacturing.
