Excel and Power BI
Excel
» Complete Certificate Details
Microsoft Excel is the most used spreadsheet tool to create, edit and manage information.
- And criteria, If-Then, And Or and Not
- Create a worksheet and set properties
- Dashboard
- Exporting to PowerPoint and Word
- Financial calculations
- Formulas and functions
- Goal seek
- Lookup functions
- Pivot tables
- Populate, format, and merge cells
- Sorting and filtering
- Tables and data
- What-If analysis
- And more…
Certificate includes the following courses. Click on the title for course overview.
These online courses are offered in partnership with UGOTCLASS.
- Certificate programs consist of 2 or 3 individual courses bundled together (reduced fee when bundled vs. individual courses)
- Available 24/7 within the month of the course offering. No set day or time.
- Courses consist of online readings, audio presentations, and written online discussion boards with instructor and participants.
- After enrolling expect an invitation email the Wednesday before scheduled begin date from teacher@ugotclass.org. Check “Junk” email folder.
- Certificates will be emailed from UGOTCLASS within 3 weeks after successful course completion.
Enroll by clicking the “Register Now” button above. Questions: ceonline@dmacc.edu.
Microsoft Office Excel
Microsoft Office applications are taught by level—Basic, Intermediate & Advanced. Since these are hands-on courses that cover a lot of information in a short period of time, it's important to know how your knowledge and skills compare to what is covered at each level.
- Excel Basic
- Excel can help you organize, calculate, analyze, revise, update, and present data
to aid in decision-making. It also makes these tasks much easier for you to accomplish,
and in much less time. In this introductory Excel course topics include entering and
editing data, performing worksheet calculations, formatting cell contents, managing
multiple worksheets, using functions in formulas, and creating charts.
- Excel Intermediate
- This course will take your Excel skills to the next level by building on the foundational
skills learned in Excel Basic. Topics include advanced workbook formatting; date functions
and conditional formatting; financial functions and What-If analysis; conditional
functions using IF criteria, nested functions, 3-D cell references; and LOOKUP functions.
- Excel Advanced
- Are you an experienced Excel user who wants to learn about Excel's advanced features? This course will help you develop the necessary skills by building on the skills learned in Excel Basic and Excel Intermediate. Topics include: working with tables and special table features.
Courses Available (but not limited to):
- Certified Bookkeeper with Microsoft Excel
- Certified Internal Auditor
- Certified Internal Auditor with Microsoft Excel
- Microsoft Excel Certification
- Microsoft Office Specialist (MOS)
These online self-paced courses are offered through a partnership with ed2go.
- Available 24/7
- Dedicated ed2go student advisor
- Payment plan option available through ed2go, call 855-520-6806 for details
Courses Available (but not limited to):
- Accounting with Excel
- Computer Skills for the Workplace
- Master VLOOKUP in Microsoft Excel
- Microsoft Excel (3 levels)
- Microsoft Excel – Pivot Tables
- Microsoft Excel and Access
- Microsoft Excel and Project
- Microsoft Excel and Statistics
- QuickBooks Online with Microsoft Excel
These online courses are offered through a partnership with ed2go.
Two Class Types:
- Instructor-Moderated 6-week courses
- Available 24/7. No set class day or time
- 2 lessons released each week (4 hours per week of work)
- Written online discussion board with instructor and participants
- Self-Guided 3-Month Course
- Available 24/7
- NO discussion with instructor or participants
If final test score on 1st attempt is 70% or better, student prints certificate.
Enroll by clicking the “Browse online courses” link above. Questions: ceonline@dmacc.edu.
Power BI
Power BI was built to connect to a wide range of data sources, and allows you to quickly create visualizations of connected data to gain insights, show trends, and create reports. Its data connection capabilities and visualization features go far beyond those that can be found in spreadsheets, allowing you to create compelling and interactive worksheets, dashboards, and stories that bring data to life. In this course, you will analyze data with self-service BI, connect to data sources, perform advanced data modeling and shaping, visualize data, enhance data analysis, model data with calculations, and create interactive visualizations.
» Complete Certificate Details
This certificate will enhance your skills in data analysis, giving you greater insight into your organization's performance and allowing you to make more informed decisions using Power BI.
- CALCULATE function
- COALESCE function
- Create reports
- Data modeling
- DAX
- Filters vs Slicers
- Fuzzy match
- Power query
- Star Schema
- And more…
Certificate includes the following courses. Click on the title for course overview.
These online courses are offered in partnership with UGOTCLASS.
- Certificate programs consist of 2 or 3 individual courses bundled together (reduced fee when bundled vs. individual courses)
- Available 24/7 within the month of the course offering. No set day or time.
- Courses consist of online readings, audio presentations, and written online discussion boards with instructor and participants.
- After enrolling expect an invitation email the Wednesday before scheduled begin date from teacher@ugotclass.org. Check “Junk” email folder.
- Certificates will be emailed from UGOTCLASS within 3 weeks after successful course completion.
Enroll by clicking the “Register Now” button above. Questions: ceonline@dmacc.edu.
Explore more Microsoft Office Classes
(Outlook, Excel, Word, PowerPoint, Project, Access, SharePoint)
Look for CoursesDon't See What You're Looking For?
Contact Information
515-964-6800 or Email
DMACC Continuing Education
1111 East Army Post Road
Des Moines, Iowa 50315
Office Hours
Monday-Friday: 7:30 am – 4 pm
