Microsoft Excel Expert Courses			Options Sort: Date Title   |   Display: Full Compact
	Excel Expert 1 This course teaches you how to use formulas and functions in Microsoft Excel, covering core skills like working with the function library, absolute references, and named ranges. You will learn to reference values between sheets, create summary sheets, and utilize essential text functions including CONCATENATE, LEFT, RIGHT, MID, LEN, FIND, SEARCH, SUBSTITUTE, REPLACE, and TRIM. The lessons give you practical examples and shortcuts for building efficient spreadsheets, streamlining your data, and organizing information across multiple worksheets in Excel.
	Excel Expert 2 Take your Excel skills to the next level by mastering how to work with dates and times in Excel, including understanding how these values are stored, customizing date formats with custom codes, and using essential date functions like NOW, TODAY, YEARFRAC, DATEDIF, DATEVALUE, NETWORKDAYS, and WORKDAY. Learn to fix imported date issues, build timesheets, calculate work hours, perform date arithmetic, and find important values such as first and last days of a period or week numbers. Packed with practical tips, this course is perfect for anyone wanting to work smarter with date calculations in Excel.
	Excel Expert 3 Strengthen your spreadsheet skills by mastering Excel's logic functions including IF statements, AND, OR, and NOT, and learn how to apply IS functions such as ISBLANK, ISERROR, and ISTEXT. The course covers practical, real-world examples like assigning letter grades, calculating sales tax, handling time sheets with overtime and overnight shifts, and processing credit card batches. You will also discover how to use TRUE and FALSE values, nest multiple IF statements for complex scenarios, and simplify calculations with IFERROR, making your spreadsheets smarter and more dynamic.
	Excel Expert 4 Learn how to efficiently retrieve and analyze data in Microsoft Excel with essential lookup functions, including VLOOKUP, HLOOKUP, INDEX, and MATCH. This course covers converting numbers to day names, grading with range lookups, building dynamic timesheets, handling exact and partial matches, and comparing lists for missing values. Explore working with dynamic cell references using ADDRESS and INDIRECT, and see practical examples like finding the closest value in a list or spotting discrepancies between data sets, all designed to enhance your data management skills in Excel.
	Excel Expert 5 Take your spreadsheet skills to the next level by learning to use Excel's advanced math and statistics functions, including SUM, SUMIF, and SUMIFS for flexible data aggregation. You'll also work with counting functions like COUNT, COUNTA, COUNTBLANK, and a range of rounding options, alongside key statistical tools like median, mode, and ABS, plus practical functions for random numbers and trigonometry such as sine, cosine, tangent, and radians-to-degrees conversion. Perfect for experienced users, this course gives you the tools to analyze and summarize your data more powerfully and efficiently.
	Excel Expert 6 Learn how to build powerful financial calculators in Microsoft Excel using essential functions like PMT, FV, RATE, and PV. This course guides you through calculating monthly mortgage and credit card payments, tracking future investment growth, finding interest rates, estimating time to financial goals, and creating custom loan amortization schedules. You will practice financial modeling for real-life scenarios like home affordability, initial deposit calculation, and analyzing total interest paid, while mastering Excel tools for working with loans, investments, and credit payments efficiently.
	Excel Expert 7 Learn how to efficiently create, edit, and customize PivotTables and Pivot Charts in Microsoft Excel, from building your first pivot table with sales data to advanced formatting, filtering, and grouping by dates or number ranges. Discover tools such as Slicers for easy filtering, options for layout and design, and best practices for rearranging fields and using report filters. The course also covers customizing value fields, using grouping features, exploring PivotTable options, and visualizing your data through dynamic pivot charts, helping you quickly summarize and analyze large datasets.
	Excel Expert 8 Learn advanced skills in Microsoft Excel with expert techniques for worksheet protection, controlling and securing your data by locking cells and setting passwords. Explore robust workbook protection methods including structure locking and managing access permissions. Enhance your workflow with advanced copy and paste features like Paste Special, the Office Clipboard, and linked pictures. Streamline data management with Excel's fill and series options to generate patterns, sequences, and dates, and create easy-to-use data entry forms that improve accuracy when adding or editing records. Perfect for experienced users ready for the next level.
	Excel Expert 9 Advance your Excel expertise by mastering advanced sorting, including custom sorts, multi-level organization, sorting by cell or font color, and handling unique data like Roman numerals and birth months. Explore custom lists for tailored data management and see how to customize the ribbon and Quick Access Toolbar for a more efficient workflow. Learn powerful filtering techniques using drop-downs, conditional filters, wildcards, AND/OR logic, and advanced filters with criteria ranges for quick, flexible data analysis. Perfect for experienced users aiming to efficiently manage large datasets and personalize the Excel interface.
	Excel Expert 10 Advance your spreadsheet skills with expert techniques for efficiently managing and analyzing data, including custom views for quick data filtering, the SUBTOTAL function for accurate filtered calculations, and creating and managing outline subtotals with grouping features. Learn to control data input with data validation - apply rules, error alerts, drop-down lists, and cascading drop-downs - and use tools like DGET and INDIRECT for more dynamic forms. This course gives you practical strategies to organize complex data and enhance productivity using advanced features in Microsoft Excel.
	Excel Expert 11 This course teaches you advanced Excel techniques including how to convert video time text using functions like FIND, MID, and TEXT, as well as mastering the powerful new XLOOKUP function for flexible lookups, multiple value returns, wildcard searches, and two-way matrix searches. You will also learn how to use combo boxes for interactive user selections and enable the Developer tab to enhance spreadsheet usability, with practical examples that bring these concepts to life for real-world workflow improvements.