Technology/Computers Microsoft Office ced.unlv.edu/microsoft-office
Courses on additional Microsoft products including Office 365, Access, OneNote, Outlook, PowerPoint, Project, SharePoint, and Visio may be arranged through our custom training team, 702-895-5099 or continuing.education@unlv.edu.
Excel Advanced Workshop: Automating Tasks
The Excel Advanced Workshop series is a fast-paced but deep dive into customizing Excel for maximum productivity and data analysis in your office, business, or sales team. You will learn time saving tips and shortcuts, best practices to avoid trouble down the road, and how to create better workbooks. Save time on repetitive, manual editing tasks by learning how Excel can help you quickly reformat your data into a consistent layout every time and more! Learn how to program macros, and practice using conditional formatting, and data validation. Must have access to Excel. Prerequisite: Excel I or similar working knowledge and experience. Sharon Fry, MCT, MOS Master, MCP, MTA W | May 5 | 1-4:15pm | $99 Online-Zoom | 211CU1122 | 0.3 CEU
The Excel Advanced Workshop series is a fast-paced but deep dive into customizing Excel for maximum productivity and data analysis in your office, business, or sales team. You will learn time saving tips and shortcuts, best practices to avoid trouble down the road, and how to create better workbooks. When simple formulas are not enough anymore, you will need to learn to multiply your productivity and the power of your workbooks by using complex formulas in Excel. You will practice applying the use of multiple functions in formulas by nesting and combining functions. Learn about Excel’s formula auditing tools and become the office hero by learning how to handle errors in Excel formulas. Must have access to Excel. Prerequisite: Excel I or similar working knowledge and experience. Sharon Fry, MCT, MOS Master, MCP, MTA T | May 4 | 1-4:15pm | $99 Online-Zoom | 211CU1120 | 0.3 CEU
Excel Advanced Workshop: Data Analysis & Reporting
The Excel Advanced Workshop series is a fast-paced but deep dive into customizing Excel for maximum productivity and data analysis in your office, business, or sales team. You will learn time saving tips and shortcuts, best practices to avoid trouble down the road, and how to create better workbooks. Need to summarize data for a report or project? Learn the best practices in setting up and cleaning up your data to prepare it for clear and understandable reports and graphs. Transform large amounts of data so you and your stakeholders see just what you need. Create visual representations of your data through charts, graphs, tables, and dashboards. You will practice using Excel’s PivotTables, Pivot Charts, and Quick Analysis features and you will explore the Get and Transform Data tools, Queries and Connections feature, What-If Analysis Tools, plus Outline and Subtotal features. Must have access to Excel. Prerequisite: Excel I or similar working knowledge and experience. Sharon Fry, MCT, MOS Master, MCP, MTA M | May 3 | 1-4:15pm | $99 Online-Zoom | 211CU1121 | 0.3 CEU
Register online at ced.unlv.edu/cat2021
17
Technology/Computers
Learn the essential skills of Microsoft Office for business or personal use. Emphasis for Excel is on skills useful for organizing, formatting, analyzing, and presenting business data. Word training focuses on advanced features useful for formatting long documents, managing citations and figures, and the proofing process.
Excel Advanced Workshop: Complex Formulas
