Excel Introduction

For individuals who have never used spreadsheets or the Excel application before or only used Excel for limited tasks. At the end of the day, you will be able to create professional-looking spreadsheets.

What you will learn:

• An Introduction to Excel – the ribbon bar, enter move and clear data, saving in Excel, creating new workbooks, cut copy and paste, naming, deleting, and working with sheets.
• Formulas – introduction to basic formula, order of operations, add subtract multiply and divide, auto sum and auto average, percentages, absolute cell referencing.
• Data Manipulation – moving data, sorting, inserting rows and columns, widening rows and columns, deleting information.
• Printing – print preview, page layout, headers and footers and print area.
• Formatting – formatting numbers, formatting text, borders, and shading, align data.
• Utilities – introduction to charts, freeze panes, introduction to conditional formatting, autofill options.