MS Excel with PowerBI

Course Overview

Master Advanced Excel Features. Become A Expert And Learn To Use Excel Like A Pro With This Advanced Excel Training.

Curriculum

  • Introduction
    • What is a spreadsheet?
    • Rows and columns
    • Raw data and information
  • Introduction to Excel
    • Text formatting
    • Cell structure in the spreadsheet
    • Using the fill handle
    • Numeric representation
    • General editing techniques
    • Printing adjustment
    • Cell type setup
  • Basic Spreadsheet Operations
    • Using the AutoSum function
    • Auto Fill Quick Tip
    • Finding data in spreadsheet
    • Sorting and filtering
    • Formatting the data
    • Format Painter Quick Tip
    • Table creation and formatting
    • Charting and Analysis
    • Views in excel
  • Data Analysis in Excel
    • Advanced data sorting
    • General formulas for data analysis
    • Text-to-Columns function
    • Data cleanup
    • Advanced referencing techniques
    • Auditing techniques
  • Advanced Formulas and Functions
    • Using the IF function
    • Complex IF scenarios
    • Combining SUM and IF
    • Introduction to COUNT and IFS
    • Nested IF and special functions
    • Naming cells and cross-referencing
  • Advanced Data Auditing
    • Introduction to formula audit
    • Trace Precedents and Dependents
    • What is a watch window?
    • Advanced data formatting techniques
  • Advanced Data Analysis Techniques
    • Using data validation
    • Introduction to PivotTables
    • Advanced PivotTables functions
    • Using PivotCharts
    • Commenting and tracking change
  • Security and Data Protection
    • Sheet protection and locking
    • Workbook protection and locking
    • Sharing workbook

Submit Reviews

MS Excel with PowerBI

PKR: 15,000

  • Class Days: Thu-Fri-Sat
  • Duration: 1 Month
  • Skill Level:Beginner to Professional
  • Class Timings: 6:30-8:00pm
  • Rating: (4.6/5)
  • Upcoming: New Batch : 28th May 2021

Meet the Trainer

Asad Mahmood

S/4HANA 1809 Certified FI | CO | BPI | CF | PS | BPC | ACTIVATE

Join Thousand of Happy Students!

Subscribe our newsletter & get latest news and updation!