Location

Community Services & Continuing Education - Alexandria

Objectives

• This course is designed to give an insight into some of the more advanced features in Excel and will be of particular interest to those who want to build or work with financial models, carry out detailed data analysis and automate tasks by recording macros.

Outcomes

Upon successful completion of this course participants will be able to:• Enhance productivity by working with conditional formatting, named cell ranges, macros and templates.• Use functions such as those associated with logical, statistical, financial and mathematical operations.• Create charts and apply advanced chart formatting features.• Work with tables and lists to analyses, filter and sort data. Create and use scenarios.• Validate and audit spreadsheet data.• Collaborate on and review spreadsheets. Apply spreadsheet security features

Course Contents

Enhancing Productivity• Apply conditional formatting based on cell content.• Split a window Move, remove split bars.• Hide, show rows, columns, worksheets.• Naming Cells: Name cell ranges, delete names for cell ranges. Use named cell ranges in a function.• Paste Special: Use paste special options: add, subtract, multiply, divide. Use paste special options: values /numbers, transpose.• Templates: Create a spreadsheet based on an existing template. Modify a template.• Hyperlink: Insert, edit, and remove a hyperlink.• External data: Import delimited data from a text file.• Macro: Record a simple macro like: change page setup, apply a custom number format, apply auto formats to a cell range, and insert fields in worksheet header, footer. Run a macro. Assign a macro to a custom button on a toolbar.• Using advanced functions Use date and time functions: today, now, day, month, year. Use mathematical functions: round-down, roundup, sum-if. Use statistic