100 megs data gift for every genuine quote requested
If you use Excel 2013 every day, then having the skills in the program will make you more valuable and give you the confidence required to take on more high-level tasks and projects.
The Microsoft Excel 2013 Intermediate Training Course provides you with comprehensive training in the features of Excel 2013, including creating and running Macros, Flash Fill, auditing, formulas and functions, data management, customisation, grouping and transporting data and solving errors.
This dynamic training course is available now Gauteng, Durban and Cape Town.
Contact us today for a group quote.
Who Should Attend
The Excel Intermediate course is suited to students who have either attended an Excel Basic course or those who are experienced in working with Excel spreadsheets and have a fairly good understanding of the features and tools of Excel.
Students attending this course are generally working with large amounts of data and are required to summarise and manipulate the information quickly.
They are looking for tools and/or techniques to speed up their processes to manage and manipulate their work-related data utilised within their current workflows.
These students are familiar with creating basic formulas and want to implement them more effectively.
As a result of this course, students will be able to manage multiple worksheets and workbooks including construction of formulas across worksheets.
They will learn how to utilise Excel’s formatting features, manage large amounts of data, sort data, filter data, outline and subtotal their spreadsheets.
Competency will also be gained in charting, auditing techniques and greater understanding of constructing formulas
Learning Outcomes - Microsoft Excel 2013 Intermediate Training Course
This extensive Intermediate training course in Excel 2013 helps develop basic skills and understanding of the application. After this course, participants will have gained expertise in using Excel 2013.
After completing this course, participants will have learned to:
- Create advanced formulas.
- Analyse data with logical and lookup functions.
- Organise worksheet data with tables.
- Visualise data by using charts.
- Analysing data with Pivot Tables, slicers, and Pivot Charts.
- Insert graphic objects.
- Enhance workbooks.
Course Content - Microsoft Excel 2013 Intermediate Training Course
Lesson 1: Creating Advanced Formulas
Topic A: Apply Range Names
Topic B: Use Specialised Functions
Lesson 2: Analysing Data with Logical and Lookup Functions
Topic A: Leverage Questions and Testing to Write Formulas
Topic B: Use Logical and Lookup Functions to Find Answers to Questions
Lesson 3: Organising Worksheet Data with Tables
Topic A: Create and Modify Tables
Topic B: Sort and Filter Data
Topic C: Use Summary and Database Functions to Calculate Data
Lesson 4: Visualising Data with Charts
Topic A: Create Charts
Topic B: Modify and Format Charts
Topic C: Create a Trendline
Topic D: Create Advanced Charts
Lesson 5: Analysing Data with Pivot Tables, Slicers, and Pivot Charts
Topic A: Create a Pivot Table
Topic B: Filter Data by Using Slicers
Topic C: Analyse Data by Using Pivot Charts
Lesson 6: Inserting Graphics
Topic A: Insert and Modify Graphic Objects
Topic B: Layer and Group Graphic Objects
Topic C: Incorporate SmartArt
Lesson 7: Enhancing Workbooks
Topic A: Customise Workbooks
Topic B: Manage Themes
Topic C: Create and Use Templates
Topic D: Protect Files