• Mon - Saturday 08.00 - 20.00
  • 1st Floor North Westgate House, the High, Harlow, ESSEX, CM20 1YS
  • 0330 0240 989
  • [email protected]

Microsoft Excel 2013

Microsoft Excel 2013
Learn how to competently use Excel 2013’s many powerful features and make the most of this popular spreadsheet program. Excel is an incredibly powerful tool for getting meaning out of data, as well as making calculations and tracking information. This latest version has many new features that allow you to manipulate your data in new ways and guide you to make better, more informed decisions based on your calculations. A thorough understanding of Excel and its many applications adds to your professional skill set can boost your career by making you more attractive to potential employers. Comprehensive and convenient The course is broken down into 3 comprehensive modules covering basic, intermediate and advanced uses of Excel 2013. You can spend as little or as much time on each module as you feel is necessary – simply log in and out of your course at your convenience. The flexible nature of the course means you can learn at your own pace depending on other commitments. The nature of online learning enables you to study anywhere and at any time.

KEY LEARNING POINTS

The course covers the skill sets required by business analysis professionals based on the industry recognised standards set by the IIBA. Focus areas include:
  • Excel 2013 Basic: Explore the basic concepts of Excel 2013 in this module. Learn how to create, open and save workbooks; how to enter and edit data; the use of formatting, headers and footers; working with columns and rows; using autofill and sorting and filtering data.
  • Excel 2013 Intermediate: Discover how Excel can transform raw data into reports using charts and graphs, formulas and functions and named ranges. Learn about data validation, sparklines, conditional formatting, comments, protecting a workbook and more.
  •   Excel 2013 Advanced: Learn advanced Excel techniques and push your skill set to the next level. Create custom lists, use advanced forms and formulas, learn how to use the Watch Window, pivot tables and macros, and how to work with external data sources.

ADVANTAGES OF THIS COURSE

  • Comprehensive high quality e-learning content delivered in 3 manageable modules
  •  Boost your education and job prospects. Develop skills and qualifications to take you to the next step in your career
  • Learn at your own pace and fully understand each module before moving on
  •   Our technical support team will be on hand to offer you advice and guidance via telephone email
  •  Test yourself and receive a certificate online. Multiple choice style questioning will help you learn and remember
  •  Invest in this course now and boost your job prospects with skills vital for the modern workplace.

Get Certified with WGS Career Academy today!

It’s simple, effective and affordable.

Units of Study

  • Introduction
  • Create Workbook
  • Opening an Existing Workbook
  • Saving a workbook
  • Entering and editing data
  • Formatting
  • Headers & Footers
  • Copy, pasting and moving data
  • Working with columns and rows
  • Using Autofil
  • Preview and Printing
  • Formula and Functions
  • Sorting and Filtering Data
  • Charts and Graphs
  • Named Ranges
  • Intermediate Formula and Functions
  • Formula Auditing
  • Outline Groups
  • Data Validation
  • Sparklines
  • Conditional Formatting
  • Comments
  • Protecting a workbook
  • Create Custom Lists
  • Forms
  • Advanced Formula and Functions
  • Using the Watch Window
  • Scenarios
  • Goal Seek
  • Solver
  • Pivot Tables
  • Macros
  • Working with External Data sources

Curriculum

Curriculum is empty

Review and Rating

0

Average Rating

0 rating
5 stars
0
4 stars
0
3 stars
0
2 stars
0
1 star
0

Course fee

£40£250.00
14-days Money back
  • Lectures
    Warning: preg_match() expects parameter 2 to be string, array given in /home/wgscaree/public_html/wp-includes/class-wp-block-parser.php on line 417

    Warning: strlen() expects parameter 1 to be string, array given in /home/wgscaree/public_html/wp-includes/class-wp-block-parser.php on line 489
    0
  • Quizzes
    Warning: preg_match() expects parameter 2 to be string, array given in /home/wgscaree/public_html/wp-includes/class-wp-block-parser.php on line 417

    Warning: strlen() expects parameter 1 to be string, array given in /home/wgscaree/public_html/wp-includes/class-wp-block-parser.php on line 489
    0
  • Duration 12 hour
  • Skill level All levels
  • Max Students 1000
  • Language English

COURSE CODE

EC112116

TYPE

Online Course

COURSE ACCESS

1 Year

EXAMS INCLUDED

No
ASSOCIATED EXAMINATION
Microsoft Office Specialist Exam (Excel)

CERTIFICATION

    No

SYSTEM REQUIREMENT

PROCESSOR

1 gigahertz (GHz)

RAM

1 GB

OPERATING SYSTEMS

Windows 7 Windows 8 Windows 10

BROWSERS

Internet Explorer 8 or above Google Chrome Safari 6 or above Mozilla Firefox

COMPATIBILITY

Windows, Mac
  • Contact via:

SIGN IN

Forgot Password

Do not have an account? Register Now

X

ENQUIRY FORM

Complete the form below to receive more details about this course.

Yes, I’d like wgscareeracademy.com to contact me via email.

0330 0240 989