Microsoft Excel Tutorials

MS Excel Basics

• Excel – Getting Started
• Excel – Explore Window
• Excel – Backstage
• Excel – Entering Values
• Excel – Move Around
• Excel – Save Workbook
• Excel – Create Worksheet
• Excel – Copy Worksheet
• Excel – Hiding Worksheet
• Excel – Delete Worksheet
• Excel – Close Workbook
• Excel – Open Workbook
• Excel – Context Help

MS Excel Editing Worksheet

• Excel – Insert Data
• Excel – Select Data
• Excel – Delete Data
• Excel – Move Data
• Excel – Rows & Columns
• Excel – Copy & Paste
• Excel – Find & Replace
• Excel – Spell Check
• Excel – Zoom In-Out
• Excel – Special Symbols
• Excel – Insert Comments
• Excel – Add Text Box
• Excel – Undo Changes

MS Excel Formatting Cells

• Excel – Setting Cell Type
• Excel – Setting Fonts
• Excel – Text Decoration
• Excel – Rotate Cells
• Excel – Setting Colors
• Excel – Text Alignments
• Excel – Merge & Wrap
• Excel – Borders and Shades
• Excel – Apply Formatting

MS Excel Formatting Worksheets

• Excel – Sheet Options
• Excel – Adjust Margins
• Excel – Page Orientation
• Excel – Header and Footer
• Excel – Insert Page Breaks
• Excel – Set Background
• Excel – Freeze Panes
• Excel – Conditional Format

MS Excel Working with Formula

• Excel – Creating Formulas
• Excel – Copying Formulas
• Excel – Formula Reference
• Excel – Using Functions
• Excel – Builtin Functions

MS Excel Advanced Operations

• Excel – Data Filtering
• Excel – Data Sorting
• Excel – Using Ranges
• Excel – Data Validation
• Excel – Using Styles
• Excel – Using Themes
• Excel – Using Templates
• Excel – Using Macros
• Excel – Adding Graphics
• Excel – Cross Referencing
• Excel – Printing Worksheets
• Excel – Email Workbooks
• Excel- Translate Worksheet
• Excel – Workbook Security
• Excel – Data Tables
• Excel – Pivot Tables
• Excel – Simple Charts
• Excel – Pivot Charts
• Excel – Keyboard Shortcuts

MS Excel Resources

• Excel – Quick Guide