Overview
This article has links to beginning and intermediate Excel videos from Percipio to assist you in learning Excel.
NOTE: Most videos are 4-5 minutes long.
Details
Beginning Excel videos
- Getting started in Excel
- Entering data
- Managing data
- Adding & arranging data
- Editing worksheets
- Applying cell styles
- Counting cells
- Aligning cells
- Formatting cells
- Freezing panes and splitting worksheets
- Customizing date and time formats
- Performing data calculations using formulas
- Creating tables
- Working with tables
- Using formulas with tables
- Inserting hyperlinks
- Save your work
- Viewing and Printing your worksheets
- Creating custom templates
- Applying table styles
- 10 common tools
Intermediate Excel videos
- Getting started with charts
- Customizing charts
- Formatting a Chart
- Adding and removing chart elements
- Creating Basic Area Charts
- Creating a pie chart
- Creating Basic Line Charts
- Customizing and Formatting Line Charts
- Creating and Working with Various Excel Bar Charts
- Editing chart data in Excel 365
- Using conditional average functions
- Creating PivotTables and PivotCharts
- Sorting and filtering data in a PivotTable
- Data validation
- Protecting a worksheet
- Consolidating data
- Inserting hyperlinks
- Filtering data
- Sorting data
- Using Custom and Conditional Formatting
- Grouping items
- Inserting images
- Searching within a worksheet
- Configuring calculation options
- Analyzing and forecasting data
Comments
0 comments
Article is closed for comments.