Microsoft Excel Online Course

Please Note: This deal is for a coupon code to redeem online - see your coupon for redemption instructions after purchasing.

• 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

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 Pate 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 Forumla – 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:

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