Contents
· Module 1: Introduction
· Module 2 : Entering, Editing and Formatting Data
· Module 3: Formatting Numbers
· Module 4: Managing Worksheets
· Module 5: Modifying Rows and Columns
· Module 6: Understanding Formulas
· Module 7: Changing Views
· Module 8: AutoFill and Custom Lists
· Module 9 : Conditional Formatting
· Module 10: Tables
· Module 11: Data Tools
· Module 12: Referencing Formulas
· Module 13: Ranges and Dates
· Module 14: Lookups
· Module 15: Conditional Logic
· Module 16 : Text Formulas
· Module 17: Introduction to Charts
· Module 18: Formatting Charts
· Module 19: Adding Graphics to Spreadsheets
· Module 20: Outline, Sort, Filter, and Subtotal
· Module 21: PivotTables
· Module 22 : Protecting Data
· Module 23: Collaboration
· Module 24: Printing
· Module 25: Saving a Workbook
· Module 26: Macros
Introduction
- Introduction
- Interface
- Tabs and Ribbons
- Document Windows
- Navigation Tips
- Office Button and Save
Entering, Editing and Formatting Data
- Introduction
- Entering Data
- Fonts, Fills, and Alignment
- Cut, Copy, and Paste
- Paste Special
- Undo and Redo
- Moving, Finding, and Replacing a Value
- Cell Styles
- Comments
Formatting Numbers
- Introduction
- Currency Format
- Format Painter
- Formatting Dates
- Custom and Special Formats
Managing Worksheets
- Introduction
- Naming and Moving Worksheets
- Copying Worksheets
- Adding, Deleting and Hiding Worksheets
- Grouping Worksheets
- Moving, Copying, Deleting and Hiding Grouped Worksheets
Modifying Rows and Columns
- Introduction
- Inserting and Deleting Columns and Rows
- Inserting & Deleting Cells
- Inserting Multiple Columns & Rows
- Modifying Cell Width and Height
- Hiding and Unhiding Rows and Columns
Understanding Formulas
- Introduction
- Using Operations
- Creating Formulas
- AutoSum
- Common Formulas
- Searching for Formulas
- Copying Formulas
- Using Relative and Absolute References
Changing Views
- Introduction
- Workbook Views
- Show/Hide
- Zoom Features
- Freeze Panes
- Split Windows
- Viewing Multiple Windows
- Minimize The Ribbon
- Worksheet Backgrounds
- Watermarks
AutoFill and Custom Lists
- Introduction
- AutoFill a Series
- AutoFill Non-Adjacent Cells
- AutoFill on Multiple Sheets
- Creating Custom Lists
- Series Formatting
Conditional Formatting
- Introduction
- Highlight Cells Rules
- Top/Bottom Rules
- Data Bars
- Color Scales
- Custom Formatting Rule
Tables
- Introduction
- Insert a Table and Style Options
- Add Rows and Columns
- Perform a Function in a Table
- Summarise With Pivot Table
Data Tools Data Tools
- Introduction
- Data Validation
- Drop-Down Lists
- Removing Duplicates
- Text To Columns
- Goal Seek
- Scenario Manager
Referencing Formulas
- Introduction
- Multiple Sheet References
- Consolidating Data - With or Without Links
- Trace the Precedents and Dependents
- Using the Watch Window
Ranges and Dates
- Introduction
- Cell Names
- Named Ranges
- Formulas with Cell Names
- Date Formulas
Lookups
- Introduction
- VLOOKUP
- VLOOKUP Exact Match
- HLOOKUP
- HLOOKUP Exact Match
Conditional Logic
- Introduction
- IF Statement
- Nested IF
- AND
- OR
- NOT
- IFERROR
- SUMIF
- AVERAGEIF
- COUNTIF & COUNTIFS
- SUMIFS
- AVERAGEIF
Text Formulas
- Introduction
- Case Formulas
- Fix Number Fields
- Trim Spaces
- Substitute Text
Introduction to Charts
- Introduction
- Chart Types
- Instant Chart
- Update Chart
- Column Chart
- Picture Fill
- Adjust Chart Size
- Line Chart
- Scatter Chart
Formatting Charts
- Introduction
- Chart Styles
- Chart Layouts
- Add Labels
- Axis Options
- Chart Title
- Legends
- Data Labels
Adding Graphics to Spreadsheets
- Introduction
- Insert Pictures
- Modifying Pictures
- Insert Shapes
- Insert SmartArt
- Apply Themes
- Arrange
Outline, Sort, Filter, and Subtotal
- Introduction
- Group and Ungroup
- Sort Data
- Sort Multiple Levels
- Filter Data
- Advanced Filter
- Conditional Sorting and Filtering
- Sorting with Custom Lists
- Subtotal
PivotTables
- Introduction
- Creating PivotTables
- Choosing Fields
- PivotTable Layout
- Filtering PivotTables
- Modifying PivotTable Data
- PivotCharts
Protecting Data
- Introduction
- Workbook Passwords
- Protecting Workbooks
- Unlocking Cells
Collaboration
- Introduction
- Document Properties
- Inserting Hyperlinks
- Sharing a Workbook
- Track Changes
- Accept/Reject Changes
- Mark as Final
Printing
- Introduction
- Page Orientation
- Page Breaks
- Print Area
- Margins
- Print Titles
- Headers and Footers
- Scaling
- Sheet Options
Saving a Workbook
- Introduction
- Save As Previous Version
- AutoRecover Save Options
- Templates
- Save As PDF
- Save As Web Page
- Macro-Enabled Workbook
Macros
- Introduction and Macro Security
- Recording a Macro
- Assign a Macro to a Button or Shape
- Run a Macro upon Opening a Workbook
- How to Inspect and Modify a Macro
Our Institute Provides Students are taught Professionally Advance Microsoft Excel Course Education in Every Cities of Delhi .Contact for More Details.- Sagarpur West | Sagarpur East | Desu Colony | Raghu Nagar | Madanpuri | Mohan Nagar | Vashist Park | Durga Park | Jagdamba Vihar | Dabri | Nangal Raya | Sitapuri | Indra Park | Vijay Enclave | Mahavir Enclave | Nasirpur | Madhu Vihar | Dwarka More | Dwarka Sector 3 | Dwarka Sector 4 | Dwarka Sector 12 | Dwarka Sector 13 | Lajwanti Garden | Pankha Road | Manglapuri | Hari Nagar | Palam | Raj Nagar | Sadh Nagar | Kailash Puri | Bindapur | Dashrath Puri | Delhi Cantt | Mayapuri | Jeewan Park | Janakpuri A Block | Janakpuri D Block | Janakpuri District Center | Tilak Nagar | Janakpuri C1 Block | Chanakya Place | Uttam Nagar | Mohan Garden | Nawada | Om Vihar | Mansa Ram Park | Rama Park | Dwarka etc.
Upon completion of our Excel and Advanced Excel Training in Noida, you'll emerge with a solid understanding of Excel's advanced features and techniques, empowering you to streamline workflows, analyze complex datasets, and make data-driven decisions with confidence. Whether you're pursuing career advancement, seeking to boost productivity in your current role, or exploring new opportunities in the data-driven world, APTRON Solutions is your trusted partner in Excel mastery.
ReplyDeleteAt APTRON Solutions, our Excel and Advanced Excel Course in Noida stands out for its hands-on approach and expert-led training. Whether you're looking to enhance your spreadsheet skills, master advanced formulas, or automate tasks using macros, our industry-experienced trainers provide practical insights and real-world applications.
ReplyDelete