Explore VLOOKUP, HLOOKUP, and alternatives like INDEX and MATCH Registration ends by 5pm the day prior to the Webinar. Once you register on Eventbrite, you will receive an email from the instructor through GoToWebinar with the link to join this class. VLOOKUP is a must-have Excel function that's used to manipulate data. In this 90-minute...
If you are unemployed, underemployed, considering a career change, or seeking training, BCS is here to support you in all aspects of your career development journey. We can provide you with career coaching, resume and interviewing assistance, even funding for job training to propel you into careers in high-growth and high-demand industries. Please join us...
Learn how to use IF and other logical functions to add conditions to Excel tasks Add power and complexity to your Excel spreadsheets! In this 90-minute webinar we'll talk about about one of the most powerful functions in Excel - the IF function. We'll also talk about other logical functions like AND/OR as well as...
Excel Advanced Concepts - Pivot Tables: Summarize and manipulate data with pivot tables and pivot charts In this 90-minute webinar we'll talk about what a pivot table does and how to create pivot tables and pivot charts. We'll also look at some of the additional PivotTable options like Slicers, Timelines, calculated fields and custom grouping....
Text strings and dates can cause big problems in a spreadsheet if you're not aware of how to identify and manipulate them! In this 90-minute webinar we'll talk about basic text functions like CONCATENATE and date functions like TODAY. We'll also explore tools like Flash Fill, Text to Columns, and delimited text Registration ends by...
Excel Advanced Concepts - Additional tools: Data validation, Subtotal, and Conditional Formatting This 90-minute webinar focuses on some of the additional tools available in Excel that are very useful. We'll talk about data validation, the Subtotal outline feature (an alternative to pivot tables), Linking, Conditional Formatting and Protection Registration ends by 5pm the day prior...
If you are unemployed, underemployed, considering a career change, or seeking training, BCS is here to support you in all aspects of your career development journey. We can provide you with career coaching, resume and interviewing assistance, even funding for job training to propel you into careers in high-growth and high-demand industries. Please join us...
Excel Advanced Concepts - Dashboards: Use PivotTables, Sparklines, Charts, VLOOKUP to create Excel Dashboards Dashboards are at-a-glance summaries that use graphics to illustrate progress towards a goal. Excel has a number of features like PivotTables, PivotCharts, Sparklines, and Functions that can be combined to create surprisingly robust dashboards. We highly recommend you have some familiarity...
If you are unemployed, underemployed, considering a career change, or seeking training, BCS is here to support you in all aspects of your career development journey. We can provide you with career coaching, resume and interviewing assistance, even funding for job training to propel you into careers in high-growth and high-demand industries. Please join us...
If you are unemployed, underemployed, considering a career change, or seeking training, BCS is here to support you in all aspects of your career development journey. We can provide you with career coaching, resume and interviewing assistance, even funding for job training to propel you into careers in high-growth and high-demand industries. Please join us...
Excel Basics: How spreadsheets work, spreadsheet construction, basic formulas and functions, sort, filter, formatting, and printing This in-person class is designed to introduce key concepts crucial to building a working knowledge of Microsoft Excel. In this class we'll talk about the Excel environment, how spreadsheets work, spreadsheet construction, basic formulas and functions, sort, filter, formatting,...
Document creation, font, paragraph and page formatting including bulleted lists, alignment, indentation, and line spacing This in-person class is designed to introduce key concepts crucial to building a working knowledge of Microsoft Word. In this class we'll talk about document creation, font, paragraph and page formatting including bulleted lists, alignment, indentation, line spacing and more....
