Whether you’re an Excel newbie or advanced user, new Learning and Development classes help you get the skills you need to bring your data analysis to the next level.

Excel Beginner/Intermediate

Online: November 18, 9 a.m. – 12 p.m. – Register
Franklin: November 18, 1 p.m. – 4 p.m. – Register

Expand your productivity and Excel skills with this basic- to intermediate-level class. Topics include:

• Data entry techniques
• Mastering the use of functions to summarize your data
• Exceptional tips on navigation and selection
• Managing lists (tables, sorting, filtering, transposing data, etc.)
• Enhancing data with formatting techniques
• Conditional formatting to highlight special data
• Visualizing data with Excel charts
• Exploring different chart types to enhance data visualizations

Excel Advanced

Online: December 3, 9 a.m. – 12 p.m. – Register

In this advanced course, you’ll learn to:

• Apply advanced functions, including logical, financial, statistical and database functions
• Use data tables to explore the effects of different input values on a formula
• Find specific values or determine the cell address of a specific value with lookup functions
• Implement data validation to control which values are allowed in cells
• Set up, use and format pivot tables to analyze complex data sets
• Present results to stakeholders graphically with pivot charts, SmartArt graphics and conditional data bars or icons
• Use text files, XML files, Microsoft queries and web queries to import and export spreadsheet data

Excel for Power Users

Online: December 11, 9 a.m. – 12 p.m. – Register

Microsoft Excel’s analytic capabilities make it an invaluable problem-solving tool in any context. However, to use Excel’s most sophisticated features effectively requires more than knowledge of the application’s formulas and menu options. Excel for Power Users training provides the learner with practical experience using the application’s most powerful features and data analysis techniques to develop better solutions faster, and implement those solutions with a greater understanding of the complex factors that affect business outcomes.

Topics include:

• Analyzing spreadsheet data effectively with advanced formulas
• Taking pivot table analysis to the next level
• Creating customizable dashboards to display data in a single view
• Enhancing spreadsheet functionality with powerful, multi-purpose VBA macros
• Giving users control over the way they interact with spreadsheet data

Questions? Contact ucopld@ucop.edu.

About

View all post by