JN Training
Jeremy Nathan
Phone: 865-282-1895
Email: jnathan@jncomputertraining.com
Website: www.jncomputertraining.com/training
Microsoft Excel – Level 1 Foundation
Laptops are provided to use with on-site, classroom training
Everyone receives a physical workbook, 8 hours, $225 per person
Developing a Workbook
Menus
Save in PDF format
Password Protection
Insert rows and sheets
Rename and delete sheets
Moving and sheet colors
Borders
AutoFit columns
Navigate
Name box
Shortcuts
Zoom
Custom Header/Footer
Charts and Sparklines
Watermark for printing
Formulas
Autofill
Remove Duplicates
Quick Access Toolbar
Customize Ribbon Tabs
Customize status bar
Paste Special & Transpose
Number Formatting
Hide columns and rows
Print & Formatting
Page Layout and Margins
Comments
Hyperlinks
Custom cell styles
Freeze data
Split Frames