Description
Excel is essential for establishing statistics, calculating and analyzing results, monitoring ratios and margins, representing them graphically, etc. This Excel training for beginners will provide you with the basics for efficiently constructing calculation tables and using their graphic representations. Evaluate your level of knowledge in Excel Beginner.
Who is this training for ?
For whom ?
Any user
Prerequisites
Training objectives
Training program
- Take your bearings
- Use the ribbon, the quick access bar, the status bar.
- Enter and copy the contents of cells.
- Build a calculation formula .
- Identify basic concepts
- Design, present and print a simple table
- Format cells: present numbers, text, titles.
- Put data in table form.
- Sort and filter data.
- Define conditional formatting.
- Print the entire table or part of it, title, paginate.
- Harnessing computing power: formulas and functions
- Calculate percentages, ratios, apply a rate.
- Perform statistics: AVERAGE, MIN, MAX.
- Apply a condition: IF.
- Consolidate several sheets with the SUM function.
- Automate the copying of formulas: absolute or relative references
- Illustrate numbers with graphs
- Build a chart. Change type: histogram, line, pie.
- Adjust source data.
- Organize sheets and binders
- Insert, move, copy one or more sheets.
- Modify several sheets simultaneously.
- Create dynamic links.
- Build tables of synthesis.
- Links to Word and PowerPoint
- Insert an Excel table or graph in Word or PowerPoint.
- Evaluation of the transfer of acquired knowledge to validate implementation in a work situation
