Hialeah Technology Center

601 West 20 st

Hialeah, Fl 33010

Phone: 305-925-1260 (Call Ody)

Web:  www.hiatec.org

Email: jcarballo@hiatec.org

Microsoft Office Excel (2016) Practical Applications.

Topics:

     First Day (3 hours): 

·         Ribbons Concept. (0.5 h)

·         Basic Text and Number Formatting. (1 h)

·         Excel Spreadsheet (Basic Setup and New Features). (0.5 h)

·         Basic and Complex Operations with Cells, Ranges, Columns, and Rows. (1 h) 

Second Day (3 hours): 

·         Format as Table, Cells Styles, Themes, and Conditional Formatting. (1 h)

·         Working with formulas (Math Operator, SUM, AVERAGE, MAX, MIN) (2 h) 

Third Day (3 hours): 

·         Functions (SUMIFS, AVERAGEIFS, COUNTIFS). (1 h)

·         Importing and Transforming Data from Text and Access Format. (1 h)

·         Working with templates (Invoices, statements, budgets) (1 h) 

Fourth Day (3 hours): 

·         Advanced Sort & Filter Category. (1 h)

·         Text to Columns and Data Validation. (0.5 h)

·         Working with Advanced Chart and Smart Art. (0.5 h)

·         Working with Advanced Subtotal Tools. (1 h) 

Fifth Day (3 hours): 

·         Working with Advanced Subtotal Tools. (0.5 h)

·         Working with Pivot Table and Pivot Chart Report. (2.5 h)