Excel Basic to Advance User Journey


An introduction to all the skills covered in our previous video, Microsoft Excel - A Beginner's Guide to Excel


Do you want to improve your Excel skills to become an advanced user?

This course will give you a thorough understanding of how to use some of the advanced features at the Microsoft level in Excel. Assume that you have all the knowledge taught in our Microsoft Excel preparation course in Karachi - a beginner guide to Excel.

This course includes a variety of advanced features, sophisticated graphics, special placement, audit and locking scenarios, and security formulas. Most lectures last 10 to 18 minutes and no lectures last more than 20 minutes. Your trainer for this course, Saad Hope, is a Microsoft Certified Coach who has taught Microsoft Excel in the UK for 9 years.

Microsoft Excel - Basics of advanced users


  • Special pasta
  • Conditional formatting
  • Lock and protect
  • Advanced graph
  • Data validation
  • Scenario
  • Check formulas and comments
  • Sub-Total
  • Glittering
  • Advanced filtering and screening
  • Record player and card spin
  • Cells and namespaces are named
  • Mixed cell reference
  • Mathematical and statistical functions
  • Vlookup function
  • Nested function
  • Database function
  • Text function
  • Date functions and calculations
  • Who is this course for:
  • Existing Excel users who want to improve their skills.
  • Self-taught learners who want to improve their work skills in Excel.


Excel skills to become an advanced user

At present, a lot of work requires advanced knowledge about Excel. Of course, you want to know what advanced Excel skills are? Based on my experience teaching more than 10,000 students in various online and physical training programs, the following 9 areas are at the core of Excel's advanced excellence. Sign Up today or to know more about our course, Visit Accountech Website

Expanded Formula

The formula makes Excel smart. With them, Excel is just a tool for storing data. But with formulas, you can destroy, analyze, and get answers to the most complicated questions. While anyone can use a simple SUM or IF formula, advanced users can easily write and combine formulas such as SUMIFS, SUMPRODUCT, INDEX, MATCH, and LOOKUP formulas. Advanced Excel users not only know the formula, they also know how to troubleshoot, check, and which formula is used for each case (and they also know several alternatives to formula problems).

Data, performance, tables, and formatting

Excel users who are proficient know how to collect, organize and present their data to make it look impressive. A good understanding of Excel functions such as Power Query (retrieving and changing data), spreadsheets, cell styles, and formatting options are needed to create great Excel workbooks.

Conditional formatting

Conditional formatting is a great feature in Excel that is often underused. Conditional formatting allows you to tell Excel to highlight the part of your data that meets certain conditions. For example: highlighting the 10 best customers, below the average employee, etc. While anyone can set simple conditional formatting rules, advanced Excel users can do more. You can combine conditional formulas to highlight data that fulfills almost all conditions.

Expanded graph

It makes no sense if all your analysis is buried in a large table. Advanced Excel users know that we can use graphics to communicate effectively and present results in impressive ways. Skills needed to improve the charts.

Budget versus actual chart

If the diagram contains more than 1000 words, the expanded diagram is similar to a book. Fat, funny and helpful.

Main table and reporting

With an overview table and rotation reports, we can analyze large amounts of data and answer questions with just a few clicks. Advanced Excel users are very familiar with various pivot table functions and can use them very well. Some of the advanced features of pivot tables are - connections, multiple rotations, groupings, slices, metrics (power pivots) and summaries according to various types of indicators.

VBA and macro

Excel's native VBA allows us to give Excel instructions to get things done. This is a simple but very powerful way to extend Excel's functionality. Excel users who are proficient with VBA and can write macros to automate their daily work, saving countless time and money.

Comments

Post a Comment