Edinburg Course Information
April 27, 2025
Dates:
April 29, May 1, 6 & 8, 2025
Days/Times:
Tuesdays & Thursdays: 6 p.m. - 8 p.m.
Program Modality:
In-Person
Location:
Edinburg CESS Building
Instructor:
Dr. Eduardo Millet
Cost:
$ 149
Excel Series Bundle:
$ 249
(Includes Basic, Intermediate, and Advanced courses)
Refund Deadline:
April 23, 2025
Notes:
Brownsville Course Information
TBA
Dates:
TBA
Times:
Lecture: Mondays & Wednesdays: 6:00 p.m. - 9:30 p.m.
Labs: Saturdays: 9:00 a.m. - 4:30 p.m.
Location:
Lecture: Online via Zoom*
Instructor:
TBD
Cost:
$ 2,999
Notes:
* Lecture components of this class will occur online via Zoom on Mondays & Wednesdays; labs will be on Saturdays once a month.
Advanced Excel Course
Elevate your Excel skills with our Advanced Excel Course. Designed for Excel users looking to enhance their expertise, this 8-hour program provides training on advanced Excel features and techniques.
Course Highlights:
- LookUp Functions: Master VLOOKUP, HLOOKUP, and more.
- Index and Match: Learn to combine these powerful functions for dynamic data retrieval.
- Advanced Formulas: Explore complex formulas to streamline your data analysis.
- Conditional Formatting: Discover how to highlight data trends and patterns.
- Macros: Automate repetitive tasks to save time and increase efficiency.
- Data Models: Build and manage sophisticated data models for better decision-making.
Throughout the course, participants will engage in hands-on practice, applying new concepts and skills to real-world data problems. Our expert instructor will provide personalized guidance, ensuring you gain the confidence and capability to transform your workbooks and enhance your decision-making processes.
Details:
- LookUp Functions: Master VLOOKUP, HLOOKUP, and more.
- Index and Match: Learn to combine these powerful functions for dynamic data retrieval.
- Advanced Formulas: Explore complex formulas to streamline your data analysis.
- Conditional Formatting: Discover how to highlight data trends and patterns.
- Macros: Automate repetitive tasks to save time and increase efficiency.
- Data Models: Build and manage sophisticated data models for better decision-making.
This course is highly beneficial for anyone who regularly works with data in Excel and wants to improve their efficiency and effectiveness.
Note: PEWD program participants should be 18 years or older.
This program requires knowledge of the following Basic and Intermediate Excel skills, including:
- How to create a basic worksheet
- Performing basic calculations in an Excel worksheet
- Modifying and formatting an Excel worksheet
- Inserting graphic objects, and customizing and enhancing workbooks
- Preparing a worksheet for printing and sharing
- Calculating with advanced formulas (Concatenate, Left, Right
- Creating and Enhancing Pivot tables (Slicers)
- Customizing and enhancing workbooks (Conditional formatting)
- Working with data from different tables and spreadsheets (VLookup, Match)
- Data Validation (Restrictions of cells)
- Data Analysis tools (SumIf, CountIf)
Dr. Eduardo Millet
Dr. Eduardo Millet is an Assistant Professor of Management at the State University of New York (SUNY). He specializes in Strategy, New Venture Creation, Social Entrepreneurship, and Innovation. He joined SUNY in 2020 after obtaining a PhD in Business Administration at the University of Texas Rio Grande Valley. He holds a Master’s in Urban and Regional Planning and a B.A. in Economics from the University of Minnesota.
Dr. Millet has a balanced background of industry and academic experience. He worked at the McAllen Chamber of Commerce where he developed an innovative approach to entrepreneurial development. Originally from Mexico, Dr. Millet moved to McAllen from Mexico where he served as the Director of Institutional Development for the State Government of Yucatan for five years, and as Director of Business Intelligence for a nationwide telecommunications company for three years.
Submit a required written request via email three business days before the program start date. Weekends are not considered. Partial refunds are not allowed.
- More of What You're Looking For -
A Manager’s Guide to Artificial Intelligence
This course introduces learners to basic artificial intelligence concepts and trends.
Certificate in Agile Project Management
This hybrid certificate program will provide managers with the basic foundation they need to become competent Agile practitioners.
Certificate in Computer Skills for the Office
Bring to your Office skills to a whole new level by diving into a suite set of powerful instructional courses.
Certificate in Cybersecurity
Cybersecurity, also known as Information Security is the protection of data and personally identifiable information from malicious attacks, theft, and destruction.
Certificate in Data Analytics
This program will introduce you to data analytics and its increasing use in today's professional landscape.
Certificate in Emerging Technology for Managers
This Certificate in Emerging Technology for Managers addresses blockchain, artificial intelligence, and robotics.
Front End Web Developer
Participants learn how to make interactive applications that run inside a web browser and can communicate with a web server running remotely.
Implementing a SQL Data Warehouse
This live, online course provides students with the knowledge and skills to provision a Microsoft SQL Server database.