Online or onsite, instructor-led live Excel training courses demonstrate through interactive discussion and hands-on practice how to use Excel for financial computations, data analysis and more.
Excel training is available as "online live training" or "onsite live training". Online live training (aka "remote live training") is carried out by way of an interactive, remote desktop. Iowa onsite live Excel trainings can be carried out locally on customer premises or in NobleProg corporate training centers.
NobleProg -- Your Local Training Provider
Des Moines, IA - Hub Tower
699 Walnut Street, Des Moines, United States, 50309
The Hub Tower location is easily accessible by car via Interstates 35 and 80, with underground and nearby public parking available; simply head downtown to Walnut Street. Guests arriving from Des Moines International Airport (DSM) can expect a 10‑ to 15‑minute taxi or rideshare journey via I‑235 and I‑35 into downtown. For public transportation users, DART buses stop close to the building, and it also connects via the downtown skywalk to neighboring business and cultural venues.
IA, Johnston - Regus - Foxboro Square
6165 Northwest 86th Street, Johnston, United States, 50131
Regus Foxboro Square enjoys a highly accessible suburban location—and is easily reached by car via Interstates 80/35. Ample free parking is available in the surface lots surrounding the building. For those arriving from Des Moines International Airport (DSM), the venue is approximately 16.6 km (about a 15–20 minute drive) via I‑35 north. Public transit users can take Johnston-area bus services to nearby stops; the facility is also adjacent to Dover Park’s walking and biking trails, providing a healthy commute option.
Cedar Rapids, IA - Regus – Edgewood Pointe
4515 N River Blvd NE #200, Cedar Rapids, United States, 52411
Regus Cedar Rapids is easily accessible by car via I‑380 or I‑80 toward northeast Cedar Rapids, exiting at Edgewood Road and traveling south on River Boulevard. Complimentary on-site surface parking ensures convenience for event attendees. For travelers arriving at Des Moines International Airport (DSM), the venue is approximately a 90‑minute drive via I‑80 and I‑380. Local participants can reach the centre using Cedar Rapids Transit Route 10, with stops near River Boulevard and Edgewood Pointe.
Excel is a widely used spreadsheet application for data organization, analysis, and automation.
This instructor-led, live training (online or onsite) is aimed at intermediate-level Excel users who wish to apply Excel for inventory control, budgeting, reporting, and automation using real-world datasets.
By the end of this training, participants will be able to:
Use formulas such as SUMIF, IF, VLOOKUP, and SUMIFS for inventory and purchasing scenarios.
Handle and analyze large datasets of 5,000+ rows efficiently.
Create and interpret pivot tables for monthly and accumulated tracking.
Automate repetitive reporting tasks using macros.
Track material purchases versus consumption with structured templates.
Format of the Course
Interactive lecture and discussion.
Lots of exercises and practice.
Hands-on implementation in a live-lab environment.
Course Customization Options
To request a customized training for this course, please contact us to arrange.
This instructor-led, live training in Iowa (online or onsite) is aimed at beginner-level to advanced-level data analysts who wish to use Excel to perform a variety of tasks such as data entry, formula creation, data analysis, and advanced automation.
By the end of this training, participants will be able to:
Navigate Excel’s interface and perform basic data entry, formatting, and calculations.
Apply advanced formulas, functions, and conditional formatting for data analysis.
Create and manage pivot tables and charts for data visualization.
Use tools like Power Query, Power Pivot, and perform data analysis.
Automate tasks using macros and VBA to streamline workflows.
This instructor-led, live training in Iowa (online or onsite) is aimed at beginner-level to intermediate-level professionals who wish to enhance their productivity and efficiency by leveraging the advanced features of Excel and Google Sheets for data organization, analysis, and collaboration.
By the end of this training, participants will be able to:
Navigate and utilize the core features of Excel and Google Sheets.
Perform data analysis and create actionable insights using advanced spreadsheet techniques.
Collaborate in real-time using Google Sheets for seamless teamwork.
Create reusable templates for reporting, tracking, and project management.
This instructor-led, live training in Iowa (online or onsite) is aimed at data analysts or anyone who wishes to learn how to use Excel for creating data models for data analysis.
By the end of this training, participants will be able to:
Learn to analyze and solve any business problems using structured problem-solving tools.
Navigate Excel tools with ease.
Set up, format, and present data effectively.
Understand the logical structure and apply correct functions to Excel models.
The course participants will be able to efficiently use primarily data analysis tools such as scenarios and pivot tables, use the features to perform calculations on dates and text-processing functions, and create and adapt to the needs of macros to automate work with spreadsheets.
Analysts, researchers, scientists, graduates and students and anyone who is interested in learning how to facilitate statistical analysis in Microsoft Excel.
Course Objectives
This course will help improve your familiarity with Excel and statistics and as a result increase the effectiveness and efficiency of your work or research.
This course describes how to use the Analysis ToolPack in Microsoft Excel, statistical functions and how to perform basic statistical procedures. It will explain what Excel limitation are and how to overcome them.
This instructor-led, live training in Iowa (online or onsite) is aimed at data analysts who wish to learn techniques for preparing data in Excel, then visualizing it in Power BI.
By the end of this training, participants will be able to:
Understand the principles of data analysis, objectives of data analysis, and approaches for data analysis.
Use DAX formulas in Power BI for complex calculations.
Create and use visualizations and charts for particular analysis cases.
Import with Power View to move from Excel based Power BI to independent Power BI.
During the training, will present the issues of financial analysis using the advanced features of Excel.
This course is intended for financial analysts, accountants and all those who want to expand their skills spreadsheet with issues of financial analysis.
This live instructor-led training (onsite or remote) will guide you through the most important tools of MS Excel. A combination of comprehensively prepared training materials and the expertise of the instructor will demonstrate the vast possibilities of excel spreadsheet use. In compartision to other typical excel courses, this tarining will uncover many uniqe excel functionalities that will speed up and enhance your work.
This live instructor-led training (onsite or remote) will guide you through the most important elements of Excel VBA. A combination of comprehensively prepared training materials and the expertise of the instructor will demonstrate the power of task automation using VBA.
Format of the Course
Interactive lecture and discussion.
Hands-on implementation in a live-lab environment.
Course Customization Options
To request a customized training, please contact us.
The course participants will be able to efficiently perform a variety of calculations in a transparent way to arrange and present their results, use multiple mechanisms to facilitate and accelerate the creation of spreadsheets, as well as protect the calculations and their results against unauthorized persons
Participants will be able to excel themselves, in the most optimal way to create, consolidate and manage data. A number of tools designed to streamline the work often significantly reduces the time to activities carried out so far and can help you design an application that could perform new tasks.
Excel is a versatile tool that has been widely used in various areas, from data analysis to project management. Its flexibility and ease of use make it a popular tool for working with data and analysis in many fields. Excel allows you to create spreadsheets in which you can enter data, calculate formulas, analyze data and present results in the form of tables, charts or reports. It has a rich set of built-in mathematical, statistical and financial functions that facilitate calculations and data analysis. It allows you to generate various types of charts (e.g. bar, line, pie) based on data from the spreadsheet, which helps you visualize and present data. Excel offers tools for sorting, filtering, grouping data, as well as creating pivot tables and preliminary data analysis. It is used in business for budgeting, planning, tracking expenses, analyzing sales, creating financial reports, etc. It can be used to create schedules, project plans, manage tasks, and track progress.
This instructor-led, live training in Iowa (online or onsite) is aimed at beginner-level to intermediate-level business analysts and data analysts who wish to use Excel to perform data analysis and reporting for their projects and tasks.
By the end of this training, participants will be able to:
Use Excel formulas and functions to perform calculations and data manipulation.
Use Excel data analysis tools such as PivotTables, What-If Analysis, and Forecasting to summarize and visualize data.
Use Excel charts and graphs to create and customize data visualizations.
Use Excel data validation and conditional formatting to ensure data quality and highlight data insights.
Use Excel data import and export features to connect to external data sources and share data with others.
Read more...
Last Updated:
Testimonials (14)
learned new things
Daria Pawlak - LKQ Polska Sp. z o. o.
Course - Excel Modelling
examples and looking for solutions
Monika Lesniewska - Takenaka Europe GmbH Sp. z o.o. Oddzial w Polsce
Course - Excel Data Analysis
The tips for many of the functions that the trainer presented, which we can easily remember and implement in our future work
Emilija Stoilova - EPFL HBP PCO
Course - Analysing Financial Data in Excel
The second day as Power Bi is a really friendly tool, and clearly Costas knows it very well, it was really good to learn about that tool. Unfortunately we have to see Power pivot in excel first which is really not user friendly but definitely a must see first in order to understand how Power Bi works, and it makes Power Bi look super cool :)
Anne-Cecile Jacquot - Ameropa
Course - Excel to Power BI
The level of Excel knowledge was great followed by the high volume of material covered.
Humphrey Martino - Kneipp Corporation of America
Course - Excel in One Day
The fact he had dif excel and data sheets with exercises for us to do.
Deepakie Singh Sodhi - Queens College, CUNY
Course - Excel For Statistical Data Analysis
The guy was really helpful and knowledgeable and i really learned a lot in two days.
Francesca Maggiolo - Bettzeit GmbH
Course - Excel Basics
There was a good amount of information for the time of training. Also the trainer was very engaged with the group, especially when people were having troubles or asking questions. It was very nice of him to offer help in case of future ideas.
Aleksander Jarecki - Amazon Development Center Poland Sp. z o.o.
Course - Visual Basic for Applications (VBA) in Excel (intermediate level)
Working on and using our own data/spreadsheets, where we could see how it would benefit us most.
Julie - Environment, Marine and Fisheries
Course - Excel VBA Introduction
The training was really useful. I liked the most the parts related to the pivot tables, filtering, lockup options and data consolidation. I appreciated trainer's excellent knowledge on the subject. His attitude was very good as well. He built open and 'not so formal' atmosphere which helped participants to ask the questions or speak about their daily excel issues. He was fully understandable during the whole training and his way of explaining the topics was direct and adequate.
Katarzyna Chalinska - UBS Business Solutions Poland Sp. z o.o.
Course - Excel Advanced
I generally enjoyed the practical examples.
Marika Agius
Course - Visual Basic for Applications (VBA) for Analysts
Content and the way it was provided.
Marcin Samborski
Course - Visual Basic for Applications (VBA) in Excel - Advanced
Training agenda was well thought out.
Przemek Zalasinski
Course - Visual Basic for Applications (VBA) in Excel - Introduction to programming
Online Microsoft Excel training in Iowa, Microsoft Excel training courses in Iowa, Weekend MS Excel courses in Iowa, Evening Microsoft Excel training in Iowa, Microsoft Excel instructor-led in Iowa, Evening Excel courses in Iowa, Weekend Microsoft Excel training in Iowa, Microsoft Excel classes in Iowa, Excel instructor in Iowa, Excel one on one training in Iowa, MS Excel trainer in Iowa, Online Microsoft Excel training in Iowa, Microsoft Excel boot camp in Iowa, MS Excel on-site in Iowa, MS Excel instructor-led in Iowa, MS Excel private courses in Iowa, MS Excel coaching in Iowa
