Attend a live instructor led webinar and participate in the comfort of your own home or office on your own pc or mobile device. Instructor led webinars engage interaction allowing you to ask questions. Contact us at 440.967.9368 or at firstname.lastname@example.org for additional information.
Enter basic formulas and function formulas like SUM, MIN, MAX, and AVERAGE. Use AutoFill to copy formulas and quickly enter a sequence of numbers or dates. Insert and delete columns and rows and quickly resize all columns and rows in one step. Apply number formats, format and align data, merge and center cells, apply borders and shading, and clear formatting. Create, duplicate, and group worksheets for consistent formatting. Learn printing features such as Page Break Preview, Page Layout View, and Print Titles to repeat column and row headings on every page. Customize the Quick Access Toolbar and add your favorite tools and commands for quick access. (2 hour session)
Use Range Names and Absolute Referencing in formulas, apply enhanced Sorting and Filtering techniques, and format data as a Table. Learn statistical functions such as COUNT and COUNTIF, math and trig functions such as SUMIF and SUMIFS, and text functions such as UPPER, LOWER, PROPER, CONCATENATE and TRIM. Learn to use the Text to Columns, Remove Duplicates, and Data Validation tools. Duplicate, copy, and move worksheets and enter three-dimensional formulas. Additional topics include Conditional Formatting, Formula Auditing and linking Excel charts and worksheets in Word and PowerPoint. Excel Introduction is the prerequisite. (2 hour session)
Create column, bar, line, pie, and area charts and select a default chart type to insert a chart with one keystroke. Learn which chart types best illustrate changes over time, show comparisons among categories, display contributions to a total, etc. Move and resize charts, use chart buttons, and modify chart elements such as a titles, legends, and scales. Format the data as a Table so you'll never have to redefine the source data. Learn to customize the axis scale; create a chart with two scales, and add visuals such as explanatory text and data labels. Create chart templates to save chart modifications and insert chart sparklines. Excel Introduction is the prerequisite. (2 hour session)
Format data as an Excel Table and learn all of the advantages that Tables have to offer such as total rows, calculated columns, and structured references. Learn to easily remove Duplicates, Convert tables to ranges, Sort and Filter, and add Subtotals. Create PivotTables and PivotCharts, rearrange fields and refresh PivotTables, change the summary function; analyze data from multiple sources, define Relationships across multiple tables, add Tables and Fields, and create a Power View sheet. Excel Introduction is the recommended prerequisite. (2 hour session)
Learn to use lookup functions such as LOOKUP using an array, LOOKUP using a lookup vector and result vector, VLOOKUP, and HLOOKUP. You will also learn to calculate with the Subtotals command and create, modify, and format PivotTable Reports and PivotTable Charts. Record and run Macros to automate repetitive or complicated tasks. Protect worksheets and workbooks to hide data and prevent unwanted modifications. Excel Introduction and Excel Intermediate are the recommended prerequisites. (2 hour session)
Learn new time saving features associated with Range Names and formatting a range as a Table, use new techniques to Sort and Filter data, Group worksheets to apply changes to an entire workbook, and quick tips to remove unwanted blank rows and columns at the end of a worksheet. Learn to create a chart in one step, save a customized chart as a template to use again and again, and change the default chart type. Many other tips and shortcuts are included as well. Excel Introduction is the recommended prerequisite. (1 hour session)