Microsoft Excel

This Microsoft Excel online course will make it easy for you 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, color coding, and icons.

What you Get
 

• 1 x Hyperli code to redeem for the Microsoft Excel 

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

What’s Included?
 

• Unlimited lifetime access
• Access anywhere, any time
• Fast effective training, written and designed by industry experts
• Track your progress with our Learning Management System
• Unlimited support
• Save money, time and travel costs
• Learn at your own pace and leisure
• Easier to retain knowledge and revise topics than traditional methods