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

Nadia for Business

Get unlimited access to 4000+ of Nadia’s top courses for your team.

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

This course is a live online course that you can attend from the comfort of anywhere in the world. When you sign up you can see the exact timings in the schedule above. During the session, you will see the instructor live, and will be able to ask any questions you have.

If you miss a session, you will be able to watch a recording of what you missed. However, if you miss more than 2 sessions, you may not be eligible for the final course certification.

 Upon completion of this course, you will receive a NADIA Training Institute Certification (certified by the Dubai Government KHDA authority).

 Although we cannot guarantee employment, several of our graduates have gotten jobs immediately after graduation. By joining this course with NADIA Training Institute, you’ll be joining an active alumni network with exclusive access to NADIA’s job portal as well as recruitment and career support.

 If you have any other questions, please reach out to us at training@nadia-training.com