258876-1-1Alignment Strategy

258876-2-1 SayPro Lesson Introduction

258876-2-2 SayPro Lesson Import and export text files

258876-2-3 SayPro Lesson CONVERTING DATA

258876-2-4 SayPro Lesson Converting text to dates

258876-2-4 SayPro Lesson Using DATEVALUE formula

258876-2-5 SayPro Lesson EXPORTING DATA TO A TEXT FILE

258876-2-6 SayPro Lesson : Export Excel data to text files with Kutools for Excel

258876-2-7 SayPro Lesson Consolidating and linking data within spreadsheets

258876-2-8 SayPro Lesson COPY SINGLE WORKSHEET ACROSS MULTIPLE WORKSHEETS

258876-2-9 SayPro Lesson Drag data between open workbook windows in Excel

258876-2-10 SayPro Lesson CONSOLIDATING AND LINKING DATA FROM MULTIPLE SPREADSHEETS

258876-2-11 SayPro Lesson USE A FORMULA TO CONSOLIDATE DATA

258876-2-12 SayPro Lesson Applying filters and using forms in spreadsheets

258876-2-13 SayPro Lesson ADVANCED FILTERING

258876-2-14 SayPro Lesson THE USE OF FORMS ON A SPREADSHEET

258876-2-15 SayPro Lesson EDITING AND DELETING RECORDS IN A FORM

258876-2-16 SayPro Lesson SORTING A FILTER LIST

258876-2-17 SayPro Lesson PRINTING A FILTER LIST

258876-2-18 SayPro Lesson Creating and using macros

258876-2-19 SayPro Lesson CREATING A MACRO

258876-2-20 SayPro Lesson RUNNING A MACRO

258876-2-21 SayPro Lesson ASSIGNING A MACRO TO AN OBJECT, GRAPHIC, OR CONTROL

258876-2-22 SayPro Lesson Combining and comparing large sets of data in spreadsheet

258876-2-23 SayPro Lesson CREATING A PIVOTTABLE

258876-2-24 SayPro Lesson REPORT FILTERS

258876-2-25 SayPro Lesson GROUP ITEMS IN A PIVOTTABLE REPORT

258876-2-26 SayPro Lesson UNGROUP GROUPED ITEMS

258876-2-27 SayPro Lesson CHANGING THE LAYOUT AND FORMAT OF A PIVOTTABLE REPORT

258876-2-28 SayPro Lesson CHANGING THE LAYOUT FORM OF A PIVOTTABLE REPORT

258876-2-29 SayPro Lesson Change a PivotTable report to compact, outline, or tabular form

258876-2-30 SayPro Lesson CHANGING OR REMOVING FORMATTING

258876-2-31 SayPro Lesson PivotCharts are like regular charts, except they display data from a PivotTable. As with a regular chart, you’ll be able to select a chart type, layout and style to best represent the data. In this example, we’ll use a PivotChart so we can visualize the trends in each sales region. To Create a PivotChart: 1. Select any cell in your PivotTable. The Options tab will appear in the Ribbon. 2. From the Options tab, click the PivotChart command.

258876-2-32 SayPro Lesson PRINTING A PIVOTTABLE REPORT

258876-2-33 SayPro Lesson DELETING A PIVOTTABLE REPORT