Microsoft Excel Course Bundle (Beginner - Advanced)
The Leading Global Excel Training Platform **Limited Time Only**
Skillsology
Summary
Overview
Cut Excel down to size with our personalised online course. Whether you are a beginner or have been using Excel for years you can take your spread sheeting skills to the next level with Skillsology.
Our syllabus is uniquely refined using Filtered technology. According to your preferences, we distil the syllabus, ensuring that you learn only the most useful elements of Excel. With hours of material available, you can work on functions, graphs, PivotTables, macros and many more subjects.
CPD
Course media
Description
Excel
- How Excel works, how to navigate and design a spreadsheet.
- The most popular formulas including IF, VLOOKUP, COUNT, SUM, SUMIF.
- To use PivotTables, Pivot Charts and basic Macros.
- To create beautiful looking graphs and charts.
- Formatting, including; conditional, cell and number formatting.
- How to print what you actually want.
Advanced Excel
- To use advanced graphs and presentation techniques
- How macros and VBA automate your spreadsheets and increase interactivity
- How superpower functions can solve complex problems
- To use PivotTables and PowerPivots to turn raw data into clear information that supports key decisions
Excel Syllabus:
Section 1: Foundation
Unit 1.1 - Excel Introduction
Unit 1.2 - The Excel Interface
Unit 1.3 - Basic Navigation and Editing
Unit 1.4 - Getting Going
Section 2: Orientation & efficiency
Unit 2.1 - Editing
Unit 2.2 - Viewing
Unit 2.3 - Spreadsheet Structure
Unit 2.4 - Cell References
Unit 2.5 - Named Ranges
Unit 2.6 - Basic Macros
Unit 2.7 - Design
Section 3: Administration
Unit 3.1 - Customising Excel
Unit 3.2 - Housekeeping
Unit 3.3 - Connecting Workbooks
Unit 3.4 - Documentation
Unit 3.5 - Protecting and Sharing
Unit 3.6 - Google Docs
Unit 3.7 - Excel Troubleshooting
Section 4: Data Handling
Unit 4.1 - Sorting and Filtering
Unit 4.2 - Controlling User Input
Unit 4.3 - Working with Dates & Times
Unit 4.4 - Working with Text
Unit 4.5 - Lookup and Reference
Unit 4.6 - Logical Functions
Section 5: Data Analysis
Unit 5.1 - Working with Numbers
Unit 5.2 - Summarising Data
Unit 5.3 - PivotTables 1 - Simple Summaries
Unit 5.4 - PivotTables 2 - Manipulating Data
Unit 5.5 - PivotTables 3 - Interpreting Data
Unit 5.6 - PowerPivot: Handling Big Data
Unit 5.7 - Formula Auditing
Unit 5.8 - Advanced Macros and VBA
Unit 5.9 - Modelling
Section 6: Presentation
Unit 6.1 - Cell Formatting
Unit 6.2 - Number Formatting
Unit 6.3 - Conditional Formatting
Unit 6.4 - Graphs and Charts
Unit 6.5 – Page and print setup
Advanced Excel Syllabus:
Section 1: Design and Risk
Unit 1.1 - Templates
Unit 1.2 - Efficiency and Risk
Unit 1.3 - Data Validation
Section 2: Advanced Techniques
Unit 2.1 - Functions and Superpowers
Unit 2.2 - Array Formulae
Unit 2.3 - Tables
Unit 2.4 - Advanced Range Names
Unit 2.5 - What If?
Unit 2.6 - Problem Solving?
Section 3: Excel Interactivity
Unit 3.1 - Form Controls
Unit 3.2 - Visual Basic and Macros
Section 4: Spreadsheet Impact
Unit 4.1 - Practical Interactivity with VBA
Unit 4.2 - Conditional Formatting
Unit 4.3 - Charts that Inspire
Unit 4.4 - Sparklines
Unit 4.5 - Graphics Tricks and Techniques
Unit 4.6 - Working with External Data
Section 5: Turning Data into Decisions
Unit 5.1 - Advanced Uses of PivotTables
Unit 5.2 - PowerPivot
Unit 5.3 - Reporting with PowerPivot
Who is this course for?
Suitable for all levels of Excel user
Requirements
Microsoft Excel (2003, 2007,2010,2013 and 2016/365 PC, Mac: 2011, 2016)
Questions and answers
I want to purchase an Excel bundle that states it is compatible for MAC 2011 and 2016. Mine is a MACBook Air late 2010. Will it be okay, still?
Answer:Good afternoon. Thank you for contacting us, Correct! This Microsoft Excel course its compatible with Mac either 2011 or 2016. You will have some struggles as the functions will be slightly different. I suggest downloading the 2011 or 2016 for a better result! Let me know if you have further questions. Thank you.
This was helpful.Hi, I am trying to book a member of staff onto this course, do you accept official purchase orders to book them on and invoice us to pay you?
Answer:Good morning. Thank you for contacting us, Please note you will need to purchase each this for each individual that will be taking the course. Also, this will need to be purchased directly through Redd, so the payment method will need to discuss with them as we are only the course providers. Please let us know if you have any additional questions so we may assist. Kind regards.
This was helpful.
Reviews
Currently there are no reviews for this course. Be the first to leave a review.
Legal information
This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.
FAQs
Interest free credit agreements provided by Zopa Bank Limited trading as DivideBuy are not regulated by the Financial Conduct Authority and do not fall under the jurisdiction of the Financial Ombudsman Service. Zopa Bank Limited trading as DivideBuy is authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority and the Prudential Regulation Authority, and entered on the Financial Services Register (800542). Zopa Bank Limited (10627575) is incorporated in England & Wales and has its registered office at: 1st Floor, Cottons Centre, Tooley Street, London, SE1 2QG. VAT Number 281765280. DivideBuy's trading address is First Floor, Brunswick Court, Brunswick Street, Newcastle-under-Lyme, ST5 1HH. © Zopa Bank Limited 2024. All rights reserved.