- Acquire the essential basics of Excel software (Microsoft Office suite).
- Discover the potential of the software: create tables, graphs, lists-
- Make simple tables integrating calculations, format and print them.
- Learn how to communicate data and figures effectively through the software.
Module 1: Introduction to Excel
– Familiarize yourself with Excel.
– Finding your way around the screen: toolbar, status bar, menus, ruler.
– Analyze the basic concepts of a spreadsheet.
– Organize your tables in the binders.
– Insert, delete, move a sheet inside a binder.
– Set up formulas and automate them.
– Manage cells: entering, writing and copying formulas, modification.
Module 2: Making Tables with Simple Calculations
– The automatic sum.
– Construction of calculation formulas with operators.
– Copying of formulas.
– Copy and move cells.
– Incremented series.
– Tools to help with data entry.
Module 3: Creating and Editing Simple Graphics
– Generate graphs from tables.
– Choice of x-axis, y-axis.
– Modify the presentation.
– Add text.
– Cell selection.
– Insert a chart as an object near the table.
– 3D graphics and 3D view.
– Add or remove series.
– Print the graph, table, graph and table.
Module 4: Formatting and Layout
– Row and column management.
– Cell selection.
– Particular selections by the Edit – Go to command.
– Formatting cells.
– Text boxes.
– Layout.
–Impression.
Module 5: Automating Excel Calculations
– Addressing modes: absolute and relative.
– Calculate percentages and produce ratios.
– Perform statistics: SUM (), AVERAGE ().
– Apply conditions: SI ().
– Use the date functions: NOW (), TODAY ().
– Consolidate several sheets of a workbook with the SUM function ().
– The function assistant.
