Microsoft Excel Advanced

$300.00

This course provides the participant to use the spreadsheet application to produce what are deemed to be advanced spreadsheet outputs. The participant shall be able to operate effectively at more than intermediate level of competence and be able to sort, query and link data.

Description

Excel has its immense purposeful applications. 95% of the users apply the basic form. There are functions and advanced excel formula that can be used for complex calculations. The functions are designed for easy lookup and formatting of large pool of data whereas the advanced excel formula are implemented to get new information from a given particular set of data.

Course Highlights

  • Learn how to THINK like Excel, and write powerful and dynamic Excel formulas from scratch
  • Automate, streamline, and completely revolutionize your workflow with Excel
  • Master unique tips & techniques that you won’t find in ANY other course, guaranteed
  • Explore fun, interactive, and highly effective demos from a best-selling Excel instructor
  • Get LIFETIME access to project files, quizzes, homework exercises, and 1-on-1 expert support
  • Write advanced conditional, text, date and lookup functions, including XLOOKUP & Dynamic Arrays


Who Should Attend?

  • Working Accountants and Book-Keepers
  • Entrepreneurs
  • Managers
  • Data Entry Personnel
  • Finance and Accounting Students
  • Anyone who is interested to learn an application

Learning Outcome
After completion of the Advanced Excel course participants will be able to:

  • Use advanced functions and productivity tools to assist in developing worksheets
  • Manipulate data lists using Outline, Autofilter and PivotTables
  • Use Consolidation to summarise and report results from multiple worksheets
  • Record repetitive tasks by creating Macros
  • Use Hyperlinks to move around worksheets.

Pre-requisites
  • A PC and a mouse with internet connectivity with MS Excel application

Instruction Methodology
  • This course is delivered on Demonstration Methodology
  • Each Participant is required to bring with him/her laptop for the training.
  • This training comprises of brainy and intriguing exercise which will feed your brain and motivate you to learn excel in practical and simplest way.
  • Learner’s are expected to experiment their learning through hands-on practice
  • Active engagement from learners is expected for rich learning experience

Training Mode
Online

Duration
1-Day

Time
10 Am to 5 PM

Reviews

There are no reviews yet.

Be the first to review “Microsoft Excel Advanced”

Your email address will not be published. Required fields are marked *

Related Products

whatsapp-color