Excel Copilot is transforming spreadsheet productivity-this course ensures participants stay ahead of the curve. It equips them with foundational to intermediate Excel techniques while introducing AI-powered features within Microsoft 365. They will work through guided exercises that integrate formulas, charts and Copilot prompts for enhanced productivity.
Learning Outcomes:
Apply essential Excel functions for calculation and analysis
Create visual representations using charts
Use Excel Copilot to generate insights
Manage workbooks and collaborate within Microsoft 365
Key Topics:
Formulas and functions
Chart types and formatting tools
Using Excel Copilot and AI-generated suggestions
Workbook navigation and collaboration features
Module 1: Getting Started with Excel
- Starting Excel
- The User Interface
- Using Microsoft Excel Help and Resources
- Exit Excel
Module 2: Working with Workbook and Worksheets
- Cells Navigation
- Using GoTo
- Entering Data
- Shortcuts for Data Entry
- Spell Check
- Working with Selections
- Working with Rows and Columns
Module 3: Formatting the Worksheet
- Apply Number Formats
- Apply Text Formats
- Apply Borders and Fill
- Format Painters
- Clearing Formats
Module 4: Formulas and Functions
- Using Basic Formulas
- Entering Formulas
- Basic Functions
- Using the AutoSum Button
- Using Statistical Functions (MAX, MIN, COUNT, AVERAGE)
- Using AutoFill
- Editing Functions
- Using Date Functions
- Error Checking
- Create Absolute Reference
- Using IF Function
Module 5: Data Management with Tables
- Apply Table Formats
- Changing Table Style
- Adding Table Rows and Columns
- Adding Total Row in Table
- Apply Table Filters
- Sorting
- Finding Data
- Replacing Data
Module 6: Charts
- Recommended Charts
- Inserting a chart
- Resizing a chart
- Deleting a chart
- Adding a Chart Title
- Changing the Chart Background
- Formating chart legend, axis
- Changing a column, bar, line or pie slice colors
- Changing the chart type
- Adding a Data Table
- Changing the Chart Layout
- Creating 3-D Chart
- Adjusting 3-D View
- Moving charts
- Deleting chart
- Insert Sparkline
Module 7: Preparing outputs
- Worksheet margins
- Worksheet orientation
- Worksheet page size
- Add Headers and Footers
- Scaling your worksheet to fit a page(s)
- Repeating Row and Column Labels
- Changing Page Breaks
- Setting/Removing a Print Area
- Printing Options
Module 8: Introduction to Copilot
- Overview of Copilot
- How Copilot can assist with Office tasks
Module 9: Copilot and Excel 365
- Using Copilot for formatting and formula assistance
- Using Copilot for chart creation
.png?width=50&name=Artificial%20Intelligence%20(AI).png)
-1.png?width=360&name=Server%20(4)-1.png)
/AI%20(6)-1-1.png?width=360&name=AI%20(6)-1-1.png)
/AI%20(8)-1.png?width=360&name=AI%20(8)-1.png)
-1.png?width=360&name=Automation%20RPA%20(2)-1.png)
/AI%20(5)-1.png?width=360&name=AI%20(5)-1.png)
