Curs Microsoft Excel Avansat

Curs Webdesign Timisoara

Cursul se adreseaza utilizatorilor Microsoft Excel, de nivel incepator si mediu. In cadrul acestui curs se vor aborda functionalitati complexe Microsoft Excel.

curs html timisoara

Structura cursului

  • Opportunities on Ribbon
  • The most important functions and their usage
  • Statistic and mathematical functions (SUM, simple and conditional functions)
  • Date and time management
  • Data conversions
  • Making logical expressions (relational symbol, comparison)
  • Making complex consistences
  • Financial calculations (ex: monthly replayments counting, securities)
  • Text functions (simplify text merges, and cutting)
  • Searching and transformation
  • Data filtering, special filters
  • Conditional aggregation
  • Matrix functions
  • Linking lists, categorization
  • Target filtration from cells
  • Informational functions
  • Error handling
  • Excel basics, formatting, conditional formatting, graphs, printing
  • Working with functions, logical functions (if, sumif, countif, averageif, ...), date functions (date, yearfrac, networkdays, ... ), time functions (hour, minute, ... ), other functions (index, match, vlookup, ... )
  • Data analysis, data filtering, what-if analysis, text-to-columns tool, data tools
  • Pivot tables and pivot charts, data analysis with slicers, custom, connected pivot charts, PowerPivot
  • Sheet protection, document sharing, cloud sharing
  • Entering and Editing Formulas
  • Working with Names
  • Naming Cells and Ranges
  • Using custom sequences and series
  • Worksheet Functions
  • Date and time functions
  • Statistical function
  • Lookup functions
  • Text functions
  • Logical functions
  • Using worksheet databases
  • Sorting data
  • Filtering data
  • Using the Subtotal
  • Conditional Formatting
  • Worksheet operations
  • Summary Sheet
  • Chart formatting
  • Preparing Data for Pivot Table Reporting
  • Cleaning Up Data for Pivot Table Analysis
  • The Anatomy of a Pivot Table
  • Values, row and column Area
  • Report Filter Area
  • Creating and customizing a Basic Pivot Table
  • Applying a Table Style
  • Changing the Number Format
  • Changing a Field Name
  • Making Layout Changes
  • Customizing the Pivot Table Appearance with Styles and Themes
  • Summary Calculations, Subtotals
  • Using Running Total Options
  • View Pivot Data, Grouping Pivot Fields
  • Sorting and Filtering
  • Performing Calculations Within Pivot Tables
  • Calculated Fields and Calculated Item
  • Using Pivot Charts, Pivot Chart Rules, Changing the Chart Format
  • Building a Pivot Table Using External Data Sources
  • Take out datas and informations from one or more tables (Power pivot)
  • One And Two-Variable Data Table
  • Excel Database Tools
  • Advanced Filtering Options
  • Data Validation
  • Importing Data from the Internet
  • Macros ( Basic)
  • Recording
  • Excel Protection And Common Use
  • File Protection
  • Workbook Protection
  • Worksheet Protection
  • VBA basics

Sumar al cursului

In prima parte a cursului ne vom familiariza cu interfata programului Microsoft Excel si vom intelege functiile de baza ale acestuia. Vom pune accent pe instrumentele cele mai importante ale programelor de calcul tabelar: formule, sortari, filtre si grafice.

Cursul este unul preponderent practic. Vom crea si edita documente intalnite in viata de zi cu zi, cum ar fi modele de facturi, proiectii bugetare, planificari, stocuri, etc.

Obiective

Dupa finalizarea acestui modul, cursantul va putea:

  • sa foloseasca interfata Microsoft Office pentru a creea si edita documente Excel
  • sa configureze spatiul de lucru in functie de nevoiele lor
  • sa structureze si formateze datele potrivit cerintelor de lucru
  • sa realizeze calcule pe baza unor formule si functii
  • sa realizeze grafice pe baza datelor introduse
  • sa utilizeze template-uri Microsoft Excel
  • sa defineasca zone protejate in document
  • sa inregistreze si sa editeze macro-uri si scripturi VBA
  • sa realizeze operatiile de baza cu datele dintr-o foaie Excel
  • sa genereze rapoarte specifice si detaliate
  • sa realizeze calcule pe baza unor formule folosind functii Excel
  • sa denumeasca zone de celule si sa le foloseasca in formule si functii
  • sa lucreze cu functii, formule, referinte celulare
  • sa-si comaseze datele prin intermediul Pivot Table
  • sa redea trendul datelor, proportiile, cu ajutorul graficelor
  • sa formateze personalizat zone de celule si tipuri de date
  • sa regaseasca usor informatii cu ajutorul functiilor specifice

Informatii despre curs

Cursul este de tip Hands-On si se desfasoara in sala, toate cursurile sunt 100% practice.

Durata cursului este de aproximativ 4 saptamani

Cursanti


Cursurile se adreseaza tuturor celor care doresc sa se specializeze in folosirea Microsoft Excel nivel avansat.

Start


Cursurile incep de la un nivel zero si nu sunt necesare cunostinte initiale in domeniu !

Program


Orar: Luni 17:30-19:30; Joi 17:30-19:30

Echipamente


Cursantii vor folosi echipamentele proprii: Win, MAC, Linux

Formular pentru inscriere la curs

TEHNOLOGII TIP CURS DURATA PRETUL
Microsoft Excel In sala 16 ORE 600 RON

* Dupa promovare se elibereaza diploma de absolvire