2
 

MS Excel Applied + AI: Effective Tools for Professionals

Free access to CISCO courses with international certification.

 
Hours48 hrs. (24 synchronous hours and 24 asynchronous hours)
Duration4 weeks
Modality 100% online
The course is designed for participants to gain practical skills in using Excel and integrating it with AI tools. The use of functions, automation with macros, data analysis, creation of dynamic reports, basic integration with AI APIs such as ChatGPT and simulations of business scenarios will be addressed, all aimed at improving efficiency in everyday professional tasks.

Aimed at:

Professionals, technicians, entrepreneurs and students who use Excel as a productivity tool and want to optimize their processes with automation, data analysis and general-purpose artificial intelligence tools, without the need for prior knowledge in programming or data science.

Thematic Content

Fundamentals of Excel applied to the professional environment
Essential functions and good practices in Excel
Professional tables and formats: data validation, cell protection and conditional formats
Use of logical, mathematical and search formulas (YES, VLOOKUP, XLOOKUP, INDEX, MATCH)
Introduction to Applied Artificial Intelligence: what is it and how can it be integrated with Excel?
Basic task automation and analysis with advanced features
Consolidation and analysis of data with nested functions
Basic financial functions applied to professional management (VA, VF, TASA, NPER)
Introduction to Pivot Tables and Automatic Reports
Text automation with AI (ChatGPT): writing reports, emails and frequent responses
Data analysis and visualization tools
Dynamic graphs and basic dashboard in Excel
Data segmentation and interactive dashboards
Using Target Search, Data Tables, and Scenario Manager
Introduction to generative AI in decision making and data prediction
Design of the components of a conventional indirect water system
Obtaining the building's water supply
Tanker and elevated tank design
Determination of the diameter of the meter and the water connection to the cistern
Determination of the maximum simultaneous demand flow rate and the filling flow rate to the elevated tank
Calculation of pump power
Macros and process automation
Macro Recorder: Automation without code
Creating simple buttons and forms in Excel
Introduction to VBA: key concepts and practical examples
Automation of repetitive tasks in the work environment
AI applications in professional environments with Excel
How to use ChatGPT and other AI for analysis, suggestions and process optimization
Generation of automatic reports from data
Organization of ideas, summaries and assisted decision making
Professional workflow combining Excel + AI
Scenario analysis and decision simulation
Simulation of scenarios with Excel: prices, sales, budgets
Using Solver to optimize business decisions
AI integration for business scenario simulations
Resolution of practical cases with Excel and AI
Simulation of scenarios with Excel: prices, sales, budgets
Using Solver to optimize business decisions
AI integration for business scenario simulations
Scenario analysis and decision simulation
Analysis of real cases: inventory control, task planning, budgets, monthly reports
Automation of routine tasks with macros and advanced functions
Using AI to generate recommendations, descriptions and summaries of results
Practical application: decision simulations in administrative, commercial or academic environments
Decision simulation with advanced Excel
Guided development of a comprehensive project (automation, analysis and presentation)
Application of learned concepts: macros, AI, pivot tables, simulations
Customization of automated templates

Benefits

Icono 1
Access to recording classes for reinforcement
Icono 1

Access to digitized material 24/7

Icono 1

Free CISCO self-study courses with international certification

Icono 1

Project-based learning (PBL)
Development of a project applied to the participant's work environment, which consolidates the knowledge acquired during the course.

Icono 1
Instructor profile
  • Internationally certified instructors.
  • Academic and professional experience.
Icono 1
Requirements
  • Basic knowledge of Excel
Icono 1
Certification
Certificate of Approval issued by the César Vallejo University (digital format).

ATTRIBUTES

Formulario Segunda especialidad