This short course surveys fundamental Microsoft Excel concepts and functionality applicable to SIPA courses and in professional settings. Topics include interacting with spreadsheets, understanding references and functions, writing formulas, building basic models, controlling formatting and presentation, and creating basic charts. The course is targeted at students with limited or no prior Excel experience.
Prerequisites: Instructor-Managed Waitlist & Course Application.
This short course explores techniques that enable sophisticated problem solving and data analysis in Microsoft Excel. Topics include implementing advanced logic using complex formulas and intermediate calculations; managing complexity with Excel's auditing features; importing, parsing and cleaning raw data; pulling data together using lookup functions; and summarizing and analyzing data with conditional aggregate functions and PivotTables. This course does not focus on specific policy or financial applications, but instead explores general concepts and techniques that can be flexibly applied to different solutions in Excel.
This one-day seminar, conducted by Training The Street, explores best practices and efficient techniques for building finance-related spreadsheets.
The lectures will use a real company as a case study and direct participants to blend accounting, corporate finance, and Excel skills to create a dynamic, three-statement financial model. The completed product has five years of projections, three years of historical data, and supporting schedules, including working capital, debt, equity, depreciation, and amortization. Other advanced topics include understanding and controlling circularity errors, troubleshooting, sensitivity analysis, and discounted cash flow valuations.
The course is best suited for students with exposure to basic accounting and corporate finance concepts. It stresses efficiency in using Excel and awareness of common pitfalls when developing financial models.
1.5 credits per section. Prerequisite: T7113. Open to Clinical students only. These courses build on the general framework of Advanced Clinical Practice (T7113) to address problems in a particular field of practice. Students select two seven-week mini-courses in which they consolidate their developing knowledge and skills through the in-depth study of service delivery to specific client populations, the application of specific intervention methods, or selected clinical practice issues. Topics are updated annually to reflect new developments in clinical practice. Students must register for one mini-course in the first half of the semester and one in the second half of the semester.
1.5 credits per section. Prerequisite: T7113. Open to Clinical students only. These courses build on the general framework of Advanced Clinical Practice (T7113) to address problems in a particular field of practice. Students select two seven-week mini-courses in which they consolidate their developing knowledge and skills through the in-depth study of service delivery to specific client populations, the application of specific intervention methods, or selected clinical practice issues. Topics are updated annually to reflect new developments in clinical practice. Students must register for one mini-course in the first half of the semester and one in the second half of the semester.
1.5 credits per section. Prerequisite: T7113. Open to Clinical students only. These courses build on the general framework of Advanced Clinical Practice (T7113) to address problems in a particular field of practice. Students select two seven-week mini-courses in which they consolidate their developing knowledge and skills through the in-depth study of service delivery to specific client populations, the application of specific intervention methods, or selected clinical practice issues. Topics are updated annually to reflect new developments in clinical practice. Students must register for one mini-course in the first half of the semester and one in the second half of the semester.
1.5 credits per section. Prerequisite: T7113. Open to Clinical students only. These courses build on the general framework of Advanced Clinical Practice (T7113) to address problems in a particular field of practice. Students select two seven-week mini-courses in which they consolidate their developing knowledge and skills through the in-depth study of service delivery to specific client populations, the application of specific intervention methods, or selected clinical practice issues. Topics are updated annually to reflect new developments in clinical practice. Students must register for one mini-course in the first half of the semester and one in the second half of the semester.
1.5 credits per section. Prerequisite: T7113. Open to Clinical students only. These courses build on the general framework of Advanced Clinical Practice (T7113) to address problems in a particular field of practice. Students select two seven-week mini-courses in which they consolidate their developing knowledge and skills through the in-depth study of service delivery to specific client populations, the application of specific intervention methods, or selected clinical practice issues. Topics are updated annually to reflect new developments in clinical practice. Students must register for one mini-course in the first half of the semester and one in the second half of the semester.
1.5 credits per section. Prerequisite: T7113. Open to Clinical students only. These courses build on the general framework of Advanced Clinical Practice (T7113) to address problems in a particular field of practice. Students select two seven-week mini-courses in which they consolidate their developing knowledge and skills through the in-depth study of service delivery to specific client populations, the application of specific intervention methods, or selected clinical practice issues. Topics are updated annually to reflect new developments in clinical practice. Students must register for one mini-course in the first half of the semester and one in the second half of the semester.
1.5 credits per section. Prerequisite: T7113. Open to Clinical students only. These courses build on the general framework of Advanced Clinical Practice (T7113) to address problems in a particular field of practice. Students select two seven-week mini-courses in which they consolidate their developing knowledge and skills through the in-depth study of service delivery to specific client populations, the application of specific intervention methods, or selected clinical practice issues. Topics are updated annually to reflect new developments in clinical practice. Students must register for one mini-course in the first half of the semester and one in the second half of the semester.
1.5 credits per section. Prerequisite: T7113. Open to Clinical students only. These courses build on the general framework of Advanced Clinical Practice (T7113) to address problems in a particular field of practice. Students select two seven-week mini-courses in which they consolidate their developing knowledge and skills through the in-depth study of service delivery to specific client populations, the application of specific intervention methods, or selected clinical practice issues. Topics are updated annually to reflect new developments in clinical practice. Students must register for one mini-course in the first half of the semester and one in the second half of the semester.
1.5 credits per section. Prerequisite: T7113. Open to Clinical students only. These courses build on the general framework of Advanced Clinical Practice (T7113) to address problems in a particular field of practice. Students select two seven-week mini-courses in which they consolidate their developing knowledge and skills through the in-depth study of service delivery to specific client populations, the application of specific intervention methods, or selected clinical practice issues. Topics are updated annually to reflect new developments in clinical practice. Students must register for one mini-course in the first half of the semester and one in the second half of the semester.
1.5 credits per section. Prerequisite: T7113. Open to Clinical students only. These courses build on the general framework of Advanced Clinical Practice (T7113) to address problems in a particular field of practice. Students select two seven-week mini-courses in which they consolidate their developing knowledge and skills through the in-depth study of service delivery to specific client populations, the application of specific intervention methods, or selected clinical practice issues. Topics are updated annually to reflect new developments in clinical practice. Students must register for one mini-course in the first half of the semester and one in the second half of the semester.
1.5 credits per section. Prerequisite: T7113. Open to Clinical students only. These courses build on the general framework of Advanced Clinical Practice (T7113) to address problems in a particular field of practice. Students select two seven-week mini-courses in which they consolidate their developing knowledge and skills through the in-depth study of service delivery to specific client populations, the application of specific intervention methods, or selected clinical practice issues. Topics are updated annually to reflect new developments in clinical practice. Students must register for one mini-course in the first half of the semester and one in the second half of the semester.
1.5 credits per section. Prerequisite: T7113. Open to Clinical students only. These courses build on the general framework of Advanced Clinical Practice (T7113) to address problems in a particular field of practice. Students select two seven-week mini-courses in which they consolidate their developing knowledge and skills through the in-depth study of service delivery to specific client populations, the application of specific intervention methods, or selected clinical practice issues. Topics are updated annually to reflect new developments in clinical practice. Students must register for one mini-course in the first half of the semester and one in the second half of the semester.
1.5 credits per section. Prerequisite: T7113. Open to Clinical students only. These courses build on the general framework of Advanced Clinical Practice (T7113) to address problems in a particular field of practice. Students select two seven-week mini-courses in which they consolidate their developing knowledge and skills through the in-depth study of service delivery to specific client populations, the application of specific intervention methods, or selected clinical practice issues. Topics are updated annually to reflect new developments in clinical practice. Students must register for one mini-course in the first half of the semester and one in the second half of the semester.
1.5 credits per section. Prerequisite: T7113. Open to Clinical students only. These courses build on the general framework of Advanced Clinical Practice (T7113) to address problems in a particular field of practice. Students select two seven-week mini-courses in which they consolidate their developing knowledge and skills through the in-depth study of service delivery to specific client populations, the application of specific intervention methods, or selected clinical practice issues. Topics are updated annually to reflect new developments in clinical practice. Students must register for one mini-course in the first half of the semester and one in the second half of the semester.
1.5 credits per section. Prerequisite: T7113. Open to Clinical students only. These courses build on the general framework of Advanced Clinical Practice (T7113) to address problems in a particular field of practice. Students select two seven-week mini-courses in which they consolidate their developing knowledge and skills through the in-depth study of service delivery to specific client populations, the application of specific intervention methods, or selected clinical practice issues. Topics are updated annually to reflect new developments in clinical practice. Students must register for one mini-course in the first half of the semester and one in the second half of the semester.
1.5 credits per section. Prerequisite: T7113. Open to Clinical students only. These courses build on the general framework of Advanced Clinical Practice (T7113) to address problems in a particular field of practice. Students select two seven-week mini-courses in which they consolidate their developing knowledge and skills through the in-depth study of service delivery to specific client populations, the application of specific intervention methods, or selected clinical practice issues. Topics are updated annually to reflect new developments in clinical practice. Students must register for one mini-course in the first half of the semester and one in the second half of the semester.
1.5 credits per section. Prerequisite: T7113. Open to Clinical students only. These courses build on the general framework of Advanced Clinical Practice (T7113) to address problems in a particular field of practice. Students select two seven-week mini-courses in which they consolidate their developing knowledge and skills through the in-depth study of service delivery to specific client populations, the application of specific intervention methods, or selected clinical practice issues. Topics are updated annually to reflect new developments in clinical practice. Students must register for one mini-course in the first half of the semester and one in the second half of the semester.
1.5 credits per section. Prerequisite: T7113. Open to Clinical students only. These courses build on the general framework of Advanced Clinical Practice (T7113) to address problems in a particular field of practice. Students select two seven-week mini-courses in which they consolidate their developing knowledge and skills through the in-depth study of service delivery to specific client populations, the application of specific intervention methods, or selected clinical practice issues. Topics are updated annually to reflect new developments in clinical practice. Students must register for one mini-course in the first half of the semester and one in the second half of the semester.
1.5 credits per section. Prerequisite: T7113. Open to Clinical students only. These courses build on the general framework of Advanced Clinical Practice (T7113) to address problems in a particular field of practice. Students select two seven-week mini-courses in which they consolidate their developing knowledge and skills through the in-depth study of service delivery to specific client populations, the application of specific intervention methods, or selected clinical practice issues. Topics are updated annually to reflect new developments in clinical practice. Students must register for one mini-course in the first half of the semester and one in the second half of the semester.
1.5 credits per section. Prerequisite: T7113. Open to Clinical students only. These courses build on the general framework of Advanced Clinical Practice (T7113) to address problems in a particular field of practice. Students select two seven-week mini-courses in which they consolidate their developing knowledge and skills through the in-depth study of service delivery to specific client populations, the application of specific intervention methods, or selected clinical practice issues. Topics are updated annually to reflect new developments in clinical practice. Students must register for one mini-course in the first half of the semester and one in the second half of the semester.
1.5 credits per section. Prerequisite: T7113. Open to Clinical students only. These courses build on the general framework of Advanced Clinical Practice (T7113) to address problems in a particular field of practice. Students select two seven-week mini-courses in which they consolidate their developing knowledge and skills through the in-depth study of service delivery to specific client populations, the application of specific intervention methods, or selected clinical practice issues. Topics are updated annually to reflect new developments in clinical practice. Students must register for one mini-course in the first half of the semester and one in the second half of the semester.
1.5 credits per section. Prerequisite: T7113. Open to Clinical students only. These courses build on the general framework of Advanced Clinical Practice (T7113) to address problems in a particular field of practice. Students select two seven-week mini-courses in which they consolidate their developing knowledge and skills through the in-depth study of service delivery to specific client populations, the application of specific intervention methods, or selected clinical practice issues. Topics are updated annually to reflect new developments in clinical practice. Students must register for one mini-course in the first half of the semester and one in the second half of the semester.
1.5 credits per section. Prerequisite: T7113. Open to Clinical students only. These courses build on the general framework of Advanced Clinical Practice (T7113) to address problems in a particular field of practice. Students select two seven-week mini-courses in which they consolidate their developing knowledge and skills through the in-depth study of service delivery to specific client populations, the application of specific intervention methods, or selected clinical practice issues. Topics are updated annually to reflect new developments in clinical practice. Students must register for one mini-course in the first half of the semester and one in the second half of the semester.
1.5 credits per section. Prerequisite: T7113. Open to Clinical students only. These courses build on the general framework of Advanced Clinical Practice (T7113) to address problems in a particular field of practice. Students select two seven-week mini-courses in which they consolidate their developing knowledge and skills through the in-depth study of service delivery to specific client populations, the application of specific intervention methods, or selected clinical practice issues. Topics are updated annually to reflect new developments in clinical practice. Students must register for one mini-course in the first half of the semester and one in the second half of the semester.
1.5 credits per section. Prerequisite: T7113. Open to Clinical students only. These courses build on the general framework of Advanced Clinical Practice (T7113) to address problems in a particular field of practice. Students select two seven-week mini-courses in which they consolidate their developing knowledge and skills through the in-depth study of service delivery to specific client populations, the application of specific intervention methods, or selected clinical practice issues. Topics are updated annually to reflect new developments in clinical practice. Students must register for one mini-course in the first half of the semester and one in the second half of the semester.
1.5 credits per section. Prerequisite: T7113. Open to Clinical students only. These courses build on the general framework of Advanced Clinical Practice (T7113) to address problems in a particular field of practice. Students select two seven-week mini-courses in which they consolidate their developing knowledge and skills through the in-depth study of service delivery to specific client populations, the application of specific intervention methods, or selected clinical practice issues. Topics are updated annually to reflect new developments in clinical practice. Students must register for one mini-course in the first half of the semester and one in the second half of the semester.
1.5 credits per section. Prerequisite: T7113. Open to Clinical students only. These courses build on the general framework of Advanced Clinical Practice (T7113) to address problems in a particular field of practice. Students select two seven-week mini-courses in which they consolidate their developing knowledge and skills through the in-depth study of service delivery to specific client populations, the application of specific intervention methods, or selected clinical practice issues. Topics are updated annually to reflect new developments in clinical practice. Students must register for one mini-course in the first half of the semester and one in the second half of the semester.
1.5 credits per section. Prerequisite: T7113. Open to Clinical students only. These courses build on the general framework of Advanced Clinical Practice (T7113) to address problems in a particular field of practice. Students select two seven-week mini-courses in which they consolidate their developing knowledge and skills through the in-depth study of service delivery to specific client populations, the application of specific intervention methods, or selected clinical practice issues. Topics are updated annually to reflect new developments in clinical practice. Students must register for one mini-course in the first half of the semester and one in the second half of the semester.
1.5 credits per section. Prerequisite: T7113. Open to Clinical students only. These courses build on the general framework of Advanced Clinical Practice (T7113) to address problems in a particular field of practice. Students select two seven-week mini-courses in which they consolidate their developing knowledge and skills through the in-depth study of service delivery to specific client populations, the application of specific intervention methods, or selected clinical practice issues. Topics are updated annually to reflect new developments in clinical practice. Students must register for one mini-course in the first half of the semester and one in the second half of the semester.