Quick answer: Data Analysis with Excel & Power BI is a 12-hour course that teaches you to clean data, build PivotTables and create dashboards managers use. It costs $495, runs every two months starting February 2027, and meets in San Bernardino or live online. It is the next step after our Microsoft Excel & Office Essentials course.
- Length: 12 hours
- Price: $495
- Format: In person or live online
- Cohorts: Every 2 months, first cohort February 2027
- Best for: Office staff and Excel course graduates
What You Will Learn
- Cleaning and organizing messy data
- Formulas that matter: XLOOKUP, SUMIFS, IF and dates
- PivotTables and PivotCharts
- Power Query to import and refresh data automatically
- Building an interactive Power BI dashboard
- Telling a clear story with numbers for your manager
Why It Matters in the Inland Empire
Warehouses, distribution centers, health care offices, schools and local governments across San Bernardino and Riverside counties run on reports: shipments, inventory, staffing, budgets and grants. People who can turn a spreadsheet into a clear dashboard become the go-to person on their team.
Next Step: Certification
Learners who want an industry credential can go on to Microsoft certification exams such as Microsoft Office Specialist (Excel) or the Power BI Data Analyst exam. Those exams are given by Microsoft's testing partners, not by the Foundation.
Where and How Classes Meet
Every course is offered in person at 255 N. D Street, Suite #200-XXVII, San Bernardino, CA 92401, or live online from anywhere in the U.S. That makes it easy for learners in Fontana, Ontario, Rancho Cucamonga, Rialto, Colton, Redlands, Riverside, Moreno Valley, Victorville and the rest of the Inland Empire to attend. New cohorts start all year, so there is always a next class.
Frequently Asked Questions
Do I need to know Excel already?
You should be comfortable with basic Excel. If not, start with our Excel & Office Essentials course.
Do I need Power BI?
Power BI Desktop is a free download for Windows. Mac users can work in the Power BI web service or use a Windows computer in class.
How to Enroll
Apply online in about two minutes, check start dates on the class schedule, or call (909) 454-7076. Employers can request onsite or private team training.
About our certificates: students who finish a course earn a Certificate of Completion from The Ayangbah Foundation, a 501(c)(3) nonprofit in San Bernardino. Our courses are short, practical training, not college degrees or accredited academic programs. Prices and dates may change. See the 2027 Course Catalog for current details.