Learn Excel Basics By Examples

Learn Excel Basics By Examples

Step-By-Step Illustrated Guide To Mastering Excel. Master Excel in 11 Days


1. Ribbon: Quick Access Toolbar | Developer Tab
2. Workbook: Save in 97-2003 Format | View Multiple Workbooks | AutoRecover
3. Worksheets: Zoom | Split | Freeze Panes | Group Worksheets | Consolidate | View Multiple Worksheets | Get Sheet Name | Spelling
4. Format Cells: Decimal Places | Currency vs Accounting | Date and Time Formats | Fractions | Text to Numbers | Numbers to Text | Custom Number Format | Format Painter | Cell Styles | Themes | Wrap Text | Merge Cells | Strikethrough | Superscript and Subscript | Check Mark
5. Find & Select: Find Features | Delete Blank Rows | Row Differences | Copy Visible Cells Only | Search Box
6. Templates: Calendar | Budget | Meal Planner | Invoice | Automated Invoice | Default Templates | BMI calculator
7. Data Validation: Reject Invalid Dates | Budget Limit | Prevent Duplicate Entries | Product Codes | Drop-down List | Dependent Drop-down Lists | Kg to lbs
8. Keyboard Shortcuts: Function Keys | Insert Row | Save As | Delete Row | Scroll Lock | Bullet Points | Line Break | Show Formulas
9. Print: Workbook Views | Page Breaks | Headers and Footers | Page Numbers | Print Titles | Center on Page | Print Gridlines & Headings | Print Area
10. Share: Embed | PDF | Share Workbooks | OneDrive | Online | Import Access Data | Microsoft Query | Import/Export Text Files | XML
11. Protect: Protect Workbook | Protect Sheet | Lock Cells | Read-only Workbook | Mark as Final