Advanced Excel Crouse in Lahore, Pakistan
Duration : 40 Days (Mon-Tues) Time: 7 p.m. to 8:30 p.m.
Training Mode: Onsite + Online
Bootcamp Fee : Rs 10,000 per month, refundable*
Registration Fee: Rs. 500/- (non-refundable)
Devtrain Offering best advance Microsoft Excel boot camp in Lahore, Pakistan. Excel is one such application that does not require any preaching to be used. It is the choice of billions of corporate users due to its power, speed & simplicity of use. Most people have a basic understanding of Excel but a few know where to find Excel’s most effective & efficient power features. This course contains everything you need to know & learn about Excel. It is designed to fill the void by providing comprehensive training on Excel’s most powerful features. The course is aimed to train participants from Basic to Expert!
After the workshop, you will be able to:
- Take your Excel proficiency from Basic to advanced.
- Become more efficient in data analysis and reporting.
- Apply complex Excel functions and tools confident
Advance Excel Course Outline:
- 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
- advance data sorting
- General formulas for data analysis
- Text-to-Columns function
- Data cleanup
- advance referencing techniques
- Auditing techniques
- Advance 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
- Advance Data Auditing
- Introduction to formula audit
- Trace Precedents and Dependents
- What is a watch window?
- advance data formatting techniques
- Advance Data Analysis Techniques
- Using data validation
- Introduction to PivotTables
- advance PivotTables functions
- Using Pivot Charts
- Commenting and tracking change
- Security and Data Protection
- Sheet protection and locking
- Workbook protection and locking
- Sharing workbook
- Introduction
To become a data analyst using Excel, you need to learn skills such as:
Excel functions: Use functions like SUM, AVERAGE, COUNT, MAX, MIN, VLOOKUP, IF, INDEX, and MATCH to manipulate data and perform calculations
Data cleaning and formatting: Remove duplicates, fix inconsistencies, handle missing values, and structure data appropriately
Sorting and filtering: Sort data by columns and filter data using slicers in pivot tables
Conditional formatting: Specify formatting conditions using rules
Pivot tables: Create pivot tables from rows and columns, summarize data, represent data visually, and calculate margins and ratios
Data visualization: Represent data using charts and tables
Lessons:
