MICROSOFT
EXCEL
Course

WHO IS MICROSOFT EXCEL COURSE FOR?

Microsoft Excel is a spreadsheet program used to store and retrieve numerical data in a grid format of columns and rows. Excel is ideal for entering, calculating and analyzing company data such as sales figures, sales taxes or commissions. Microsoft Excel training provides a grid interface to organize nearly any type of information.

WHAT WILL I LEARN?

Summarizing Data

  • Summarizing Data
  • Conditional Formatting
  • Custom Formats
  • Creating Custom Formats
  • Styles
  • Saving Your Work
  • Save Documents Automatically
  • Making Backup Copies
  • Group Editing
  • Editing Groups of Sheets Simultaneously
  • Data Consolidation
  • Creating Consolidation
  • Linking Worksheets
  • Linking Worksheets in the Same Workbook
  • Viewing Two Different Sheets of the Same Workbook
  • Linking Workbooks
  • Saving Linked Workbooks
  • Opening Linked Workbooks
  • Sharing Workbooks
  • Merging Workbooks
  • Creating Merging Workbooks

Advanced Functions in Excel

  • Advanced Functions in Excel
  • The DSUM Function
  • The SUMIF and COUNTIF Functions
  • SUMIFS function
  • COUNTIFS function
  • SUMPRODUCT Function
  • Round Function
  • INT Function
  • The Text Functions
  • CONCATENATE
  • CASE Functions: UPPER, LOWER, and PROPER
  • Text to Columns
  • LEN function
  • VALUE Function
  • Financial Formulas
  • The PMT Function
  • ISPMT Function
  • NPER function

More Functions in Excel

  • The VLOOKUP Function
  • Select a Location for a Lookup Table
  • Creating a Lookup Table
  • Combine VLOOKUP and Data Validation
  • HLOOKUP function
  • OFFSET function within a SUM function
  • Match Function
  • INDEX Function
  • Hyperlink
  • DATEDIF

Pivot Tables & Pivot Charts

  • Customized Sorting
  • Default Sort Orders
  • Create a Custom Sort Order
  • Custom Sort
  • Applying a Custom Sort Order
  • Pivot Table
  • Creating a Pivot Table Report
  • Create a PivotChart report
  • Change the data or fields included in the source range for a PivotTable or PivotChart report
  • Create Calculated Field in Pivot Table with Excel
  • Slicers
  • Data Forms

Advanced Features: Data Analysis

  • Overview of What-If Analysis
  • Data Tables
  • Data Tables Based on One Input Variable
  • Data Tables Based on Two Input Variables
  • Goal Seek
  • Solver
  • Scenario Manager
  • Creating Scenario Reports
  • Validating Data
  • Auditing in a Worksheet
  • Displaying the Auditing Buttons
  • Cell Precedents and Dependents
  • Auditing Your Worksheet Visually
  • Finding Precedent Cells
  • Finding Dependent Cells
  • Tracking down Errors
  • Deleting the Tracer Arrows
  • Removing Precedent Arrows
  • Removing Dependent Arrows
  • Removing All Arrows

Macros and Custom Functions

  • Record a Macro
  • Testing the Macro
  • Using the Macro Command on the Code Group
  • Using the Shortcut
  • Viewing the Macro Code
  • Assigning Your Macro to the Toolbar
  • Delete a Macro
  • Custom Functions
  • Creating a Custom Function
  • Using Custom Functions
  • Summarizing Data
  • Conditional Formatting
  • Custom Formats
  • Creating Custom Formats
  • Styles
  • Saving Your Work
  • Save Documents Automatically
  • Making Backup Copies
  • Group Editing
  • Editing Groups of Sheets Simultaneously
  • Data Consolidation
  • Creating Consolidation
  • Linking Worksheets
  • Linking Worksheets in the Same Workbook
  • Viewing Two Different Sheets of the Same Workbook
  • Linking Workbooks
  • Saving Linked Workbooks
  • Opening Linked Workbooks
  • Sharing Workbooks
  • Merging Workbooks
  • Creating Merging Workbooks
  • Advanced Functions in Excel
  • The DSUM Function
  • The SUMIF and COUNTIF Functions
  • SUMIFS function
  • COUNTIFS function
  • SUMPRODUCT Function
  • Round Function
  • INT Function
  • The Text Functions
  • CONCATENATE
  • CASE Functions: UPPER, LOWER, and PROPER
  • Text to Columns
  • LEN function
  • VALUE Function
  • Financial Formulas
  • The PMT Function
  • ISPMT Function
  • NPER function
  • The VLOOKUP Function
  • Select a Location for a Lookup Table
  • Creating a Lookup Table
  • Combine VLOOKUP and Data Validation
  • HLOOKUP function
  • OFFSET function within a SUM function
  • Match Function
  • INDEX Function
  • Hyperlink
  • DATEDIF
  • Customized Sorting
  • Default Sort Orders
  • Create a Custom Sort Order
  • Custom Sort
  • Applying a Custom Sort Order
  • Pivot Table
  • Creating a Pivot Table Report
  • Create a PivotChart report
  • Change the data or fields included in the source range for a PivotTable or PivotChart report
  • Create Calculated Field in Pivot Table with Excel
  • Slicers
  • Data Forms
  • Overview of What-If Analysis
  • Data Tables
  • Data Tables Based on One Input Variable
  • Data Tables Based on Two Input Variables
  • Goal Seek
  • Solver
  • Scenario Manager
  • Creating Scenario Reports
  • Validating Data
  • Auditing in a Worksheet
  • Displaying the Auditing Buttons
  • Cell Precedents and Dependents
  • Auditing Your Worksheet Visually
  • Finding Precedent Cells
  • Finding Dependent Cells
  • Tracking down Errors
  • Deleting the Tracer Arrows
  • Removing Precedent Arrows
  • Removing Dependent Arrows
  • Removing All Arrows
  • Record a Macro
  • Testing the Macro
  • Using the Macro Command on the Code Group
  • Using the Shortcut
  • Viewing the Macro Code
  • Assigning Your Macro to the Toolbar
  • Delete a Macro
  • Custom Functions
  • Creating a Custom Function
  • Using Custom Functions

Request a callback

JOIN 1000'S OF PROFESSIONALS

Loading
  • Client Image

    I really enjoyed the training and felt so comfortable during that period.  The instructor’s style was very effective by explaining every subject and giving examples for each one. I really recommend my friends to come and participate in courses here
    • Zana Namiq
    • NADIA Training Alumni
  • Client Image

    Today I completed online Personality Development training conducted by Mr Tinu Thomas. The sessions were very informative, inspiring and interesting. He gave real life like examples which helped me understand the concepts clearly. My confidence level improved and I hope this course would help me pursue my future career in a better way. Thank you so much, Tinu.
    • GS Meera
    • NADIA Training Alumni
  • Client Image

    I just completed my training at Nadia with the trainer (Tinu Thomas). Tinu made the classes so interesting and he gave attention to each student. Classes were very informative. I will definitely recommend to my friends. 🙂 Mariska was so helpful throughout the course for any assistance. Thank you so much to team Nadia!
    • Sherin Kabeer
    • NADIA Training Alumni
  • Client Image

    I did my PHRM training with Mr. Tinu from Nadia and it was a fruitful learning experience for me. Mr. Tinu is a great trainer and he gives attention to each student in his class. He always ensures that each student understand every concept. I'm so glad that I chose Nadia and had the chance to learn from the best. Looking forward to do more professional trainings with Mr. Tinu.. Thank you Mr. Tinu and Nadia !!
    • Hashini K
    • NADIA Training Alumni

Frequently Asked Questions

NADIA Training Institute has been the benchmark for professional training in the Gulf market for more than 38 years. We have built thousands of careers and developed skill sets with our world-class training courses. Whether you want to enhance your job prospects or increase your productivity at work, you will find suitable courses at NADIA.

Yes, we do offer weekend and weekday classes based on students requirements. This may be planned with our learning consultants at the time of course registration.

Upon completion of any training program, while we cannot guarantee employment, we can connect you to recruiters and job vacancies from within our network.

NADIA Training Institute supports several different payment methods including cost-free instalment payment plans. Find out more by speaking to one of our learning consultants.

For partnership and business development inquiries, please contact us at training@nadia-training.com.

Check out our Help and Support center to find quick answers to your questions.