Excel 2013, 2016, Office 365 - Fundamentals

After the training the participant shall be able to:

• create tables and manage them; to format and manipulate data; to create and print charts from Excel data.

• Excel environment
• The Excel environment: Quick Access toolbar, ribbon and tabs
• Customize Quick Access toolbar and the ribbon
• Live Preview and Paste Preview
• Manage spreadsheets
• Add, rename, delete a worksheet
• Move and copy a sheet
• Define a tab color
• Change the height or width of the formula bar
• Manage Tables
• Enter and validate data
• Manage rows and columns: add, resize, delete, hide / show
• Find / Replace data
• Copy / paste data
• Document Management
• Create / open / save a document
• Headers and footers
• The "Page Layout" view
• Calculate
• Enter and copy formulas
• Smart tags
• Functions
• Insert Function using the wizard
• Insert function manually, semi-automatic formula input
• Format table
• Format cells
• Using styles
• Predefined conditional formats
• Present data with a graph(Chart)
• Create a chart
• Change / format a Chart
• Use the chart styles
• Create and use a chart template
• Sparklines
• Analyze the data tables
• Create a data table (Insert Table)
• Sort and filter data tables
• List filters with search box
• Sort and filter by font or fill color
• The Flash Fill

At the end of the training, the participant will receive a certificate of attendance delivered by the House of Training.