Course Details

			 
				

Excel for Business

Course Descriptions

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

Review and Rating

4.8

Average Rating

5 stars
10
4 stars
8
3 stars
0
2 stars
0
1 star
0
  • Course fee 15,000
  • Credit Hours 36 Hours
  • Duration 1 Month
  • Skill level Beginer to Professional
  • Class Timings 6:30pm - 8:00pm
  • Class Days Thu-Fri-Sat

Mr. Asad Mahmood

Principal Consultant SAP-User ID (S0019301980)
(4.8 Rate)

Enthusiast and Business Professional with years of experience and expertise in the field of Accounting, Information Technology, and Professional Training.