This course level covers all the basics of Microsoft Excel, and this course level also includes how to format text, data, and workbooks, insert graphics, pictures, charts, and add comments.

Target segment:

• For beginners who want to learn Microsoft Excel
• Microsoft Excel users who want to develop their skills and discover more and more new
• Students who need Microsoft Excel to make reports and analyze data

Axes of the course:

Basics:

This part of the course starts with covering how to sign in to a Microsoft account. It also covers Microsoft Excel file parts as well as how to create, open, and save files.

• Get started with Microsoft Excel
• Log in to your Microsoft account
• Create, open, and save workbooks Excel Workbooks
• Select parts of the Excel Workbooks workbook
• First workbook

The next part will be how to enter, select, and delete data. How to undo and repeat tasks are also covered, along with the use of cut, copy, and paste functions

• Enter, select and delete data
• Use cut, copy and paste
• Use undo and redo
• Work with data

This section covers inserting rows and columns as well as how to merge and divide cells. Additional topics include using "private paste", searching for, replacing, hiding, and showing cells

• Insert rows and columns
• Merge, split, and transfer cells
• Use private paste
• Use search and replace
• Hide and show cells

Using basic Excel tools:

In this section, cell references and formulas are covered, how to use basic formulas, how to learn basic functions, and how to check spelling are discussed. Also covered is how to use sorting and filtering tools to organize your data

• How cell references and formulas work
• Use basic formulas
• Using basic functions
• Do a spelling check
• Use sorting and filtering tools to organize your data

Using time saving tools:

Time saving is the focus of this part. Trainees will learn how to use AutoFill, Flash Fill, AutoSum, AutoComplete, and AutoCalculate

• Use AutoFill and Flash Fill
• Use AutoSum
• Use AutoComplete
• Use AutoCalculate

Text format:

Various ways to format and work with text are the main points of this part. All methods are changed to change font type, size, and color, apply text effects, add borders and fill cells. Other topics include using the Font tab in the Format Cells dialog box and how to clear formatting from text.

• Change the type, size and color of the text
• Apply text effects (such as bold, italic, and underline)
• Apply borders and fill cells
• Use the Font tab in the Format Cells dialog box
• Clears formatting from text
• Format the data

There are many ways to format data in Excel. This part of the course looks at how to adjust text wrapping, resizing rows and columns, adjust cell alignment, change text direction, and apply number formatting

• Set text wrapping options
• Resize rows and columns
• Cell alignment
• Change the text direction and number format
• Workbook format

This section will teach you how to use cell styles, format data as a table, and change the theme of a workbook. Page break insertion and background image addition

• Apply cell styles
• Format the data as a table
• Change the theme style of a workbook
• Insert page breaks in your worksheets
• Add a background image
• Insert pictures

In this part, you'll learn how to insert pictures into a workbook. Also, this section covers photo editing and formatting tools

• Insert an image from a computer or over the Internet
• Remove the background of the image
• Edit the color and effects of the image
• Apply the style to the image
• Cropping and resizing of the image
• Insert text boxes

In this part, you will learn how to insert ready text boxes or draw text boxes in a workbook. Also, this section covers tools for editing and formatting text boxes

• Insert ready text boxes or draw text boxes
• Format text boxes
• Apply text style and style
• Arrange the text boxes
• Add a SmartArt graphic

In this part, you will learn how to add a SmartArt in a workbook. Also, this section covers tools for editing and formatting SmartArt.

• Add a SmartArt
• Editing and arranging text in SmartArt
• Edit SmartArt layouts and style
• Insert Equations

In this part, you will learn how to include equations in a workbook. Also, this section covers the tools needed to add custom equations.

• Insert ready formulas
• Insert customized equations
• Insert shapes

This section shows how to add, edit, arrange, group, or dismantle shapes group or ungroup, add text to shapes, and how to rotate shapes.

• Insert shapes
• Editing shapes
• Arrange shapes
• Group or un-group forms
• Add text to shapes
• Rotate shapes
• Charting Data

Various ways of drawing data in Excel are covered in this section. Topics include how to create Sparklines and schedules, as well as how to insert charts and use Slicers

• Create Sparklines
• Sparklines format
• Insert charts charts
• Coordinate and edit charts diagrams
• Create timelines timelines

Use Comments:

Comments allow users to interact with materials and each other by adding messages to Excel files. This unit gives learners knowledge about how to insert, edit, navigate and delete comments

• Insert comments
• Editing comments
• Navigate through comments
• Delete comments

View, print, and share your Workbook workbook:

In this section, workbook views and sharing views are displayed. Topics include using views, saving a workbook as a PDF, printing and emailing a workbook, and sharing a workbook in OneDrive

• Use the different views provided in Excel
• Save the workbook as a PDF
• Print and email compilations
• Share your workbook on OneDrive
• Interface customization

The final part of this course focuses on ways to customize the interface. Includes how to change the ribbon display options and how to customize the Quick Access toolbar. It also covers how to hide and show ribbon tabs, and create custom ribbon tabs. How to reset the interface

• Change the ribbon display options
• Customize the Quick Access toolbar
• Hide and display tape tabs
• Create custom ribbon tabs
• Reset the interface back to its default appearance
• Course outcomes:
• The ability to use Microsoft Excel and learn about its basic functions
• Learn about the main parts of Microsoft Excel workbooks
• Learn about new features to save time
• Ability to use basic formulas and functions
• Ability to format text, data, and workbooks
• Ability to insert and format images, shapes, equations, and graphs
• The ability to add and comment comments
• The ability to customize the program interface