Advanced Excel Course in Islamabad – Rawalpindi

This Advanced Excel Course is designed for students who have completed the Excel 2023 Introduction or equivalent course or have knowledge of the topics covered in that course including entering text and numbers; using basic formulas; adjusting rows, columns, and cells; working with date and time functions; using the AutoSum button; using absolute cell reference; applying formats to numbers; inserting charts; sorting data; finding and replacing data; filtering data; creating subtotals; controlling page breaks in printed pages; setting print options; managing worksheets and workbooks as well as understanding Microsoft Office Backstage view. In this Advanced Excel Course , you will learn how to use a variety of functions and formulas. You will examine how to import and export data from other sources. Advanced Excel Course in Islamabad – Rawalpindi




Advanced Excel Skills

If you are a person who loves to learn and excel in his/her job, then this course is for you. In this course, we will teach advanced Excel skills like Introduction to Microsoft Excel 2010, VBA Programming in Microsoft Excel 2010 and Data Analysis Using VBA in Microsoft Excel 2010. You will also learn how to create macros with Visual Basic Editor (VBE). The duration of this course is 10 days which includes 6 hours of lecture per day along with practical exercises on Saturday & Sunday.

Learn to use the many useful features of MS Excel 2010 for Windows. In this advanced class, you’ll learn how to use a variety of functions and formulas, use tools to develop complex sheets and review ways to automate and protect your data.

In this advanced class, you’ll learn how to use a variety of functions and formulas, use tools to develop complex sheets and review ways to automate and protect your data.

Advanced Excel Course Outline

  • Essential Math/Stats Functions: SUM, AVERAGE, MIN, MAX, COUNT, LARGE, SMALL, FLOOR
  • Essential Text Functions: UPPER, LOWER, PROPER, FIND, TEXT, LEFT, RIGHT, MID
  • Date & Time Functions: NOW, DATEDIF, EDATE, NETWORKDAYS, WEEKDAYS, YEAR, MONTH, HOUR, MIN
  • Using Logical Functions: IF, IFS, AND, NOT, ISNA, IFERROR, ISBLANK, ISNUMBER
  • Using Excel Power Functions: SUMIFS, COUNTIFS, AVERAGEIFS
  • Using D-Functions: DSUM, DAVERAGE, DMAX, DMIN, DGET
  • Lookup Functions: VLOOKUP, HLOOKUP, INDEX, MATCH, CHOOSE
  • Working with Name Ranges & Name Manager
  • Working with Smart Tables
  • Working with Array & 3D Formulas
  • Using Flash Fill for Data Transformation & Separation
  • Creating & Customizing Charts – Column, Line, Bar, Pie and Combo Charts
  • Analyzing & Summarizing Data with Pivot Table Reports, Pivot Charts & Slicers
  • Get & Transform Data: Power Query
  • Automating Recurring Tasks with Macros
  • Using Excel Business Modeling Tools: Goal Seek, Data Tables, Solver, Scenario Manager
  • Conditional Formatting
  • And loads of Excel Tips & Tricks

The Course includes:

  • A series of lessons on creating charts in Excel 2010
  • An overview of the keyboard shortcuts available in Excel 2010
  • A demonstration of some basic tasks such as entering numbers or letters into cells on a worksheet; selecting objects within a cell; copying cells or rows/columns between worksheets; deleting rows or columns from a worksheet (and more).

In addition, you’ll examine how to import and export data in Excel and look at ways to collaborate.

In addition, you’ll examine how to import and export data in Excel and look at ways to collaborate.

  • Importing and exporting data: You’ll learn how to import and export data from Excel files or other sources.
  • Collaboration tools: You’ll also get a chance to explore collaboration tools for document management, task management, surveys and more. Examples include the Microsoft SharePoint team site (a central location where employees can share files), SharePoint online meeting rooms (which allow people working on projects together remotely) or Word Online (for collaborating on documents). Advanced Excel Course in Islamabad – Rawalpindi

Leave a Comment

Pin It on Pinterest