Share Description
In this course, you will learn:
- How to enter and organize data, perform calculations with simple functions, work with multiple worksheets, format the appearance of your data, and build charts and PivotTables.
Syllabus:
- Introduction
- Using the exercise files
1. Getting Started with Excel 2013
- What is Excel used for?
- Using the menu system
- The Quick Access Toolbar
- The structure of a worksheet or workbook
- Using the Formula bar
- Using the Status bar
- Navigation and mouse pointers
- Shortcut menus and the Mini toolbar
- Using the built-in help
- Creating new files
2. Entering Data
- Exploring data entry and editing techniques
- Entering data with AutoFill
- Working with dates and times
- Using Undo and Redo
- Adding comments
- Using Save or Save As
3. Creating Formulas and Functions
- Creating simple formulas: Totals and averages
- Copying a formula for adjacent cells
- Calculating year-to-date profits
- Creating a percentage-increase formula
- Working with relative, absolute, and mixed references
- Using SUM and AVERAGE
- Using other common functions
4. Formatting
- Exploring font styles and effects
- Adjusting row heights and column widths
- Working with alignment and Wrap Text
- Designing borders
- Exploring numeric and special formatting
- Formatting numbers and dates
- Conditional formatting
- Creating and using tables
- Inserting shapes, arrows, and other visual features
5. Adjusting Worksheet Layout and Data
- Inserting and deleting rows and columns
- Hiding and unhiding rows and columns
- Moving, copying, and inserting data
- Finding and replacing data
6. Printing
- Exploring the Page Layout tab and view
- Previewing page breaks
- Working with Page Setup and printing controls
7. Introduction to Charting
- Creating charts
- Exploring chart types
- Formatting charts
- Working with axes, labels, gridlines, and other chart elements
- Creating in-cell charts with sparklines
8. Adjusting Worksheet Views
- Freezing and unfreezing panes
- Splitting screens horizontally and vertically
- Showing necessary information with the Outlining feature
9. Multiple Worksheets and Workbooks
- Displaying multiple worksheets and workbooks
- Renaming, inserting, and deleting sheets
- Moving, copying, and grouping sheets
- Using formulas to link worksheets and workbooks
- Locating and maintaining links
10. IF, VLOOKUP, and Power Functions
- Using IF functions and relational operators
- Getting approximate table data with the VLOOKUP function
- Getting exact table data with the VLOOKUP function
- Using the COUNTIF family of functions
11. Security and Sharing
- Unlocking cells and protecting worksheets
- Protecting workbooks
- Assigning passwords to workbooks
- Sharing workbooks
- Tracking changes
12. Database Features
- Sorting data
- Inserting subtotals in a sorted list
- Using filters
- Splitting data into multiple columns
- Removing duplicate records
13. PivotTables
- Creating PivotTables
- Manipulating PivotTable data
- Grouping by date and time
- Grouping by other factors
- Using slicers to clarify and manipulate fields
- Using PivotCharts
14. Data Analysis Tools
- Using Goal Seek
- Using Solver
- Using Scenario Manager
- Using Data Tables
15. Introduction to Macros
- Definition and examples
- Creating a simple macro
- Running a macro
