Learn Advanced Excel in Abeokuta, Ogun State, Nigeria or Online

  • Course level: All Levels

Description

Learn with Hands-on Projects, taught by a live instructor.

Learn practical skills by working on real projects with instructor guidance and lectures to strengthen and improve your skill.

This starts with a beginner to Expert Excel class, you’ll learn the essentials of Microsoft Excel, including calculations, basic functions, graphs, formatting, and printing. This Excel class is perfect for those with limited experience looking to expand their proficiency and also those with basic excel skills who want to go advanced.

 

What You’ll Learn in Part I – Beginner

  • Become familiar with the interface and data entry
  • Learn essential formulas and functions
  • Format and print your work
  • Create charts, including line, column, and pie charts
  • Learn tips and tricks for easy workbook management
  • Review key concepts in a final project

 

 

What You’ll Learn in Part II – Advanced

  • Learn to split and join text, add data validation, and named ranges
  • Sort & Filter databases
  • Special formatting for calculating dates
  • Create functions
  • Learn advanced analytical tools for data consolidation, conditions to exclude data, and pivot charts
  • Use database functions such as VLOOKUP & HLOOKUP
  • Use advanced database functions including INDEX, MATCH, VLOOKUP-MATCH, and INDEX-Double MATCH
  • Add logical statements, including AND, OR, and IF statements
  • Create Pivot Tables to quickly summarize large databases
  • Use statistical functions such as Ranking, COUNTIFS, and SUMIFS
  • Create advanced combo charts from multiple charts
  • Cell management including cell locking, auditing, and hot keys
  • Use advanced functions and advanced analytical tools
  • Create basic macros
  • Record macros and relative reference macros for ad hoc reporting
  • Use What-If Analysis for Goal Seek and Data Tables
  • Review key concepts by creating a final project

What Will I Learn?

  • At the end of the course you would be certified as an advanced Excel and data analyst with Excel
  • You can proceed with this skill to learn Data Analysis and Data Science.

About the instructor

Slink Digital

IT Company

A Creative Digital Company Focused On Growing Brands Online.
  • Enterprise Solutions in Nigeria
Over the years Slink Digital Technologies Ltd has been a visionary and a reliable software engineering partner for world-class brands. We have collaborated with many brands to design & develop websites, build professional apps, bots, corporate & eCommerce products, increase ROI using our complete Business Intelligence, Branding, ErP software, Management systems, hosting and digital marketing. We are that IT consultant and software development company that you need for a cutting edge engineering solutions in Nigeria and overseas. Contact us
0 (0 ratings)

6 Courses

0 students

150,000.00

Requirements

  • A Laptop with Microsoft Excel (2010 - Latest)
  • Ability to communicate using English
  • Must reside in Abeokuta to learn in our office or Learn Online from any location

Target Audience

  • Employers
  • Employers
  • Individuals
  • Entrepreneur
  • Students