Magic with Excel Advanced Topics - PowerPoint PPT Presentation

1 / 16
About This Presentation
Title:

Magic with Excel Advanced Topics

Description:

Crystal Reports. ODBC. Access. SQL. Data Manipulation. Deleting/Inserting. Formatting. Macros ... Tax Report - Calculations. BkRecBal - Lookup Tables. Absents ... – PowerPoint PPT presentation

Number of Views:97
Avg rating:3.0/5.0
Slides: 17
Provided by: william694
Category:

less

Transcript and Presenter's Notes

Title: Magic with Excel Advanced Topics


1
  • Magic with Excel - Advanced Topics
  • William S. Day - Grayson County, KY
  • Preconference Session PC3/PC6
  • KASBO Spring 2009

2
(No Transcript)
3
Magic WITH EXCEL
  • Data Input
  • Data Manipulation
  • Information Viewing

4
Data Input
  • Hand Entry
  • Auto Fill
  • Custom Lists
  • Copy
  • Templates
  • Importing Text Files
  • Crystal Reports
  • ODBC
  • Access
  • SQL

5
Data Manipulation
  • Deleting/Inserting
  • Formatting
  • Macros
  • Command Buttons
  • Updates
  • Linking Cells/Spreadsheets
  • Functions
  • String Manipulation
  • Formulas
  • Date Manipulation
  • Logical - If
  • Lookup Tables

6
Information Viewing
  • Sorting
  • Filtering
  • Subtotals
  • Pivot Tables
  • Graphing
  • From Pivot Tables
  • From Data
  • Examples
  • JE Form - Repeat Data
  • Tax Report - Calculations
  • BkRecBal - Lookup Tables
  • Absents - Subtotals
  • Job Pay - Pivot Tables
  • AccumRet - Pivot Table
  • Glmaster - Pivot Table
  • SubReport - Macro/Buttons

7
Data Manipulation
  • Deleting/Inserting
  • Formatting
  • Linking Cells/Spreadsheets
  • Functions
  • String Manipulation
  • Formulas
  • Date Manipulation
  • Logical - If
  • Lookup Tables
  • Macros
  • Command Buttons
  • Updates

8
Functions String Manipulation Formulas Date
Manipulation Logical - If Lookup Tables
9
Linking Cells and Spreadsheets
10
Information Viewing
  • Sorting
  • Filtering
  • Subtotals
  • Pivot Tables
  • Graphing
  • From Pivot Tables
  • From Data
  • Examples
  • JE Form - Repeat Data
  • Tax Report - Calculations
  • BkRecBal - Lookup Tables
  • Absents - Subtotals
  • Job Pay - Pivot Tables
  • AccumRet - Pivot Table
  • Glmaster - Pivot Table
  • SubReport - Macro/Buttons

11
Prior Year Job Pay Info
Pivot Tables
12
Pivot Tables
13
Macros Command Buttons Updates
14
Graphs
15
(No Transcript)
16
THATS ALL FOLKS
  • bill_at_SouthernOakes.com

Southern Oakes Support --- William S.
DaySouthern Oakes Farms248 Southern Oakes
LaneLeitchfield, KY 42754 270.259.6149
Write a Comment
User Comments (0)
About PowerShow.com