Where
Delta Center for Economic Development5501 Krueger Drive
Jonesboro, AR 72401
Driving Directions
Contact
Alan DeckerDelta Center for Economic Development
870-972-3000
dced@astate.edu
Payment information
Payment options
Credit or Debit Card- You may pay with a Credit or Debit Card before the first class date by calling the ASU cashiers window at 870-972-3847 between the hours of 8 a.m. and 5 p.m., Monday-Friday.
Pay By Check- Make checks out to: ASU Treasurer's Office - Delta Center. Include the name of the class, and student's name and the Delta Center in the memo line. Payment must be received prior to attending class. If you need to make other arrangements, please call (870) 680-4383.
Mail checks to:
ASU Treasurer's Office P.O. Box 2640 State University, AR 72467
We can also invoice your company upon request. Please provide purchase order if required.
Cancellation policy
If you are unable to attend a course for which you have registered, please provide a two-day notice of cancellation. A 50% cancellation fee is charged unless a 2-day notice is provided. No shows are billed at 100%. Substitutions are encouraged.Microsoft Office Excel 2010
Advanced
Dates: Tuesday, March17th & Thursday, March 19th
Time: 5:30 p.m. - 9:00 p.m.
Cost: $109.00 Call for information regarding ASU Faculty and Staff discounts- 870-680-4383.
Instructor: Crystal Blake
This Advanced level class is intended to help everyday users of Excel present their data in more effective ways using PivotTables and PivotCharts. Users will also learn about advanced analysis tools like the Scenario Manager, goal seek, Solver, PowerPivot, advanced functions, macros, and Visual Basic.
Highlights of the course include a solid introduction to creating PivotTables with PowerPivot, coverage of advanced financial functions, hands-on practice with VLOOKUP, extensive coverage of PivotTables and PivotCharts, and an introduction to macros and Visual Basic.
Getting the Most from Your Data
To begin, participants will learn about Excel’s automatic grouping, outlining, and subtotaling features. Participants will also explore the Scenario Manager, data analysis tools, add-ins, one and two data input tables, goal seek, and Solver. The section will conclude with a discussion on hyperlinks.
Pivoting Data
This section focuses on one of Excel’s most powerful tools: PivotTables. Participants will explore all aspects of PivotTables, including creating a PivotTable; using the contextual tabs; pivoting, summarizing, and analyzing data; formatting the PivotTable; and using external data with a PivotTable.
This section also includes information on Slicers (a new feature that lets users analyze and interpret pivoted data with ease) and the classic PivotTable frame (used in Excel 2003 and earlier). The session will conclude with a comprehensive introduction to integrating data with PowerPivot and creating a PivotTable from that data.
Charting Pivoted Data
In this section, participants will learn how to create, use, edit, and format PivotCharts. Participants will also get experience with advanced PivotChart tasks, including creating a PivotChart from PowerPivot data and using PivotCharts to display scenario results.
Advanced Excel Tasks
The next section of this manual will explore a few Excel features that we find handy for everyday chores. First, advanced functions (PMT, FV, VLOOKUP, and HLOOKUP) and logical functions (IF, IFERROR, AND, OR, NOT, FALSE, and TRUE) will be covered. Then, AutoFill lists (which can save time when entering data) will be discussed. The section will conclude with information on linking, consolidating, and combining Excel data, with a final lesson on using the classic PivotTable and PivotChart wizard to pivot consolidated data.
Macros, Visual Basic, and Excel Programming
The final section of this manual will explore how to automate Excel tasks with macros. We will cover recording, running, and editing both basic and relative reference macros. Information on assigning a keyboard shortcut to a macro and managing macro security is also included. Then, Visual Basic tasks will be covered, including copying macros, using the Visual Basic Editor, declaring variables, iterating over a range, prompting for user input, and using conditional (If…Then…Else) statements.