MS Excel specialistLC-EXCEL

Currently there are no scheduled dates

Remote training: online live with a trainer and a group. Available on demand, at time and place convenient to you, for groups of at least 6 participants.

4.8/5 (807)
Stars
exempt from VAT

Price: 590 EUR

refreshments included

computer station included

Categories: Excel, VBA

This course prepares to bring skills in using MS Excel from basic to advanced levels. The course provides students with both an overview of the advanced features and functions of the program and knowledge of their practical applications. Practical exercises accompany every topic covered during the course. VBA basics will also be added, which will be explained and practically shown during this training

Duration

Agenda

Microsoft Excel:

  1. Revise the basics of Excel
  2. * Data entry and editing, selecting, searching for cells and groups of cells
  3. * Copy, paste, fill cells and ranges
  4. * Graphic formatting
  5. * Cell styles (standard and custom)
  6. * Data types and formatting by data type
  7. * Comments: insertion, appearance, editing
  8. * Inserting and working with simple objects (graphics, frames)
  9. * Customize the ribbon
  10. Formulas
  11. * Naming cells and ranges
  12. * Relative, absolute and mixed addressing
  13. * Addressing from other sheets, using named ranges
  14. * Logical functions Or, And
  15. * Date and time functions
  16. * Text functions
  17. * Conditional function IF
  18. * Conditional autosums
  19. * Functions VLOOKUP, VLOOKUP
  20. * Transpose function
  21. * Quick analysis
  22. Naming cells
  23. * Name field
  24. * Name from selection
  25. * Dynamic names
  26. * Fast navigation
  27. * Readability of formulas
  28. Conditional formatting
  29. * Automatic formatting depending on the value
  30. * Rule management
  31. * Modifying standard rules
  32. Table object
  33. * Create and format tables
  34. * Dynamic named range
  35. * Convert to range
  36. Data validation
  37. * Checking the correctness of the entered data
  38. * Drop-down lists
  39. * Input message, types of warnings
  40. Data sorting and filters
  41. * Sort by value
  42. * Sort by multiple columns at once (custom sort)
  43. * AutoFilter, filtering by data type
  44. * Sorting and filtering with colors and icons
  45. Custom Lists
  46. * Filling the day of the week with months
  47. * Create your own custom lists
  48. * Sort by custom list
  49. Data Tools
  50. * Data Consolidation
  51. * Remove duplicates
  52. * Outline and grouping
  53. Partial Totals
  54. * Outline tool
  55. Check and correct formulas
  56. * A circular reference and setting the number of iterations of the calculation
  57. Working with charts
  58. * Basic chart types and specifying data sources
  59. * Format charts from gallery and manually
  60. * Create templates
  61. * New charts in Excel 2016
  62. PivotTables and PivotCharts
  63. * Create pivot tables
  64. * Calculations
  65. * Sorting and filtering
  66. * Create PivotCharts
  67. * Formatting
  68. Workbook management
  69. * Create templates
  70. * Cross-workbook links (fixing file links)
  71. * File properties, document inspection compatibility
  72. File sharing
  73. * Change management
  74. * Protection of ranges of workbooks and sheets
  75. Data Import
  76. * Simple import from database
  77. * Import data from a text file
  78. What if analysis
  79. * Search result
  80. * Scenario manager
  81. Advanced formulas
  82. * Addressing from other worksheets, using named ranges
  83. * Advanced date and time functions
  84. * Advanced text features
  85. * Functions VLOOKUP, VLOOKUP
  86. * Functions Index, Matching Position, Intermediate Adr, Ranges Intersection
  87. * Array formulas
  88. Naming Cells, Advanced Named Cell Work
  89. * Naming cells and ranges
  90. * Name visibility ranges
  91. * Referencing names from other worksheets
  92. * Dynamic names (no table object)
  93. * Name manager
  94. * Intermediate addr
  95. Conditional formatting
  96. * Dynamic formatting depending on the settings in the sheets
  97. * Formula dependent
  98. Table object
  99. * Structured references (headers, data, summary row)
  100. * Slicers
  101. Advanced Filters
  102. * Building multiple complex filtering conditions
  103. Data Tools
  104. * Data Consolidation
  105. * Text as columns
  106. Check and correct formulas
  107. * Dependency tracking
  108. * Show formulas
  109. * Detector
  110. * Accuracy of calculations
  111. * Manual recalculation of the sheet and workbooks
  112. Working with charts
  113. * Sparklines
  114. * New charts in Excel 2016
  115. PivotTables and PivotCharts
  116. * Creation of pivot tables (dimensions and grouping, basic summaries, multiple summaries horizontal / vertical)
  117. * Calculations (show values ​​as)
  118. * Calculation fields and items
  119. * Sorting and filtering (by labels, by values)
  120. * Create PivotCharts
  121. * Slicers (including timeline, joining multiple tables / charts to the same slicers)
  122. * Formatting (styles, selecting table elements)
  123. * Conditional formatting (formatting visibility)
  124. * TakeTableData function
  125. * Sort by custom lists
  126. * Generating pivot tables based on a template
  127. * Data model (relationships).
  128. File sharing
  129. * Change management (logging changes, enabling changes, committing changes)
  130. * Protection of ranges of workbooks and sheets
  131. * Marking as final
  132. Data Import
  133. * Simple import from database
  134. * Import data from a text file
  135. * Data import from XM file

Download as PDF

Audience and prerequisites

This course is intended for professionals and office workers who want to learn advanced-level Excel skills.

Before attending this course, students must have:

  • Basic computer knowledge, such as keyboard and mouse skills.
  • Basic file-management skills. The student should know how to navigate to folders and files on a computer running Windows Vista / Windows 7.
  • Basic knowledge of the Excel interface, workbook manipulation and formula creation.

Certificates

Course participants receive completion certificates signed by ALX.

There are currently no entries

Enter your e-mail address and we will notify you about future dates

Question?

Ask us anything about this training

* I hereby give my consent to the processing of my personal data by ALX Training Ltd. for the purpose of this request.