In the world of data management, Excel has become an indispensable tool for professionals seeking to enhance their analytical skills. C&R Company (Creek & River) recognizes this need and has organized two free online workshops aimed at empowering users who are familiar with the basics of Excel, yet wish to deepen their expertise.
The workshops, titled "Understanding Excel Series by Categories: Data Aggregation and Analysis Volume 6 & 7," are scheduled for January 16 and January 30, 2026.
Dive into Power Pivot
The sessions will cover crucial aspects of Power Pivot, which allows users to handle extensive datasets and perform intricate analyses with ease. The first session, Volume 6, is designed to cover the fundamentals of Power Pivot, specifically focusing on DAX (Data Analysis Expressions), which is essential for creating meaningful calculations.
In Volume 6, participants will learn about:
- - The difference between calculated columns and measures.
- - Basic DAX functions such as SUMX and RELATED.
- - How to create custom measures using existing measures.
The second session, Volume 7, will introduce participants to time-series analysis using Power Pivot, equipping them with skills needed to efficiently analyze trends over time. Topics covered will include:
- - Creating calendar tables essential for time aggregations.
- - Understanding time intelligence functions that can provide insights into dates and events.
- - Practical patterns for executing time-series analyses that can be directly applied to real-world scenarios.
Who Should Attend?
These workshops are ideal for individuals who have already grasped basic Excel operations but are eager to refine their skills further. If you are interested in leveraging Excel not just as a spreadsheet tool but as a powerful data aggregation tool, these sessions will be invaluable.
The sessions will be conducted by Excel expert Toshimi Furusawa, a certified IT Coordinator and a small business consultant specializing in productivity enhancements through technology. He has a wealth of experience in teaching Excel and has authored several publications related to data analysis and automation in Excel.
Upcoming Events
C&R Company plans to host workshops on a monthly basis, with future sessions focusing on Power Query's introduction and utilization, which will further augment participants' Excel capabilities.
- - Volume 8: Introduction to Power Query
- - Volume 9: Utilizing Power Query
- - Volume 10: Integrating Power Query with Power Pivot
These engaging workshops will be held online, making it accessible for anyone to participate regardless of location. Attendance is limited to 60 participants per session, ensuring that everyone can receive personalized attention.
How to Register
Interested individuals can sign up for the sessions through the following links:
- - For Volume 6 (DAX Basics): Register Here (Registration closes on January 16, 2026, at 20:00)
- - For Volume 7 (Time Series Analysis): Register Here (Registration closes on January 30, 2026, at 20:00)
Join Us and Transform Your Excel Skills
Join us to unlock the full potential of Excel's Power Pivot tools! By reinforcing your data analysis skills, you can streamline your work processes and open doors to new analytical insights. This is an excellent opportunity for professionals from all backgrounds to expand their knowledge and skill set in a supportive learning environment.