In this workshop, you learn about how to use Excel for your organization. This 3-session workshop includes practical exercises that walk you through the basics, learn the concept, watch examples and complete activities with the new concept on your own. You can register for all three sessions or select one that has your interest based on your skills. Before doing so, please review the content of the workshop of all 3 sessions.
LEARNINGOUTCOMES (competencies)
Monday, May 22nd 2023 EXCEL BASIC SKILLSOBJECTIVES – 2 HRS
In this Excel workshop, you will:
· Learn your way around the Excel environment.
· Learn how to create, open, and save Excel workbooks.
· Learn how to insert and delete cells and cell content, drag and drop cells, use the fill handle, and use the cut, copy, and paste functions.
· Learn how to modify rows, columns, and cells in Excel.
· Learn all about formatting text in Excel.
· Learn all about formatting numbers in Excel.
· Learn how to add, delete, copy, and move worksheets, as well as group and ungroup worksheets.
· Learn how to use Excel's Find and Replace features to search for specific data.
· Learn how to use Excel commands that let you control the way your content will appear on a printed page.
Lessons:
Lesson 1: Cell Basics
Lesson 2: Modifying Columns, Rows, and Cells
Lesson 3: Formatting Cells
Lesson 4: Understanding Number Formats
Lesson 5: Working with Multiple Worksheets
Lesson 6: Using Find & Replace
Lesson 7: Page Layout and Printing
Thursday, May 25th 2023 - EXCEL INTERMEDIATE SKILLSOBJECTIVES – 2 HRS
In this Excel workshop, you will:
· Learn how to freeze panes and split your worksheet so you're only seeing certain parts of your worksheet.
· Learn how to sort data to better view and organize the contents of your spreadsheet.
· Learn how to filter the data in your worksheet to display only the information you need.
· Learn how to organize data in groups, summarize different groups using the Subtotal command, and create an outline for your worksheet.
· Learn how to use styles to format tables in Excel.
· Learn how to insert and modify Excel charts to visualize comparisons in your data.
· Learn how to apply, modify, and delete conditional formatting rules in Excel.
· Learn how to use cell references to create a simple formula in Excel.
Lessons:
Lesson 8: Freezing Panes and View Options
Lesson 9: Sorting Data
Lesson 10: Filtering Data
Lesson 11: Groups& Subtotals
Lesson 12: Table Styles
Lesson 13: Charts
Lesson 14: Conditional Formatting
Lesson 15: Using Formulas
Real Life Activity 1: Over-Budget Items Real Life Activity2: Percentage-Off Sale
Monday, May 29th 2023 - EXCEL ADVANCE SKILLSOBJECTIVES – 2 HRS
In this Excel workshop, you will:
• Learn how to create a complex formula in Excel. (Such as IF Statement)
• Learn all about absolute and relative cell references and how they're used in Excel.
• Learn the different parts of a function and how to create arguments to calculate values and cell references.
• Learn how to use PivotTables in Excel for stronger data analysis.
• Learn how to use Excel's VLOOKUP and CONCANTENATE functions.
• Learn how to create and edit an invoice in Microsoft Excel.
Lessons:
Lesson 16: Complex Formulas
Lesson 17: Relative& Absolute Cell References
Lesson 18: Functions
Lesson 19: Pivot tables
Lesson 20: VLookup
Lesson 21: Using CONCATENATE
Real Life Activity 3: Basketball Player Statistic Real Life Activity 4: The IF Function
Activity 3: Create an Invoice
Register here: https://bit.ly/NPOwer2023Workshops
