Menu
Menu
  • No products in the basket.

MS Excel 2013 Intermediate

0( 0 REVIEWS )
115 STUDENTS
ACCREDITED BY
MS Excel 2013 Intermediate

Overview:

The Microsoft Excel 2013 Intermediate course will teach you the intermediate features and functions of Excel. You will learn to advanced formats and layouts. If you have basic experience this course will help you easily apply Excel skills in an office environment. The Microsoft Excel 2013 Intermediate is aimed at individuals who want to use MS Office programs in the workplace environment efficiently and effectively.

The Microsoft Excel 2013 Intermediate course will cover topics like how to manage, filter and generate reports, and learn how to summarise and analyse data using tools like Pivot Tables. You will gain an understanding on how to automate repetitive tasks and create macros, and how to protect workbooks and worksheets.  As it is a must have Office skill, you will learn to use the application effectively whether it is for personal or business use.

We recommend that learners review the exam preparation tutorial and become familiar with the resources before scheduling the exam. In addition, extra time will be given so that you can enjoy the flexibility of training and studying at your own convenience. The course is internationally recognised and accredited to a training organisation and you will be issued an internationally recognised qualification following full completion of Microsoft Excel 2013 Intermediate course.

Why consider 1Training?

As improvements and advancements are made in technology, online courses are no longer just conventional means of studying at affordable costs. In many aspects online training offers superiority to traditional learning. There is an effectiveness and convenience that traditional learning cannot provide. The overall convenience and flexibility makes it a superior learning method.

1Training offers the most convenient path to gain an internationally recognised qualification that will give you the opportunity to put into practice your skill and expertise in an enterprise or corporate environment. You can study at your own pace at 1Training and you will be provided with all the necessary material, tutorials, qualified course instructor and multiple free resources which include Free CV writing pack, Nus Discounted Card, Free career support and course demo to make your learning experience enriching and more rewarding.

Learning Outcomes

  • Learn how to share and link data.
  • Learn how to review and protect content.
  • Gain an understanding of advanced formulas and functions.
  • Learn how to use Pivot Charts and Pivot Tables.
  • Learn how to use advanced formats and layouts.

Course Titles

  • Module 01: Creating Advanced Formulas
  • Module 02: Logical and Lookup Functions
  • Module 03: Organizing Worksheet Data with Tables
  • Module 04: Visualizing Data with Charts
  • Module 05: PivotTables, Slicers, and PivotCharts
  • Module 06: Inserting Graphics
  • Module 07: Enhancing Workbooks

Access Duration

The course will be directly delivered to you, and you have 12 months access to the online learning platform from the date you joined the course.  The course is self-paced and you can complete it in stages, revisiting the lectures at anytime.

Who is this Course aimed at?

  • The course is aimed at individuals with a background in Microsoft Excel skills.
  • Individuals who want to advance their knowledge in Excel.
  • The course is suitable for students who want to gain an understanding in Excel.
  • The course is suitable for anyone with an interest in Microsoft Excel 2013.

Entry Requirements

  • You must be over the age of 16 and have a basic understanding of Maths, English and ICT
  • Job seekers / school leavers

Method of Assessment

At the end of the Microsoft Excel 2013 Intermediate course you will be required to take a multiple choice question assessment test. The multiple choice question assessment will be automatically marked with learners receiving an instant grade.

Certification

Those who successfully complete the exam will be awarded the certificate in Microsoft Excel 2013 Intermediate. You will receive a free e-certificate and you can purchase a printed certificate, as well.

Awarding Body

The certificate will be awarded by CPD and iAP. This internationally recognised qualification will make your CV standout and encourage employers to see your motivation at expanding your skills and knowledge in the IT enterprise.

Progression and Career Path

Once you successfully complete Microsoft Excel 2013 Intermediate you will be qualified to work in the following positions. The Microsoft Excel 2013 Intermediate qualification will also put you in line to demand a higher salary or job promotion. The average UK salary per annum according to https://www.payscale.com is given below.

Other jobs you can get

  • Microsoft Developer
  • Microsoft Specialist
  • Office Specialist

Other Benefits

  • Written and designed by the industry’s finest expert instructors with over 15 years of experience
  • Repeat and rewind all your lectures and enjoy a personalised learning experience
  • Gain access to quality video tutorials
  • Unlimited 12 months access from anywhere, anytime
  • Excellent Tutor Support Service (Monday to Friday)
  • Save time and money on travel
  • Learn at your convenience and leisure
  • Quizzes, tests mock exams, practice exams to ensure you are 100% ready
  • Eligible for a TOTUM discount card

Key Features

Gain an accredited UK qualification

Access to excellent quality study materials

Learners will be eligible for TOTUM Discount Card

Personalized learning experience

One year’s access to the course

Support by phone, live chat, and email

Course Curriculum Total Units : 93
➤ Module 01: Creating Advanced Formulas
Course Introduction
1.0 Topic A: Apply Range Names
1.1 Worksheet without Range Names
1.2 Worksheet with Range Names
1.3 Excel 2013’s Save Options
1.4 Where to Access Saved Versions
1.5 Demo 1-1: Adding Range Names
1.6 Demo 1-2 and 1-3: Editing and Deleting a Range Name
1.7 Demo 1-4: Using Range Names in a Formula
2.0 Topic B: Use Specialized Functions
2.1 The Function Library
2.2 Logical Functions
2.3 Statistical Functions
2.4 Syntax of the AVERAGE Function
2.5 The Insert Function Dialog Box
2.6 The Function Arguments Dialog Box
2.7 Demo 1-5: Locating Functions by Using the Function Reference
2.8 Demo 1-6: Using Functions
2.9 Lesson 01 Review
➤ Module 02: Logical and Lookup Functions
1.0 Topic A: Leverage Questions and Testing to Write Formulas
2.0 Topic B: Use Logical and Lookup Functions to Find Answers to Questions
2.1 Logical Functions
2.2 Demo 2-1: Working with Logical Functions
2.3 Demo 2-2: Combining IF and AND Functions
2.4 The VLOOKUP Function
2.5 The HLOOKUP Function
2.6 Demo 2-3: Working with Lookup Functions
2.7 Lesson 02 Review
➤ Module 03: Organizing Worksheet Data with Tables
1.0 Topic A: Create and Modify Tables
1.1 A Sample Table
1.2 The Create Table Dialog Box
1.3 The TABLE TOOLS DESIGN Contextual Tab
1.4 Demo 3-1: Converting a Range to a Table
2.0 Topic B: Sort and Filter Data
2.1 Data Sorted on a Single Column
2.2 Data Sorted on Multiple Columns
2.3 Filtered and Sorted Data
2.4 Advanced Filter with Three Criteria
2.5 Demo 3-2: Sorting Data and Removing Duplicate Records
2.6 Demo 3-3: Filtering Records
3.0 Topic C: Use Summary and Database Functions to Calculate Data
3.1 The SUBTOTAL Function
3.2 Demo 3-4: Using Subtotals with Range Data
3.3 Summary Functions in Table Total Row: Example 1
3.4 Summary Functions in Table Total Row: Example 2
3.5 Compare SUM to DSUM
3.6 Demo 3-5: Using Summary Functions in Tables
3.7 Demo 3-6: Using Database Functions
3.8 Lesson 03 Review
➤ Module 04: Visualizing Data with Charts
1.0 Topic A: Create Charts
1.1 Data in a Table
1.2 Data in a Chart
1.3 The Insert Chart Dialog Box
1.4 Demo 4-1: Creating Charts
2.0 Topic B: Modify and Format Charts
2.1 Demo 4-2: Modifying Charts
2.2 Demo 4-3: Formatting Charts
3.0 Topic C: Create a Trendline
3.1 Trendlines Forecasting Out Two Years
3.2 The Format Trendline Dialog Box
3.3 Demo 4-4: Creating a Trendline
4.0 Topic D: Create Advanced Charts
4.1 A Dual-Axes Chart
4.2 Demo 4-5: Creating a Dual-Axes Chart
4.3 Lesson 04 Review
➤ Module 05: PivotTables, Slicers, and PivotCharts
1.0 Topic A: Create a PivotTable
1.1 A Standard Table
1.2 A PivotTable
1.3 The PivotTable Field List Pane
1.4 The Summarize Values by Options
1.5 Summarizing Values by Using the MIN Function
1.6 The Show Values as Options
1.7 Showing Values as a Percent of the Grand Total
1.8 Combining Summarize and Show (Example 1)
1.9 Combining Summarize and Show (Example 2)
1.10 Demo 5-1: Creating PivotTables
2.0 Topic B: Filter Data by Using Slicers
2.1 Slicers and a PivotTable
2.2 Demo 5-2: Adding Slicers
3.0 Topic C: Analyze Data by Using PivotCharts
3.1 Slicers and a PivotChart
3.2 Demo 5-3: Creating a PivotChart
3.3 Lesson 05 Review
➤ Module 06: Inserting Graphics
1.0 Topic A: Insert and Modify Graphic Objects
1.1 The INSERT Tab’s Illustration Group
1.2 Types of Shapes
1.3 Demo 6-1: Inserting Pictures and Clip Art
2.0 Topic B: Layer and Group Graphic Objects
2.1 Layers
2.2 A Hidden Layer
2.3 The Same Layers in a New Stacking Order
2.4 Three Graphic Objects, No Grouping
2.5 Three Graphic Objects in One Group of Three
2.6 Demo 6-2: Inserting and Grouping Shapes
3.0 Topic C: Incorporate SmartArt
3.1 The Choose a SmartArt Graphic Dialog Box
3.2 Demo 6-3: Incorporating SmartArt
3.3 Lesson 06 Review
➤ Module 07: Enhancing Workbooks
1.0 Topic A: Customizing Workbooks
1.1 A Comment
1.2 Demo 7-1: Inserting Comments and Hyperlinks
2.0 Topic B: Manage Themes
2.1 Built-in Themes
2.2 Demo 7-2: Applying and Editing a Theme
3.0 Topic C: Create and Use Templates
3.1 An Expense Report Template
3.2 Demo 7-3: Creating a Template
4.0 Topic D: Protect Files
4.1 File Protection Options
4.2 The REVIEW Tab’s Changes Group
4.3 The Protect Sheet Dialog Box
4.4 The Protect Structure and Windows Dialog Box
4.5 Demo 7-4: Protecting a Worksheet and a Workbook
4.6 Lesson 07 Review
4.7 Course Closure
WhatsApp chat