Microsoft Office & 365 Apps
Excel Part 1: Excel for Beginners
A confident start in Excel.
1 dayFoundation7 modules
About this course
A confident start in Excel. You will enter data, perform calculations, modify and format worksheets, print and manage workbooks.
Curriculum
7 modules
- Navigate the Excel user interface and organize your workspace efficiently
- Use Excel commands and features, and locate tools with shortcut keys
- Create and save a basic workbook
- Access and use Excel Online for cloud-based collaboration
- Enter and edit data entry efficiently in worksheets
- Find help and support through built-in tools and Microsoft Support resources
- Build Excel formulas to perform calculations quickly
- Insert and manage Excel functions like SUM, AVERAGE, and logical operators
- Reuse and copy formulas and functions using step-by-step techniques
- Insert, delete, and adjust cells, columns, and rows
- Search for and replace data, and use filter tools for data management
- Apply text and number formatting, including borders and shading for visual emphasis
- Align, arrange, and organize worksheet content
- Apply colors, borders, and predefined styles for professional spreadsheets
- Apply basic conditional formatting to highlight trends
- Create and use templates to streamline repetitive tasks
- Preview and print worksheets with correct page layout settings
- Configure headers and footers to provide context in printed sheets
- Customize your sheet layout for clean presentation
- Manage multiple sheets and workbooks efficiently
- Update workbook properties to maintain organized files
- What Is Microsoft Copilot Chat?
- The Magic Prompt Formula
- Work Smarter with AI
Who it's for
Beginners and occasional Excel users.
Before you start
- Basic computer literacy
- Basic PC operating system navigation skills
- Basic Internet usage skills
Related courses
More in Microsoft Office & 365 Apps →Intermediate
Excel Part 2 - Excel Intermediate
Microsoft Office & 365 Apps
View course →Advanced
Excel Part 3 - Advanced Excel
Microsoft Office & 365 Apps
View course →Intermediate
Excel - Pivot Tables and Conditional Formatting
Microsoft Office & 365 Apps
View course →Advanced
55205 Mastering Microsoft Project 2016
Microsoft Office & 365 Apps
View course →Intermediate
55234 SharePoint 2016 Site Collections and Site Owner Administration
Microsoft Office & 365 Apps
View course →Intermediate
55238 SharePoint Online for Administrators
Microsoft Office & 365 Apps
View course →Let's plan your next step together.
Tell us the course or certification you have in mind and we'll send the outline, upcoming dates, fees and private-team options.