
Master Excel's powerful XLOOKUP function to streamline data lookup and analysis. Learn its advantages over VLOOKUP and Index/Match, and explore advanced features for efficient spreadsheet management.

Enhance data management skills with advanced Excel techniques, including list design, pivot tables, charts, data validation, and conditional formatting for improved efficiency and analysis.

Comprehensive tutorial on advanced Microsoft Access features, covering form design, automation with macros and VBA, database security, and customization options for improved efficiency and functionality.

Master advanced Excel VBA techniques to automate processes, create custom tools, and enhance productivity. Learn to build macros, use complex functions, and develop custom solutions for data analysis and workflow optimization.

Advanced Excel techniques for data analysis, including VLOOKUP troubleshooting, INDEX MATCH, PivotTables, array formulas, conditional formatting, and macros. Ideal for users seeking to enhance efficiency and problem-solving skills.

Master advanced Excel skills: named ranges, complex functions, data analysis tools, and macros. Boost efficiency and tackle sophisticated spreadsheet tasks with confidence.

Comprehensive tutorial covering Excel 2019 basics, from interface navigation to formulas, functions, data organization, and time-saving features for beginners and everyday users seeking to enhance productivity.

Comprehensive tutorial on intermediate Access 2021 skills, covering queries, forms, reports, automation, and advanced techniques for efficient database management and data analysis.

Learn to automate Excel tasks using VBA. Master macro recording, editing, and scripting basics. Ideal for business analysts and data scientists seeking to enhance Excel productivity and create custom tools.

Comprehensive tutorial on Microsoft Access 2021 covering database creation, table design, data import, relationships, queries, forms, reports, and advanced features for beginners to experienced users.

Comprehensive guide to mastering OneNote's features for efficient note-taking, organization, and collaboration. Learn to create, format, secure, and share digital notebooks for personal and professional use.

Comprehensive tutorial covering intermediate Access 2019 skills, including form and report design, query creation, data relationships, and automation techniques for efficient database management.

Comprehensive tutorial on advanced Access 2019 features, covering complex forms, macros, VBA, database security, and automation techniques for efficient data management and reporting.

Discover a six-step process to harness imagination, spark new ideas, and explore its untapped potential in science, tech, and beyond. Learn to systematically cultivate creativity and innovation.

Collaborative initiative addressing sexual harassment in STEMM fields through policy development, resource sharing, and innovative tools to foster inclusive and equitable environments for all professionals.

Learn about the Departmental Action Team model for facilitating positive, sustained change in higher education. Discover guiding principles, implementation strategies, and potential impacts on departmental transformation.

Explore a mathematician's journey to Technical Director at the DoD, offering insights on career transitions, research, and leadership in government roles.

Explore bitcoin volatility trading, hedging strategies, and crypto market dynamics. Gain insights into implied volatility, variance risk premium, and perpetual futures in unregulated exchanges.

Explore multivariate portfolio optimization using quantiles, extending univariate approaches to solve complex financial problems and develop new numerical solutions for multivariate preferences.

Explore effective strategies for mastering data science, machine learning, and programming, including balancing theory and practice, project-based learning, open-source contributions, and following personal interests.

Explore distributed payment systems, mobile money revolution, and the DigiTally project with Ross Anderson. Insights on challenges, field trials, and lessons learned in building truly decentralized financial solutions.