FORGOT YOUR DETAILS?

LEVEL 1


  • The basics of Excel
  • The spreadsheet on paper
  • Adapting Excel
  • The workbook environment
  • Import data and navigate the spreadsheet
  • Import and correction of data
  • Save file
  • Using functions
  • Open a second file
  • Navigation and motion techniques
  • Changing a computational book
  • Working with cell areas
  • Work with functions
  • Edit cell contents
  • Move and copy data
  • Import rows and rows
  • Move data
  • Absolute and relevant reports
  • Use the auto-fill feature
  • Format a worksheet
  • Worksheet Formatting
  • Formatting numbers and aligning text
  • Copy and paste formats
  • Special and personalized formatting
  • Print a worksheet
  • Spelling check
  • Use the print preview command
  • Print a large sheet – Print area
  • Additional print options
  • By recommending the book interface
  • Using a multi-leaf book
  • Create a map
  • Outlining – Spreadsheet Solutions

LEVEL 2


  • Sorting data
  • Classify a level in the data
  • Multiple data classifications
  • Sorting options
  • Factors to be taken into account when designing
  • Data filters
  • Apply a filter to a list
  • Personalized criteria
  • Criteria for multiple conditions
  • Managing a series of data that has been filtered
  • Use Using Pivot
  • Create Pivot Tables
  • Change Pivot Tables
  • Grouping and summarizing data in a Pivot Table
  • Create Interactive Pivot Tables for the Web
  • Database Functions
  • Create a map
  • Create a map sheet
  • Create an embedded map
  • Comparison of embedded maps with map sheets
  • Edit maps
  • Types of maps
  • Edit embedded maps
  • Add and delete map objects
  • Move and resize the map objects
  • Format maps
  • Format text map
  • Formatting a memo
  • Format a map
  • Print a map
  • Use of graphic objects
  • Adding graphics and objects
  • Graphics formatting
  • Use graphics and objects to enhance data sheets and maps

LEVEL 3


  • Work with multiple sheets
  • Working with workbooks.
  • Link sheets and workbooks
  • Worksheet as opposed to link and work environments
  • Sharing and merging workbooks
  • Data integration and analysis
  • Consolidate data from more than one sheet
  • Use Goal Seek and Solver.
  • Use Scenario Manager to capture different entry values in a worksheet
  • Use sheet and imagery protection
  • Display
  • Use comments
  • Protection of books and leaflets
  • Use personalized imagery
  • Construction of advanced functions
  • Use a region name Use the IF function
  • Using the VLOOKUP function
  • Using IS functions and type control
  • First experience with macros
  • Running Macros
  • Record a Macro
  • Visualization and VBA Code Management
  • Personalize the work area
  • Working with built-in toolbars
  • Use personal toolbars
  • Create and use styles.
  • Use template
  • Create webpages with Excel
  • Use Excel as a web page creation tool
  • Other Web Options
  • Work with Interactive Excel Web Documents
  • Save Excel files as web pages
  • Spreadsheet Web Components

Conducting the Seminar

The seminars are conducted online through the Multilingua asynchronous training platform, or at your headquarters during the hours and days that serve the operation of the client.

Customized Training Workshops are created, which concern the Diagnosis of the existing situation and the Configuration-Creation of a laboratory and educational program especially for the requirements of the individual and the company, which is achieved through Field Visits, interviews and Placement Tests.

The seminars are private/individual or group. Seminar Duration: ...... Hours "

TOP