Excel Proficiency – Pack of 10 Courses

$599.00

1. Excel Beyond Numbers – Tame Lists and Tabular Data

MIKE THOMAS
Duration: 90 Minutes
Areas Covered:

  • Sorting a column or row of items into order
  • Sorting a list of date-based items into order
  • Filtering a list to display only certain items
  • Saving a filter for re-use
  • The benefits of Tables
  • Summarizing a list with Pivot Tables and Subtotal Reports
  • Cleaning up imported/downloaded data
  • Importing and linking to non-Excel data
2. Excel – Improve Data Visualization with Maps, Charts and Infographics

MIKE THOMAS
Duration: 90 Minutes
Areas Covered:

  • Charting 101 – create a basic chart
  • From drab to fab – enhance and customize a basic chart
  • Combination charts – line and bar in a single chart
  • Dynamic charts – automate adding new data to a chart
  • Creating in-cell Sparkline charts
  • Creating infographics with Excel
  • Using Conditional Formatting to present data visually
  • 3D Map – presenting geographic data in a visual way
3. Microsoft Excel – Tips and Tricks Everyone Should Know

DAWN BJORK
Duration: 60 Minutes
Areas Covered:

  • Navigating shortcuts
  • Customizing the default workbook
  • Customizing the Quick Access Toolbar and Ribbon
  • Fast formatting and editing by grouping worksheets
  • Easy ways to copy and paste
  • Tricks with AutoFill
  • Data entry tips
  • Find & Replace on steroids
  • Quick formatting with the Format Painter
  • Automation shortcuts
  • Customizing Excel options
4. Excel Update on Logic Functions – IF, AND, OR, and More

DAVID H. RINGSTROM
Duration: 60 Minutes
Areas Covered:

  • Comparing and contrasting IFNA, IFERROR, and ISERROR functions and learning which versions of Excel support these worksheet functions.
  • Learning about the MINIFS function available in certain versions of Excel 2016.
  • Seeing the pros and cons of using the F9 key within Excel’s formula bar to evaluate a portion of a formula.
  • Discovering the capabilities of the SUMPRODUCT function.
  • Learning about the MAXIFS function available in certain versions of Excel 2016.
  • Learning about the IFNA function available in Excel 2013 and later.
  • Comparing the MIN, SMALL, MAX, and LARGE functions.
  • Moving through formulas in slow motion with the Evaluate Formula feature.
  • Testing for a single condition among two or more that returns TRUE by way of Excel’s XOR function.
  • Testing for two or more conditions at once with Excel’s AND function.
  • Discovering the range of IS functions that can be used within IF statements to test for various conditions within a worksheet.
  • Avoiding the complexity of nested IF statements with Excel’s CHOOSE function
5. Excel – Automated Dashboards for Business Intelligence

MIKE THOMAS
Duration: 90 Minutes
Areas Covered:

  • Best practice for setting up data sources
  • Using Pivot Tables to summarize data
  • Visual communication using charts
  • Using formulas to create KPI summaries
  • Creating interactive filters with Slicers
  • Automating the dashboard with a simple macro
  • Using protection to prevent accidental changes
6. Excel Lookup Functions – Part 1

DAVID H. RINGSTROM
Duration: 60 Minutes
Areas Covered:

  • Simplifying multiple-field look-ups with concatenation (combining fields together into a single cell).
  • Learning why the INDEX and MATCH combination often is superior to VLOOKUP or HLOOKUP.
  • Learning about the IFNA function available in Excel 2ExcludeInclude3 and later.
  • Seeing what types of user actions can trigger #REF! errors.
  • Using VLOOKUP to look up data from another workbook.
  • Employing the SUMIF function to add up values related to multiple instances of criteria that you specify.
  • Avoiding the complexity of nested IF statements with Excel’s CHOOSE function.
  • Understanding the importance of absolute references within many lookup functions.
  • Troubleshooting other errors VLOOKUP can present, such as #REF!, #NAME!, and #VALUE!.
  • Seeing how the HLOOKUP function enables you to perform horizontal matches.
  • Exploring why VLOOKUP sometimes returns #N/A instead of a desired result.
  • Learning about the MAXIFS function available in certain versions of Excel 2ExcludeInclude6
7. Excel Lookup Functions – Part 2

DAVID H. RINGSTROM
Duration: 60 Minutes
Areas Covered:

  • Using the SUMIFS function to sum values based on multiple criteria.
  • Using VLOOKUP to look up data from another workbook.
  • Exploring why VLOOKUP sometimes returns #N/A instead of a desired result.
  • Learn about the MINIFS function available in certain versions of Excel 2ExcludeInclude6.
  • Comparing the MIN, SMALL, MAX, and LARGE functions.
  • Performing dual lookups, which allow you to look across columns and down rows to cross-reference the data you need.
  • Seeing how the HLOOKUP function enables you to perform horizontal matches.
  • Avoiding the complexity of nested IF statements with Excel’s CHOOSE function.
  • Discovering how to use wildcards and multiple criteria within lookup formulas.
  • Implementing Data Validation to ensure that users make choices that VLOOKUP will recognize as valid.
  • Transforming numbers stored as text into values by way of the Text to Columns wizard.
  • Seeing what types of user actions can trigger #REF! errors.
8. Excel VBA 101 – Take Automation Beyond the Macro Recorder

MIKE THOMAS
Duration: 90 Minutes
Areas Covered:

  • Writing a simple macro from scratch using VBA
  • Using the IF statement to apply logic to your VBA procedures
  • Using Loops to save time and create efficient code
  • Variables – what are they and how are they used?
9. Practical Excel – Executing Spreadsheet Internal Controls

DAVID H. RINGSTROM
Duration: 60 Minutes
Areas Covered:

  • Creating self-expanding drop-down lists with Excel’s Data Validation feature.
  • Ensuring proper VLOOKUP integrity by using Data Validation to create an in-cell drop-down list.
  • Future-proofing VLOOKUP by using Excel’s Table feature versus referencing static ranges.
  • Improving the integrity of spreadsheets with Excel’s VLOOKUP function.
  • Limiting users to entering whole numbers in a worksheet cell by way of Data Validation.
  • Overcoming VLOOKUP’s quirks by using SUMIF to look up numeric values.
  • Preserving key formulas using hide and protect features.
  • Protecting hidden sheets from within a workbook.
  • Protecting sensitive information by hiding formulas within an Excel workbook.
  • Removing the Table feature from Excel spreadsheets once it’s no longer needed, or simply erasing the alternate row shading.
  • Toggling the Locked status of a worksheet cell on or off by way of a custom shortcut.
  • Tweaking the Data Validation settings for a given range of cells.
10. Excel’s Power Query – Import, Manipulate, and Master Big Data

MIKE THOMAS
Duration: 90 Minutes
Areas Covered:

  • Importing data into Excel from external sources
  • Linking to external sources
  • Creating Pivot Tables from external data sources
  • Using the Query Editor to create calculated columns in pivot tables
  • Using the Query Editor to clean and transform data

Custom

$599.00

membership
  Go PRIME   🛈 $ 240 SELECT
  Personal Plan 🛈 $ 3000 SELECT
  Business Plan 🛈 $ 9000 SELECT


  • Login Information with Password to join the session, 24 hours prior to the webinar
  • Presentation Handout in .pdf format
  • Presentation from the Speaker
  • Feedback form
  • Certificate of Attendance
  • Recording access Information with Password to view the webinar, will be sent 24 hours after the completion of the Live webinar.
  • Presentation Handout in .pdf format
  • Certificate of Attendance