Part 1: Live Guided Session on Google Drive and Google Suite
Part 2: Self-Paced Intro to Excel(Modules 1-4)
Part 3: Self-Paced Deeper Dive into Excel (Modules 5-8)
Part 4: Bonus Goodness to use when you need!
This is a live session, hosted by Mrs. Moreno.
Excel is a powerful tool for organizing, analyzing, and visualizing data. Here are a few key skills that you may want to learn as you get started with Excel:
Navigating the Excel interface: Become familiar with the various elements of the Excel interface, including the ribbon, worksheets, cells, and formulas.
Entering and editing data: Learn how to enter and edit data in cells, including using the fill handle to copy data and the auto-fill feature to enter data quickly.
Formatting data: Use formatting options to make your data more visually appealing and easier to read, including changing font sizes and colors, adding borders, and aligning text.
Using formulas: Excel is powerful because of its ability to perform calculations using formulas. Learn how to use basic formulas, such as SUM and AVERAGE, and how to use cell references in formulas.
Creating charts and graphs: Visualize your data using charts and graphs, such as bar charts, line graphs, and pie charts.
Working with large data sets: Learn how to use functions like SORT and FILTER to work with large data sets and find the information you need quickly.
These are self-paced learning videos. Feel free to select ones that meet your learning needs best.
Module 1-Getting Started with Exel
This video includes information on:
• Working with the Excel environment, including changing the Ribbon
• Using the Quick Access Toolbar
• Using worksheet views
• Accessing Backstage View
Module 2- Cell Basics
This video includes information on:
• Understanding and selecting cells
• Inserting content
• Editing and deleting cells
• Copying and pasting cells
• Using the drag-and-drop feature to move cells
• Using the fill handle
Module 3- Intro to Formulas
This video includes information on:
• Mathematical operators
• Understanding cell references
• Creating formulas
• Copying and editing formulas
Module 4- Excel Functions
This video includes information on:
• The parts of a function
• Working with arguments
• Creating functions manually and via AutoSum
• Using the Insert Function command
These are self-paced learning videos. Feel free to select ones that meet your learning needs best.
Module 5- Sorting Data
This video includes information on:
• Types of sorting
• Sorting sheets and ranges
• Creating a custom sort
• Adding levels
Module 6- Excel: Filtering Data
This video includes information on:
• Filtering data
• Applying multiple filters
• Clearing filters
• Using advanced text, number, and date filters
Module 7- Excel: Tables
This video includes information on:
• Formatting data as a table
• Adding rows or columns to a table
• Changing the table style and modifying table style options
• Removing a table
Module 8- Conditional Formatting
This video includes information on:
• Understanding conditional formatting
• Creating a conditional formatting rule
• Using preset conditional formatting
• Removing conditional formatting
Here you will find a couple QSGs for you to explore and use when needed.
Mail Merge in ExcelMail Merge to Outlook & Word
Mail Merge to Labels
This video includes information on:
• Using PivotTables to answer questions
• Creating PivotTables
• Adding columns
• Changing rows and columns
