Microsoft Excel course

Excel makes it easy to crunch numbers. With Excel, you can streamline data entry with AutoFill. Then, get chart recommendations based on your data, and create them with one click. Or, easily spot trends and patterns with data bars, colour coding, and icons.

What you Get
 

• 1 x Hyperli code to redeem for the Microsoft Excel course

How to Redeem
 

• Look over the fine print for information on how you can redeem your voucher

Course Topics Covered:
 

• Introduction
• What is Excel
• Workbooks
• Ribbons
• File Menu
• Cells & Formatting Data Types
• Formula Bar
• Name Box
• Navigating & Selecting Cells
• Getting Started Excel 2019
• Opening a Workbook
• Manually Entering Data
• Autofill
• Saving to OneDrive
• Closing Workbooks
• Using Tell Me or Help
• Selecting Non-Adjacent Cells & Entire Sheet
• Intro to Cut Copy & Paste
• Cut Copy Paste Keyboard Shortcuts
• Selecting Non-Adjacent Cells
• Cut Copy Paste Ribbon Tools
• Cut Copy Paste Context Menu
• Selecting using Shift & Arrow Keys
• Using Flash Fill
• Multiple Columns of Info
• Tidying Daya
• Intro to Autofill
• Using Autofill for Sequential Lists
• Using Autofill for Spaced Series
• Copying with Autofill
• Creating a Custom Autofill List
• Intro to Find & Replace
• Using Find & Replace
• Spellcheck in Excel
• Undo & Redo in Excel
• Inserting & Deleting Worksheets
• Inserting Rows & Columns & Hide & Unhide
• Adjusting Column Width & Row Height
• Intro to Relative & Absolute Cell References
• Relative Cell References
• Absolute Cell References
• Intro to BODMAS
• Brackets within a Formula – BODMAS
• Additional Brackets – BODMAS
• Orders – Summing & Cubing – BODMAS
• Multiply & Division – BODMAS
• AutoCalculate
• Add & Subtract – BODMAS
• Intro to Functions and Formulas
• Insert Functions
• Copy Formulas
• Intro to Formatting an Excel Worksheet
• Fonts & Borders
• Fill Colours & Cell Alignment
• Number Format & Cell Styles