This course will introduce participants to advanced Excel techniques that will improve their ability to summarise data or perform data calculations. Students will learn how to use functions in Excel in this course. The introduction will cover the fundamental operations, after which calculations and expressions will be thoroughly examined. The advanced features will be thoroughly examined. Additionally, the course will cover regressions, what-if analysis, and solver. Students are capable of creating pivot tables, pivot charts, and macros as well as executing them by the end of the course. Professionals can use this course to get certified by Microsoft.
Schedule: Monday, Wednesday, Friday - 6pm - 9pm
Get trained by industry Experts
Our courses are delivered by professionals with years of experience having learned first-hand the best, in-demand techniques, concepts, and latest tools.Official Certification curriculum
Our curriculum is kept up to date with the latest official Certification syllabus and making you getting ready to take the exam.Tax Credit
Claim up to 25% of tuition fees and education tax credit from your taxes.Discount on Certification Voucher
Upto 50 percent discount voucher will be provided.24/7 Lab access
Our students have access to their labs and course materials at any hour of the day to maximize their learning potential and guarantee success.Analyzing Data with Excel
This module explores launching Excel, Microsoft Excel Startup Screen, Customizing the Excel Quick Access Toolbar, More on the Excel Interface, Understanding the Structure of an Excel Workbook, Saving an Excel Document, Opening an Existing Excel Document, Common Excel Shortcut Keys.
This module comes with Entering Text to Create Spreadsheet Titles, Working with Numeric Data in Excel, Entering Date Values in Excel, Working with Cell References, Creating Basic Formulas in Excel and Relative Versus Absolute Cell References in Formulas
This module provides knowledge about Working with the SUM() Function, Working with the MIN() and MAX() Functions, Working with the AVERAGE() Function, Working with the COUNT() Function, Adjacent Cells Error in Excel Calculations, Using the AutoSum Command, Excel's AutoSum Shortcut Key and Using the AutoFill Command to Copy Formulas.
This module covers moving and copying Data in an Excel Worksheet, Inserting and Deleting Rows and Columns, Changing the Width and Height of Cells, Hiding and Unhiding Excel Rows and Columns, Renaming an Excel Worksheet, Deleting an Excel Worksheet and Moving and Copying an Excel Worksheet.
This module makes you familiar with Working with Font Formatting Commands, Changing the Background Color of a Cell, Adding Borders to Cells, Excel Cell Borders Continued, Formatting Data as Currency Values, Formatting Percentages, Using Excel's Format Painter, Creating Styles to Format Data, Merging and Centering Cells, Using Conditional Formatting and Editing Excel Conditional Formatting.
This module comes with Inserting Images, Inserting Excel Shapes and Formatting Excel Shapes.
This module provides with the necessary knowledge of Creating an Excel Column Chart, Working with the Excel Chart Ribbon, Adding and Modifying Data on an Excel Chart, Formatting an Excel Chart, Moving a Chart to another Worksheet and Working with Excel Pie Charts
This module explores the Sorting a List Using Single Level Sort, Sorting a List Using Multi-Level Sorts, Using Custom Sorts in an Excel List, Filter an Excel List Using the AutoFilter Tool, Creating Subtotals in a List, Format a List as a Table, Using Conditional Formatting to Find Duplicates and Removing Duplicates.
This module provides and overview of Excels Function: DSUM(), Excel DSUM Function Single Criteria Continued, Excel DSUM Function with OR Criteria, Excel DSUM Function with AND Criteria, Excel Function: DAVERAGE(), Excel Function: DCOUNT() and Excel Function: SUBTOTAL()
This module provides idea about creating an Excel Data Validation List, Excel Decimal Data Validation, Adding a Custom Excel Data Validation Error and Dynamic Formulas by Using Excel Data Validation Techniques
This module presents idea about the importing Data Into Microsoft Excel, Importing Data from Text Files, Importing Data from Microsoft Access, Import Data From Text Files into Excel, Import Data From a Database into Excel, Microsoft Excel Legacy Import Options for New Excel Versions and Exporting Data to a Text File.
This module presents Creating an Excel PivotTable, Modifying Excel PivotTable Calculations, Formatting PivotTable Data, Modifying PivotTable Calculations, Drilling Down into PivotTable Data, Creating PivotCharts, Filtering PivotTable Data and Filtering with the Slicer Tool.
This module presents Using the Freeze Panes Tool, Grouping Data (Columns and/or Rows), Print Options for Large Sets of Data, Linking Worksheets (3D Formulas) and Consolidating Data from Multiple Worksheets
This module presents Working with Excel Name Ranges, Advantages and Disadvantages of Excel Name Ranges, Editing an Excel Name Range, Using Excel's IF() Function, Excel's IF() Function with a Name Range, Nesting Functions with Excel, Nesting Excels AND() Function within the IF() Function, Using Excel's COUNTIF() Function, Using Excel's SUMIF() Function and Using Excel's IFERROR() Function
This module covers Microsoft Excel VLOOKUP() Function, Microsoft Excel HLOOKUP() Function, Microsoft Excel INDEX() Function, Microsoft Excel MATCH() Function, Microsoft Excel INDEX() and MATCH() Function Combined, Microsoft Excel INDEX() and MATCH() Function Combined Continued and Creating a Dynamic HLOOKUP() with the MATCH() Function.
This module presents Understanding Excel Macros, Activating the Developer Tab in Excel, Editing a Macro with VBA and Creating Buttons to Run Macros.
Interested in gaining IT knowledge and enter into real world IT domain, switching carears in IT or applying for entry level positions
Exam 77-727 - Excel 2016: Core Data Analysis, Manipulation, and Presentation
Upon completing this cerification course you will: