Workshop: Fundamentos de Excel

Summary

A comprehensive introductory tutorial on Microsoft Excel, focusing on basic functions, data formatting, arithmetic operations, and statistical analysis tools essential for business students.

Highlights

Introduction and Basic Interface00:00:00

Overview of Excel as an essential professional and academic tool, introduction to the main interface including tabs, ribbons, and how to use data supplements.

Data Formatting and Editing00:03:00

Explanation of Clipboard features (cut/copy/paste), formatting cells (font, alignment, border, number formats), and using filters and freeze panes to manage large datasets efficiently.

Practical Exercises: Formatting00:11:37

Guided hands-on practice session applying bold styling, inserting/deleting columns, adding borders, and adjusting text within cells to prepare professional-looking reports.

Arithmetic Functions00:49:45

Instructions on basic arithmetic operations in Excel using operators (equals, plus, minus, etc.) and specific functions for sum, product, power, and roots.

Statistical Analysis Tools01:15:25

Deep dive into statistical functions including average, median, mode, weighted averages (using SUMPRODUCT), and measures of dispersion like maximum, minimum, and standard deviation.