Microsoft Excel Basics

Professional Knowledge of Spreadsheet Application

• Open MS Excel and create a new Excel file or from a template
• Import data from txt files, csv files, and other sources

Navigating Workbooks

• Search data within workbooks
• Navigate to named cells, ranges, or workbook elements
• Insert and remove hyperlinks

Formatting Worksheets and Workbooks

• Modify page setup
• Adjust row height and column width
• Customize headers and footers

Customizing Options and Views

• Display and modify content in different views
• Freeze rows and columns
• Change window views
• Modify basic workbook properties
• Display formulas

Configuring Content for Collaboration

• Set a print area
• Save workbooks in alternative file formats
• Configure print settings

Manipulating Data

• Paste data using special paste options
• Fill cells using Auto Fill
• Insert and delete multiple columns or rows
• Insert and delete cells

Formatting Cells and Ranges

• Merge and Unmerge cells
• Modify cell alignment, orientation, and indentation
• Format cells using Format Painter
• Wrap text within cells
• Apply number formats
• Apply cell formats from the Format cells dialog box
• Apply cell styles
• Clear cell formatting

Defining and Referencing Named Ranges

• Define a named range
• Name a table
• Summarize data visually
• Insert spark lines
• Apply built-in conditional formatting
• Remove conditional formatting

Managing Tables and Table Data

• Create excel tables from cell ranges
• Apply table styles
• Convert tables to cell ranges
• Add or remove table rows and columns
• Configure table style options
• Insert and configure total rows
• Filter records
• Sort data by multiple columns

Performing Operations using Formulas and Functions

• Insert relative, absolute, and mixed references
• Reference named ranges and named tables in formulas
• Perform calculations using AVERAGE(), MIN(), MAX(), and SUM()
• Count cells by using COUNT(), COUNTIF(), and COUNTBLANK()
• Perform conditional operations using the IF() function

Formatting and Modifying Text

• Format text using RIGHT(), LEFT(), and MID() functions
• Format text using UPPER(), LOWER(), and LEN() functions
• Format text using CONCAT() and TEXTJOIN() functions

Managing Charts

• Create charts
• Create chart sheets
• Add data series to charts
• Switch between rows and columns in source data
• Add and modify chart elements
• Add trend lines to charts
• Apply chart layouts
• Apply chart styles
• Add alternative text to charts for accessibility

Managing Pivot Tables

• Create Pivot tables from cell ranges
• Manipulate fields (columns) to get desired analysis
• Use Filters for pivot tables
• Represent data as Count, Sum, Average, and % of row / column
• Group data in Columns & rows for aggregate reports