Intermediate Excel Course

In this training, you will discover how to make data usable for better decision making. You will learn by doing, for example, how to use data from different tables and worksheets, get the data ready for reports using tools featured in Microsoft Excel, and protect the worksheet using validation and permissions. Upon completion of this training, you will have developed the skills necessary to create a transformed dataset to develop informative dashboards or perform critical analyses.


Details:



  • 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)

This course is designed for learners with a basic understanding of Microsoft Excel that want to develop meaningful worksheets for decision making at their organizations. This is especially suited for owners, managers, and professionals taking on data analysis roles in their organization.

Note: PEWD program participants should be 18 years or older.

This program requires a basic understanding of Microsoft Excel.

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.

 



Edinburg Course Information

Registration Deadline:
April 15, 2024 at 12 p.m

Dates:
April 16 & 23, 2024

Days/Times:
Tuesdays: 6 p.m - 8 p.m

Program Modality:
In-Person

Location:
Edinburg CESS Building

Instructor:
Dr. Eduardo Millet

Cost:
$ 109

Notes:
Students requiring accommodation should contact our office pewd@utrgv.edu to learn about the process.

Enroll

Edinburg Course Information

Brownsville Course Information

Days:
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.

- More of What You're Looking For -

Play Stop