Monday, January 6, 2020

Microsoft Excel Complete Course - Beginner, Intermediate & Advanced-3035530865

Description

MS Excel Beginners Course
The Microsoft Excel beginner’s course will provide you with a comprehensive overview of all of the most well-known features of Excel and the methods to successfully use them.
The highlights of this course cover:
  • A broad overview of MS Excel
  • Calculating sums, averages, and totals
  • Summing columns or rows of numbers
  • Including cells
  • Learning formulas including IF, COUNTIF, SUMIF, VLOOKUP, HLOOKUP, and AVERAGEIF
  • Pivot tables
  • Inserting, editing, and deleting comments
  • Wrapping text
  • Creating borders
  • Merging cells
  • Pasting, ordering, and converting columns to rows
  • Designing graphs, diagrams and charts
  • Using hyperlinks
This beginner's level course highly recommended if you want to use Excel at home or work for tracking simple expenses or calculating sums or totals, adding column headings, and so on.
MS Excel Intermediate Course
The MS Excel Intermediate Course focuses on teaching you more advanced concepts of Excel in an accessible and more comprehensive guide to mind.
The highlights of the intermediate Excel course include the following:
  • Grasp advanced Excel functions such as ABS, SUMIF, HLOOKUP, VLOOKUP, COUNTIF, AVERAGEIF, and AVERAGEIFS
  • Data validation with date, list, time, and numbers
  • Other functions such as RANK, MIN, MAX, CHAR, MODE, MEDIAN, CODE, CLEAN, and EXACT
  • Techniques to eliminate duplicates in Excel
  • Creating random numbers
  • Changing text case
  • Adding passwords
  • Sending emails from Excel
  • Adding custom backgrounds
  • How to auto-fill data
  • Adding special data and characters
  • Changing border colour and theme
With having a firm basic knowledge of the beginner Excel functions, you can effortlessly get into the MS Excel Intermediate course.
The course curriculum intended for making it much easier to work with Excel in the workplace, and it is perfect for individuals who desire to enhance their skills in Excel.
MS Excel Advanced Course
After completing the beginner and intermediate courses successfully, you will move onto the MS Excel Advanced Course where you will introduce with the curriculums that well laid out with just the most essentials in Excel.
The highlights of MS Excel Advance Course cover:
  • VLOOKUP Advanced formula options and manipulations
  • Other advanced functions such as OR, AND, CHOOSE, INDIRECT, REPLACE, LEN, LEFT, FIND
  • Functions including CEILING, CORREL, DATEDIF, DATEVALUE, DAVERAGE and EDATE
  • Highlighting a cell with a formula
  • Functions including ISODD, ISNUMBER, ISTEXT, ISLOGICAL, ISNONTEXT, ISERR and ISBLANK
  • Functions including DGET, DMAX, PRODUCT, DCOUNTA, DCOUNT and DSUM
  • Calculating loan IPMT and EMI
  • Functions including DATEDIF, DATEVALUE, EDATE, EOMONTH, MATCH and INDEX
  • A detail interpretation of the INDEX and MATCH functions
  • How to look up data
  • Colouring a column and row with a formula
  • How to select only cells carrying remarks
  • Hiding formulas
The MS Excel Advanced Course will thoroughly prepare you for job posistion that require excellent command over Excel. Upon successful completion of the course it, you will gain the knowledge and skills and feel more confident that will be ideal for your career success.
Beginners Course Modules
  • Module 1: Navigate the Excel User Interface
  • Module 2: Use Excel Commands
  • Module 3: Create and Save a Basic Workbook
  • Module 4: Enter Cell Data
  • Module 5: Use Excel Help
  • Module 6: Create Worksheet Formulas
  • Module 7: Insert Functions
  • Module 8: Reuse Formulas and Functions
  • Module 9: Insert, Delete, and Adjust Cells, Columns, and Rows
  • Module 10: Search for and Replace Data
  • Module 11: Use Proofing and Research Tools
  • Module 12: Apply Text Formats
  • Module 13: Apply Number Format
  • Module 14: Align Cell Contents
  • Module 15: Apply Styles and Themes
  • Module 16: Apply Basic Conditional Formatting
  • Module 17: Create and Use Templates
  • Module 18: Preview and Print a Workbook
  • Module 19: Set Up the Page Layout
  • Module 20: Configure Headers and Footers
  • Module 21: Manage Worksheets
  • Module 22: Manage Workbook and Worksheet Views
  • Module 23: Manage Workbook Properties
Intermediate Course Modules
  • Module 1: Work with Ranges
  • Module 2: Use Specialized Functions
  • Module 3: Work with Logical Functions
  • Module 4: Work with Date & Time Functions
  • Module 5: Work with Text Functions
  • Module 6: Sort Data
  • Module 7: Filter Data
  • Module 8: Query Data with Database Functions
  • Module 9: Outline and Subtotal Data
  • Module 10: Create and Modify Tables
  • Module 11: Apply Intermediate Conditional Formatting
  • Module 12: Apply Advanced Conditional Formatting
  • Module 13: Create Charts
  • Module 14: Modify and Format Charts
  • Module 15: Use Advanced Chart Features
  • Module 16: Create a PivotTable
  • Module 17: Analyze PivotTable Data
  • Module 18: Present Data with PivotCharts
  • Module 19: Filter Data by Using Timelines and Slicers
Advanced Course Modules
  • Module 1: Use Links and External References
  • Module 2: Use 3-D References
  • Module 3: Consolidate Data
  • Module 4: Use Lookup Functions
  • Module 5: Trace Cells
  • Module 6: Watch and Evaluate Formulas
  • Module 7: Collaborate on a Workbook
  • Module 8: Protect Worksheets and Workbooks
  • Module 9: Apply Data Validation
  • Module 10: Search for Invalid Data and Formulas with Errors
  • Module 11: Work with Macros
  • Module 12: Create Sparklines
  • Module 13: MapData
  • Module 14: Determine Potential Outcomes Using Data Tables
  • Module 15: Determine Potential Outcomes Using Scenarios
  • Module 16: Use the Goal Seek Feature
  • Module 17: Forecasting Data Trends
Whatsapp: +923035530865, 03219606785, 3315145601,
03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad

 

Excel 2016 Essentials - Training Course Microsoft Office Certification-3035530865


Description

What is covered in this Excel 2016 Essentials online course?
This Excel 2016 Essentials online training course covers the following modules:
Module One: Create and Manage Worksheets and Workbooks
  • Create Worksheets and Workbooks

    • Create a workbook
    • Import data from a delimited text file
    • Add a worksheet to an existing workbook
    • Copy and move a worksheet
  • Navigate in Worksheets and Workbooks

    • Search for data within a workbook
    • Navigate to a named cell, range, or workbook element
    • Insert and remove hyperlinks
  • Format Worksheets and Workbooks

    • Change worksheet tab color
    • Rename a worksheet
    • Change worksheet order
    • Modify page setup
    • Insert and delete columns or rows
    • Change Workbook themes
    • Adjust row height and column width
    • Insert headers and footers
  • Customize Options and Views for Worksheets and Workbooks

    • Hide or unhide worksheets
    • Hide or unhide columns and rows
    • Customize the Quick Access toolbar
    • Change workbook views
    • Change window views
    • Modify document properties
    • Change magnification by using zoom tools
    • Display formulas
  • Configure Worksheets and Workbooks for Distribution

    • Set a print area
    • Save workbooks in alternative file formats
    • Print all or part of a workbook
    • Set print scaling
    • Display repeating row and column titles on multiple worksheets
    • Inspect a workbook for hidden properties or personal information
    • Inspect a workbook for accessibility issues
    • Inspect a workbook for compatibility issues
Module Two: Manage Data Cells and Ranges
  • Insert data in cells and ranges

    • Replace data
    • Cut, copy, or paste data
    • Paste data by using special paste options
      fill cells by using Auto Fill
    • Insert and delete cells
  • Format cells and ranges

    • Merge cells
    • Modify cell alignment and indentation
    • Format cells by using Format Painter
    • Wrap text within cells
    • Apply number formats
    • Apply cell formats, apply cell styles
  • Summarize and organize data

    • Insert sparklines
    • Outline data
    • Insert subtotals
    • Apply conditional formatting
Module Three: Create tables
  • Create and manage tables

    • Create an Excel table from a cell range
    • Convert a table to a cell range
    • Add or remove table rows and columns
  • Manage table styles and options

    • Apply styles to tables
    • Configure table style options
    • Insert total rows
  • Filter and sort a table

    • Filter records
    • Sort data by multiple columns
    • Change sort order
    • Remove duplicate records
Module Four: Perform operations with formulas and functions
  • Summarize data by using functions

    • Insert references
    • Perform calculations by using the SUM function
      Perform calculations by using MIN and MAX functions
    • Perform calculations by using the COUNT function
    • Perform calculations by using the AVERAGE function
  • Perform conditional operations by using functions

    • Perform logical operations by using the IF function
    • Pperform logical operations by using the SUMIF function
    • Perform logical operations by using the AVERAGEIF function
    • Perform statistical operations by using the COUNTIF function
  • Format and modify text by using functions

    • Format text by using RIGHT, LEFT, and MID functions
    • Format text by using UPPER, LOWER, and PROPER functions
    • Format text by using the CONCATENATE function
Module Five: Create charts and objects
  • Create charts

    • Create a new chart
    • Add additional data series
    • Switch between rows and columns in source data
    • Analyze data by using Quick Analysis
  • Format graphic elements

    • Resize charts
    • Add and modify chart elements
    • Apply chart layouts and styles
    • Move charts to a chart sheet
  • Insert and format objects

    • Insert text boxes and shapes
    • Insert imagesModify object properties
    • Add alternative text to objects for accessibility

Career path

Anyone who successfully passes this course could progress to any of the following positions:
  • Software Engineer
  • Technical Support
  • Technical Sales
  • Business Analyst
  • Web Developer
  • Software Tester
  • IT professionals
  • Technical IT professionals
  • Project-based technical analysts and engineers
  • Technical support personnel
Whatsapp: +923035530865, 03219606785, 3315145601,
03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad

No comments:

Post a Comment