Description

• 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?

 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

£199.00Add to basket