Advance Excel

Contents of the course

Change default settings, like font and print settings | Customize the ribbon interface

Clean, sort, filter, and format data | Import and export data from other sources

Explore complex formulas and array function | Use logical and lookup functions for sophisticated calculations

Create visually appealing charts and graphs | Add labels, titles, and other features to enhance charts

Summarize and analyze large datasets | Sort, filter, and drill down into data

Manage and organize large workbooks | Link and reference data across sheets, and automate tasks with macros.

Protect workbooks with password protection and other security features | Use display options like freeze panes and conditional formatting.

Create and run macros to automate repetitive tasks | Customize macros to suit your needs

By the end of our course, you’ll be able to take on even the most complex data analysis tasks in Excel.