Microsoft Excel Course (Beginner - Intermediate) - The Leading Global Excel Training Platform
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
Description
Unlock the secrets of Excel and learn:
- 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.
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
Who is this course for?
This course is perfect for complete beginners or intermediate users looking to fill the gaps in their knowledge.
Requirements
Microsoft Excel (PC: 2003, 2007,2010,2013 and 2016/365 , Mac: 2011, 2016)
Questions and answers
Currently there are no Q&As for this course. Be the first to ask a question.
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.