- Create and format charts.
- Work effectively with multiple sheets in workbooks.
- Use productivity tools.
- Quick analysis tools and work with the Excel list/database features.
This training provides all the tools necessary to create and use basic spreadsheets. Candidates will receive an overview of the interface and learn the various methods for entering and editing data. Additionally, candidates will learn the various ways to write simple formulas.
- Bussiness Users.
- Students who are interested in Excel.
- An overview of the screen, navigation and basic spreadsheet operations.
- Understanding workbooks, worksheets, rows, columns, cells.
- Various selection techniques.
- Entering, Editing and Deleting Text, Numbers, Dates.
- Moving and copying data.
- Inserting, Deleting and Hiding Rows & Columns.
- Inserting, Deleting, Moving and Copying Sheets.
- Fill series.
- Formatting Cells with Number formats, Font formats, Alignment, Borders and Patterns.
- Basic conditional formatting.
- Copying and Clearing Formats.
- Working with Styles.
- Spell Check, Find & Replace and AutoCorrect.
- Creating Bar Chart, Column Chart, Pie Chart, Line chart.
- Changing Chart elements, Style, Filter.
- Formatting Chart area, Plot area, Gridlines etc.
- Sorting.
- Filters.
- Subtotal.
- Concept of Formulae.
- Creating Formulae, Editing Formulae, Copying Formulae.
- Using Functions - Sum, Average, Max, Min, Count, Counta, Countif, Sumif, Now etc.
- Applying Absolute (Fixed) Referencing.
- Paste special.
- Page Orientation.
- Adding Headers and Footers.
- Printing a selection.
- Shrink to Fit.
- Repeating columns and rows.
