Discover Excel 2013 Course E-learning Intermediate, Companies Gain Time, Money and Energy. How Much Will You Gain? Start Today! 1 Million+ Students Worldwide.
Displaying several lines of data in one cell Absolute reference in a formula Copying values, copying with a link You need to know: Calculating with functions Control date, date formats Simple conditions Custom formats Applying a conditional format Managing conditional formats Naming a range of cells Validation rules Multiple cell ranges and calculations in functions You need to know: Charts Creating and positioning a chart Managing a chart Selecting items in a chart Adding and removing items Formatting chart items Modifying a chart's text items Legend and plot area Printing and page layout of a chart Modifying data labels Data series and chart axes Managing series Chart type options Managing chart templates Creating a sparkline Managing sparklines Creating a drawing object Selecting and deleting objects Copying and moving objects Resizing a drawing object Modifying a text box Modifying a drawing Formatting drawing objects Inserting a picture Managing pictures Rotating and aligning objects Stacking and grouping objects Subtotal rows Creating and managing a table Presenting and sorting data in a table Automatic calculations in a table Automatic filtering Custom filters Blank cells and duplicates You need to know: Advanced filtering with a criteria range Criteria ranges Copying rows filtered using a criteria range Statistics with a criteria range You need to know: Flash Fill You need to know: Pivot tables and pivot charts Creating a pivot table Modifying a pivot table Selecting Defining the layout and the presentation of a pivot table Filtering and searching for data in a pivot table Pivot charts
Theme by InStijl Media