Home / Courses / ICT and Security Management
ICT and Security Management · MSD2836

Microsoft Excel – Advanced Excel Formulas, Functions & Dashboards

Elevate your Excel skills with Magna Skills' Advanced Excel Formulas, Functions & Dashboards course. Tailored for professionals and enthusiasts, this program delves into advanced Excel techniques, equipping participants with the tools to analyze data, automate processes, and craft compelling dashboards. With a focus on hands-on learning and real-world applications, this course is ideal for those seeking to maximize their Excel proficiency.

Register Online Face to Face Registration Download Course Details
Microsoft Excel – Advanced Excel Formulas, Functions & Dashboards
Online fee from
$200 USD
Standard: $300 · Save $100
Course Outcomes

Expected learning outcomes

Upon completion of the course, participants will:

  1. Master advanced Excel formulas and functions for complex data analysis.
  2. Learn techniques for data validation, conditional formatting, and data manipulation.
  3. Understand the power of PivotTables and PivotCharts for effective data summarization and visualization.
  4. Create dynamic and interactive dashboards to communicate insights effectively.
  5. Automate repetitive tasks with macros and VBA (Visual Basic for Applications).
  6. Gain proficiency in advanced data analysis tools and scenarios.
  7. Develop skills in troubleshooting and error handling in Excel.
Curriculum

Course modules and outline

Module 1: Advanced Formulas and Functions

  • Understanding Array Formulas
  • Nested Functions and Formula Auditing
  • Lookup and Reference Functions (INDEX, MATCH, VLOOKUP, HLOOKUP)
  • Text Functions for Data Manipulation
  • Date and Time Functions

Module 2: Data Analysis and Visualization

  • Data Validation Techniques
  • Advanced Conditional Formatting
  • Sorting and Filtering Data
  • Grouping and Outlining Data
  • Introduction to Power Query for Data Transformation

Module 3: PivotTables and PivotCharts

  • Creating PivotTables for Data Summarization
  • Formatting and Customizing PivotTables
  • PivotCharts for Visual Data Analysis
  • Slicers and Timelines for Dashboard Interactivity

Module 4: Dashboard Design and Creation

  • Principles of Effective Dashboard Design
  • Building Interactive Dashboards
  • Incorporating Charts and Graphs
  • Data Visualization Best Practices

Module 5: Automation with Macros and VBA

  • Introduction to Macros and the Macro Recorder
  • Writing and Editing VBA Code
  • Automating Tasks with Macros
  • Error Handling and Troubleshooting

Module 6: Advanced Data Analysis Tools

  • Goal Seek and Solver for What-If Analysis
  • Scenario Manager for Decision-Making
  • Data Tables and Consolidation

Final Project: Real-world Application Participants will apply the skills learned throughout the course to create a comprehensive Excel project, showcasing their ability to analyze data, build dynamic dashboards, and automate tasks.

Enroll in Magna Skills' Advanced Excel Formulas, Functions & Dashboards course to unlock the full potential of Excel and enhance your data analysis capabilities.

Target Audience

Who should attend?

Microsoft Excel

Why Attend

Key course benefits

Practical capacity building approach
Designed for government, NGOs and public institutions
Real-world African case studies
Certificate of completion
Applicable tools and templates
Interactive facilitation and exercises
Course Enquiry

Need more information?

Ask Magna Skills about this course

Use the PHPMaker enquiry form to request a quotation, proposal letter, invoice, group training package, online access, or face-to-face training arrangement.

Make Course Enquiry WhatsApp Us

Debug

sql: SELECT COUNT(*) FROM `userlevels` WHERE `userlevelid` = -2, executionMS: 0.0020439624786377

sql: SELECT `userlevelid`, `userlevelname` FROM `userlevels`, executionMS: 0.00045609474182129

sql: SELECT COUNT(*) FROM `userlevelpermissions` WHERE `userlevelid` = -2, executionMS: 0.00081205368041992

sql: SELECT `tablename`, `userlevelid`, `permission` FROM `userlevelpermissions` WHERE `userlevelid` IN (-2), executionMS: 0.0029020309448242

sql: SELECT c.*, cc.Category_Name, cc.Summary AS CategorySummary, cc.Category_Description FROM courses c LEFT JOIN course_categories cc ON cc.id = c.Category WHERE c.id = 2836 LIMIT 1, executionMS: 0.0010201930999756

sql: UPDATE courses SET Views = IFNULL(Views,0) + 1 WHERE id='2836', executionMS: 0.0018517971038818

sql: SELECT * FROM course_modules WHERE CourseID = 2836 AND Status IN ('Active','1') ORDER BY SortOrder, id LIMIT 20, executionMS: 0.0005040168762207

sql: SELECT * FROM course_highlights WHERE CourseID = 2836 AND Status IN ('Active','1') ORDER BY SortOrder, id LIMIT 8, executionMS: 0.00030183792114258

sql: SELECT * FROM course_learning_outcomes WHERE CourseID = 2836 AND Status IN ('Active','1') ORDER BY SortOrder, id LIMIT 10, executionMS: 0.00031113624572754

sql: SELECT * FROM course_target_audience WHERE CourseID = 2836 AND Status IN ('Active','1') ORDER BY SortOrder, id LIMIT 8, executionMS: 0.00027298927307129

sql: SELECT * FROM resources WHERE CourseID = 2836 AND Status IN ('Published','Active','1') ORDER BY id DESC LIMIT 5, executionMS: 0.0002751350402832

sql: SELECT * FROM reviews WHERE CourseID = 2836 AND CanPublish = 1 AND Status IN ('Approved','Published','1') ORDER BY id DESC LIMIT 4, executionMS: 0.00034785270690918

sql: SELECT * FROM gallery_albums WHERE CourseID = 2836 AND Status IN ('Published','Active','1') ORDER BY IsFeatured DESC, AlbumDate DESC, id DESC LIMIT 3, executionMS: 0.00032711029052734

sql: SHOW COLUMNS FROM `venues` LIKE 'id', executionMS: 0.00095891952514648

sql: SELECT v.*, v.`id` AS VenueKey, (SELECT COUNT(*) FROM apply a WHERE a.Venue = v.`id` AND a.Course_Title = 2836) AS CourseApplications, (SELECT COUNT(*) FROM apply a WHERE a.Venue = v.`id`) AS TotalApplications FROM venues v ORDER BY CourseApplications DESC, TotalApplications DESC, v.Venue ASC, executionMS: 1.6526420116425

sql: SHOW COLUMNS FROM `courses` LIKE 'Category', executionMS: 0.0012350082397461

sql: SELECT id, Course_Title, Course_Code, Short_Description FROM courses WHERE Category = 809 AND id <> 2836 ORDER BY id DESC LIMIT 6, executionMS: 0.0006709098815918

sql: SELECT COUNT(*) FROM apply WHERE Course_Title = 2836, executionMS: 0.067610025405884

sql: SELECT COUNT(*) FROM enroll WHERE Course = 2836, executionMS: 0.00080513954162598

sql: SELECT ROUND(AVG(Rating),1) FROM reviews WHERE CourseID = 2836 AND CanPublish = 1, executionMS: 0.00048112869262695

sql: SELECT COUNT(*) FROM course_modules WHERE CourseID = 2836, executionMS: 0.00028181076049805

sql: SELECT COUNT(*) FROM course_lessons cl INNER JOIN course_modules cm ON cm.id = cl.ModuleID WHERE cm.CourseID = 2836, executionMS: 0.00036311149597168

sql: SELECT COUNT(*) FROM course_highlights WHERE CourseID = 2836, executionMS: 0.00028395652770996

sql: SELECT COUNT(*) FROM course_learning_outcomes WHERE CourseID = 2836, executionMS: 0.00022602081298828

sql: SELECT COUNT(*) FROM course_target_audience WHERE CourseID = 2836, executionMS: 0.00023603439331055

sql: SELECT COUNT(*) FROM resources WHERE CourseID = 2836, executionMS: 0.00025701522827148

sql: SELECT COUNT(*) FROM reviews WHERE CourseID = 2836, executionMS: 0.00021600723266602

sql: SELECT COUNT(*) FROM gallery_albums WHERE CourseID = 2836, executionMS: 0.00016593933105469

sql: SELECT COUNT(*) FROM course_enquiries WHERE CourseID = 2836, executionMS: 0.00022196769714355