Microsoft Excel Foundational Skills
Navigate, Create, and Calculate Like a Pro in Microsoft Excel
This course is about building a strong foundation of skills. Whether you're a beginner in Excel, or you've taught yourself how to use it, there are a set of tools - keyboard shortcuts, best practices, and calculations - that everyone should have in their toolbelt. This course strives to set the stage for the incredible, powerful features of Excel. This course is for you if:
- You're new to the program;
- You want to navigate, select, and edit content like a pro;
- Your calculations sometimes have errors in them;
- You find yourself re-typing things; or
- You think there are keyboard shortcuts to perform the same steps.
This course is not for you if:
- You feel completely confident navigating, selecting, and editing content with the keyboard, instead of the mouse;
- You understand the difference between absolute and relative references;
- You can sort and filter information quickly and easily; and
- You're in control of your spreadsheets' themes.
Your Instructor
Neil Malek has been teaching software courses for professionals for twenty years. As a Microsoft Certified Trainer, Microsoft Certified Technology Specialist, Microsoft Certified Professional Developer, Adobe Certified Instructor, Adobe Certified Instructor, and CompTIA Certified Technical Trainer, he covers a range of topics from Microsoft and Adobe software, to Google and third-party software services, to professional skills like presentation design and public speaking. He's been running Knack Training for the last five years, and is thrilled to get some of his best live material into these videos.
Course Curriculum
-
StartL14 Saving (9:41)
-
StartL15 File Compatibility (6:15)
-
StartL16 Move and Copy Calculations (3:56)
-
StartL17 AutoFill (15:37)
-
StartL18 Insert Rows and Columns (5:00)
-
StartL19 Insert Sheets (5:30)
-
StartL20 Freeze and Split (6:20)
-
StartL21 Hide Columns (2:37)
-
StartL22 Find and Replace (8:37)
-
StartL23 Printing (9:17)
-
StartL24 Formatting (8:46)
-
StartL25 Styles and Themes (9:40)
-
PreviewL26 Number Formatting (11:21)
-
StartB03 Custom Themes (10:17)