Excel 2013 Advanced

Was bietet Ihnen dieser Kurs?

In this elearning course, you will learn advanced techniques for working with Microsoft Excel 2013. You will import and export data and use style sheets. You will learn how to deal with filters and functions. In addition, you will deal with the topic of Pivot Tables and Pivot Charts, which allow flexible and intelligent evaluation of your data. You will find out how calculations can be visualised using professional-looking charts. In your calculations, you will draw on values from various spreadsheets. Finally, you will learn about the wide range of options for working with the date and time.


Kurs Eckdaten

In addition to the instructional content, practice exercises and test questions are also included.

54
NUMBER OF LESSONS
6
LEARNING HOURS
3
AUDIO HOURS
 


Der Lerninhalt im Wesentlichen

  • Naming cell ranges
  • Formatting cells by formula results
  • Creating custom cell formats
  • Conditional formatting
  • Pasting content
  • Importing and exporting files
  • Hiding and unhiding table areas
  • Calculating subtotals
  • Data tables for calculations
  • Protecting workbooks

  • Custom sorting
  • Advanced filter techniques
  • The search filter
  • Using cell references in other worksheets
  • Using cell references to other workbooks
  • Editing links
  • Creating and assigning styles
  • Creating templates
  • Creating workbooks with templates

  • Date and time functions
  • Creating interlaced functions
  • Mathematical functions
  • Statistical functions
  • Financial functions
  • VLOOKUP function
  • The HLOOKUP function
  • Logical functions
  • Using formula auditing

  • Inserting PivotTables
  • Allocating PivotFields
  • Defining PivotTable layout
  • Filtering PivotTables
  • Working with slicers
  • Updating PivotTables
  • Sorting PivotTables
  • Creating a drilldown
  • Creating PivotCharts

  • Inserting screenshots
  • Showing equations in text boxes
  • Adding comments to tables
  • Carrying out validation checks on data entry
  • Checking data’s validity
  • Allowing data entry from a list
  • Using hyperlinks

  • Basic information on time calculations in Excel
  • Carrying out simple operations with time information
  • Working with date and time functions
  • Practical applications

Systemanforderungen Client

Windows

  • Windows XP / Vista / 7 / 8
  • Internet Explorer 7 / 8 / 9* / 10* /11*
  • Firefox 10 oder höher
  • Bei den Sicherheitseinstellungen muss der Eintrag “ActiveX-Steuerelemente ausführen, die für Scripting sicher sind“ aktiviert sein.

* Ab der IE Version 8 und höher der IE in den "IE7 Kompatibilitätsmodus" geschaltet wird, um eine einwandfreie Darstellung der Inhalte zu gewährleisten.


Über Uns

EXPAND Global bietet Lerntechnologie und -inhalte für den Arbeitsplatz der Zukunft. Wir sind Experten für innovative Lernwerkzeuge, Entwicklung von E-Learning Inhalten, Off-the-Shelf E-Learning für Microsoft Office, Microlearning, mobiles Lernen, Gamification and Performance Support.

 

Kontaktieren Sie uns