Microsoft Excel for Data Analyst

Excel is by far the worlds most popular spreadsheet program and is useful for everything from maintaining simple household budgets to building sophisticated financial models or designing complex dashboards. Analysing Business Data with Excel shows you how to solve real-world business problems by taking Excels data analysis features to the maximum, rather than focusing on individual Excel functions and features. 

VBA and Macros Training

VBA and Macros Training is a practical and hands-on course that empowers participants to become proficient in automating Excel tasks using VBA. Throughout the training, participants will delve into the VBA programming language, learning how to create, modify, and execute macros to automate repetitive processes. The course covers various topics, including variables, loops, conditional statements, user-defined functions, and interacting with Excel objects.

Excel Pro Tips: 75+ Tips to go from Excel Beginner to Pro

The course teaches to:

• Productivity tips (navigation, flash fill, cell protection, advanced sorting & filtering, and more)

• Formatting tips (freeze panes, row/column grouping, advanced custom formats, and more)

• Formula tips (formula auditing tools, fuzzy lookups, detecting duplicates, randomization, and more)

• Visualization tips (sparklines, filled maps, custom templates, Excel form controls, and more)

• Pivot Table tips (slicers & timelines, custom layouts, value calculations, and more)

• Analytics tips (outlier detection, Monte Carlo simulation, forecasting, CUBE functions, and more)