2-Day Advanced Excel Online Training Course in Seattle

400 Broad Street,Seattle WA 98109

04 March, 2021

Description

2-Day Microsoft Excel Training Course starting from the basics to advanced skills This course is delivered ONLINEFormatThe course is instructor-led and will be delivered remotely. It offers a hands-on learning experience with practical exercises. You will start with the basics and build your skills to use intermediate and advanced features and functionalities. March 4 and 5, 2021Two full days - 8AM to 5PM Pacific TimeThere will be several breaks scheduled through the day with 1-hour lunch breakTime will be given to practice and do exercisesMaterial will be provided at the time of the session. PrerequisitesNo prior experience in MS Word is required. Access to computer/laptop with Microsoft Word software (2016 or newer) installed on your deviceCourse OutlineBasicsExploring A Workbook Entering Text, Dates And Numbers Resizing Columns And Rows Modifying Rows And Columns Formatting Worksheet Formulas and FunctionsDesigning Workbook For Calculations Calculating Dates Calculating With Formulas Calculating With Functions Applying Excel Functions Interpreting Error Values Auto Filling Formulas And Data Patterns Exploring Cell References Looking Up Data Lookup Tables And Logical Functions Calculating Running Totals With The Quick Analysis Tool Working With IF Logical Functions Using Lookup Functions Exploring Logical Functions Applying Summary IF Functions Creating PivotTables Formatting A PivotTable Setting PivotTable Options Introducing PivotCharts Using Slicers Drilling Down A PivotTable Performing What If Analyses With Formulas And Functions FormattingFormatting Cell Text Working With Fill Colors And Backgrounds Using Functions And Formulas With Sales Data Formatting Numbers Formatting Worksheet Cells Calculating Averages Applying Cell Styles Copying And Pasting Formulas Finding And Replacing Text And Formats Working With Themes Highlighting Data With Conditional Formats Formatting Input, Calculated And Output Values ChartsChart Elements Getting Started With Excel Charts Creating A Pie Chart Working With Chart Elements Performing What If Analyses With Charts Creating A Column Chart Creating A Line Chart Creating A Combination Chart Scatter Charts, Data Bars And Sparklines Creating A Scatter Chart Editing The Chart Data Source Exploring Other Chart Types Creating Data Bars Creating Sparklines