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
How to Redeem
Course Topics Covered:
What’s Included?
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
- The voucher is valid for 6 months from the date of purchase
- Redeem your Hyperli voucher & register online using the following link: https://e-courses4you.com/redeem-voucher/
- The course will appear in your account upon successful registration
- For further assistance with any queries about the course, email: support@e-courses4you.com
- No refunds or cancellations apply once your voucher has been purchased or redeemed ;
R86.09 Excl. VAT
R99.00 Incl. VAT
R4,100.00 Excl. VAT
R4,715.00 Incl. VAT
39% Off
Shop & Enjoy Now! Pay Later!
This offer is available nationwide – online redemption required.