Excel Proficiency – Pack of 10 Courses
Number of Courses: 10 Webinars | Total Learning Hours: 12.5 Hours
Price: $ 1997 (70% off) $ 599 Add to Cart
Be an Excel Expert! Designed for novice to intermediate Excel users to expand their knowledge and talents working with Excel. Likely to fill in learning gaps for even advanced users too. Even if you use Microsoft Excel every day, you are probably missing many of the tools and techniques designed to help you move forward with your projects. How effectively are you using Excel to create, format, and analyze your important data? How much time are you wasting trying to hunt down the how-to steps to get your work done?
MIKE THOMAS
Duration: 90 Minutes
MIKE THOMAS
Duration: 90 Minutes
DAWN BJORK
Duration: 60 Minutes
DAVID H. RINGSTROM
Duration: 60 Minutes
MIKE THOMAS
Duration: 90 Minutes
DAVID H. RINGSTROM
Duration: 60 Minutes
DAVID H. RINGSTROM
Duration: 60 Minutes
MIKE THOMAS
Duration: 90 Minutes
DAVID H. RINGSTROM
Duration: 60 Minutes
MIKE THOMAS
Duration: 90 Minutes
In these tips-packed, online Excel training sessions, you will learn the smart and easy steps you need to build your skills and achieve the results you want in Microsoft Excel.
Webinars included in this pack
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