Topics

• What is Excel?
• Use Excel as your calculator
• Add a watermark in Excel
• Merge and unmerge cells
• Insert or delete and Collaborate on Excel
• Move or copy, Selection, Hide or unhide worksheets or worksheet data
• Change the format of a cell and learn Tables in excel
• Ways of copy cell formatting in excel
• Create a chart from start to finish
• Available number formats in Excel
• Protect an Excel file
• Print a worksheet or workbook
• Formulas and functions in Excel
• How to avoid broken formulas in Excel
• SUM function
• IF function
• LOOKUP function
• How to correct a #N/A error
• Display or hide zero values
• Import and analyze data
• Create a PivotTable to analyze worksheet data
• Filter data in a range or table
• Use slicers to filter data
• Import or export text (.txt or .csv) files
• Filter for unique values or remove duplicate values
• Quick start: Create a macro
• Find or replace text and numbers on a worksheet
• Apply data validation to cells
• Lock or unlock specific areas of a protected worksheet
• Group or ungroup data in a PivotTable
• Create a PivotChart
• Use sparklines to show data trends
• Create a drop-down list
• Combine text from two or more cells into one cell
• Freeze panes to lock rows and columns
• Quick start: Sort data in an Excel worksheet
• Split data into multiple columns