This MS Excel tutorial provides everything from the basics to advanced-level topics that will help you learn Microsoft Excel and become a master in data analysis, and spreadsheet management.

Excel Basics

• Excel – Entering Values
• Excel – Moving Around
• Excel – Save Workbook
• Excel – Create Worksheet
• Excel – Copy Worksheet
• Excel – Hiding Worksheet
• Excel – Delete Worksheet
• Excel – Close Workbook
• Excel – Open Workbook
• Excel – Merge Workbooks
• Excel – File Password
• Excel – File Share
• Excel – Insert Data
• Excel – Select Data
• Excel – Delete Data
• Excel – Move Data
• Excel – Rows & Columns
• Excel – Copy & Paste
• Excel – Find & Replace
• Excel – Special Symbols
• Excel – Insert Comments
• Excel – Add Text Box
• Excel – Shapes
• Excel – Insert WordArt
• Excel – Undo Changes

Formatting Cells

• Excel – Setting Cell Type
• Excel – Move Or Copy Cells
• Excel – Add Cells
• Excel – Delete Cells
• Excel – Setting Fonts
• Excel – Text Decoration
• Excel – Rotate Cells
• Excel – Setting Colors
• Excel – Text Alignment
• Excel – Merge & Wrap
• Excel – Borders & Shades
• Excel – Apply Formatting

Formatting Worksheets

• Excel – Sheet Options
• Excel – Adjust Margins
• Excel – Page Orientation
• Excel – Header & Footer
• Excel – Insert Page Break
• Excel – Set Background
• Excel – Freeze Panes
• Excel – Conditional Format
• Excel – Highlight Cells Rules
• Excel – Data Bars

Working with Formula

• Excel – Formulas
• Excel – Creating Formulas
• Excel – Copying Formulas
• Excel – Formula Reference
• Excel – Relative Reference
• Excel – Absolute Reference
• Excel – Arithmetic Operators
• Excel – Parenthesis
• Excel – Using Functions
• Excel – BuitIn Functions
• Excel – Apply Formatting

Excel Formatting

• Excel – Formatting
• Excel – Format Painter
• Excel – Format Fonts
• Excel – Format Borders
• Excel – Format Numbers
• Excel – Format Grids
• Excel – Format Settings

Advanced Operations

• Excel – Data Filtering
• Excel – Data Sorting
• Excel – Using Ranges
• Excel – Data Validations
• Excel – Using Styles
• Excel – Using Themes
• Excel – Using Templates
• Excel – Workbook Security
• Excel – Data Tables
• Excel – Pivot Tables
• Excel – Simple Charts
• Excel – Pivot Charts
• Excel – Remove Duplicates