Course Information
- Course Price $250
- Total Students 800+
- Course Duration 4 Weeks
Description
Microsoft Excel assists in evaluating and presenting worthwhile data in a graphical form. Several users and professionals all over the world need it to maintain records in a systematic manner. Managers, business owners, scientists etc use Excel to control and evaluate data. Better data visualization and comprehension of data assists to make better business decisions.
Benefits
- VLOOKUP, HLOOKUP, Grouping, Validation Rules, SUM, COUNT, Pivot Table, Formulas, Pivot Chart etc, are some of the concepts that you will be imparted through this training.
- You will be able to get a clear idea of an otherwise complex database. Our main aim is to make Excel understandable to you.
- We want to make the task simpler to perform applying MS Excel advanced techniques.
- LETFIX is aware that MS Excel is having wide usage. We are also cognizant that MS-Excel content coverage is vast and can turn out to be complex to handle.
- We have meticulously framed this course as per the demands of the industry. The structure and course content of Advanced MS Excel Classes is designed such that it assists the professionals to perform all the calculations and visualizations in a quick manner.
Syllabus
- Font formatting
- Number formatting
- Table formatting
- Conditional formatting
- Hide / Unhide
- Sort / filter
- Paste special
- Find and select
- Illustrations
- Charts
- Text
- Sum/ Average/ Count/ Max/ Min
- Basic Text/date/time/lookup/information functions
- Name manager
- Formula Auditing
- Import from web
- Import from text
- Text to columns
- Remove duplicates
- Grouping and ungrouping
- Proofing
- Comments
- Protection
- Types of views
- Zoom
- Windows
- Enable developer
- Using checkbox/option buttons.
Advanced Excel
- Difference between Excel 2003, 2007 and 2010,2013,2016
- Use of Excel, its boundaries & features
- Formulae that Add/Subtract/Multiply/Divide
- BODMAS/Formula Error Checking
- The Sum Function
- Problems with Absolute/Relative Cell Referencing
- Creating Absolute/Mixed References
- The VLOOKUP/HLOOKUP Functions
- Creating, Formatting Simple PivotTables
- Page Field in a PivotTable
- Formatting a PivotTable
- Creating/Modifying a PivotChart
- IFs and Nested IF Functions
- Using AND/OR/NOT Functions
- Using The SUMIF/COUNTIF Functions
- Using The AVERAGE/COUNT/LARGER/SMALLER Functions
- Adding new calculated Fields / Items
- Changing the Summary Function
- Consolidate Pivot table
- MATCH with VLOOKUP Functions
- INDEX & MATCH Functions
- OFFSET/ INDIRECT functions
- If Loop and Nested IF Loop Functions
- Using IF/ISERROR Functions
- The Chart Wizard
- Chart Types
- Adding Title / Legends / Labels
- Printing Charts
- Adding Data to a Chart
- Formatting/Renaming/Deleting Data Series
- Changing the Order of Data Series
- Using the Today
- Now & Date Functions
- Using the Dated if / Network days / Eomonth Functions
- Using the Weeknum Functions
- Using the Edate / Network days. Intl / Weekdays. Intl Functions
- The Mid/ Search/ Left/ Right Functions
- Using the Trim/ Clean/ Upper/ Lower Functions
- Using the Substitute/ Text Functions
- Using the Trim/ Clean/ Proper/ Dollar Function
- Input Messages / Error Alerts/ Drop-Down Lists
- Conditional Formatting
- Extracting Records with Advanced Filter
- Using Formulas in Criteria
- Sorting by Top to Bottom / Left to Right
- Creating / Deleting Custom List
- Sort by using Custom List
- Hyper linking data, within sheet / workbook
- Linking & Updating links between workbooks & application
- Using SUMPRODUCT Functions
- Using FLOOR/ CEILING/ MROUND/ MOD/ QUOTIENT Functions
- Creating Subtotals/Nested Subtotals
- SUBTOTALS Formula
- Creating/Working with an Automatic/Manual Outline
- Grouping / Ungrouping
- Consolidating Data with Identical/Different Layout
- Displaying/Removing Dependent & Precedent Arrows
- Evaluate Formula – Step IN/ Step Out
- Creating Custom Views
- Displaying Custom Views
- Deleting Custom Views
- Sharing Workbooks & Tracking Changes
- Protecting sheets / workbooks / Files
- Importing Data from Database/ Text Files/ Web
- Exporting Data
- Changing External Data Range