OBJECTIVES
The object of Excel Basic course is to make the users of the application operational and efficient and to present the new features of the 2013 version. You will learn how to create and manage a simple spreadsheet, perform calculations and statistics, effectively present the prospectuses, accompanied by logical-decorative elements and graphic representations of the data.
RECIPIENTS
All those who must learn the basics for the realization of a spreadsheet.
All those who, already having basic software training, need to make the best use of the controls and know the tools of the 2013 version.
DURATION
1 hours
CONTENTS
MODULE 1 - The basics of Excel
• Know the working environment
• Open a workbook
• Know the folders
• Activate a cell
• Select the intervals
• Enter and edit information
• Save and close a folder
MODULE 2 - The cells
• Set the format of a cell
• Choose cell styles
• Conditional formatting
• Apply conditional formatting
MODULE 3 - Operations on cells
• Use the Copy, Paste, Cut functions
• Use the Format Painter command
• Set the character
• Align the text
• Insert and delete items in a workbook
• Use the cell format options.
MODULE 4 - Tables
• Insert a table
• Name a table
• Resize a table
Convert a table into a range of cells
• Export data from a table
• Set the style of a table
• Change the style of a table: example of a total row
MODULE 5 - The formulas
• Use formulas
• Define ranges in functions
• Insert a quick function
• Use the Fill command
MODULE 6 - Graphs
• Choose and insert a chart
• Modify a chart
• Change and customize the type of a chart
• View the analysis of a graph
MODULE 7 - The page setup
• Manage page settings
• The Page Layout tab
• Repeat the row and column titles
• Insert page breaks
• Remove page breaks
• Set margins
• Manage orientation
• Set the print format
• The Print Area button
• The Fit to page group
• The Sheet Options group
• The Themes group
MODULE 8 - Images
• Insert an image
• Adjust the image
• Reset the image
• Set the style of an image
• Insert an image from the web
• Arrange the illustrative elements
• Change the size
MODULE 9 - The SmartArt
• Use smartArt
• Modify the SmartArt
• Set the layout
• Choose styles
• Reset the SmartArt
• Choose shapes, styles and WordArt
• Define the size and position with respect to other graphic elements
TECHNICAL REQUIREMENTS:
Acrobat Reader
PDF documents are exported from version 5 and are compatible with all subsequent versions of Acrobat Reader released up to the update date of this file.
Browser
- Internet Explorer 10
- Internet Explorer 11
- Mozilla Firefox
- Google Chrome
JavaScript enabled
Pop-up blocker disabled
Minimum video resolution
The courses are optimized for a 1024 × 768 display on PCs and tablets of at least 7 inches.
Speakers or headphones (in case of multimedia products)
DATA TRACKING METHOD: SCORM 1.2
DEVELOPMENT TECHNOLOGY:
HTML5
CERTIFICATION / CERTIFICATE:
Certificate of use
PRODUCED BY:
PIAZZA COPERNICO
Content edited by:
PIAZZA COPERNICO
COURSE CODE:
0065-15