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
- 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
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