It is a spreadsheet program developed by Microsoft. Excel organizes data in columns and rows and allows you to do mathematical functions graphically represent data(s), and performing different calculations. It runs on Windows, macOS, Android and iOS. The first version was released in 1985 and has gone through several changes over the years.
Course Objective
- Examine spreadsheet concepts and explore the Microsoft Office Excel environment.
- Create, open and view a workbook.
- Save and print workbooks.
- Enter and edit data.
- Modify a worksheet and workbook.
- Work with cell references.
- Learn to use functions and formulas.
- Create and edit charts and graphics.
WHY SHOULD GO FOR THIS COURSE ?
- Organize data in an easy-to-navigate way
- Do basic and complex mathematical functions so you don’t have to
- Turn piles of data into helpful graphics and charts
- Analyze data and make forecasting predictions
PRE- REQUISITES
Basic knowledge of computer :
- Fees :- 6000
- Duration :- 45DAYS
- Class Mode :- Online / Offline
- Level :- Basic To Advance
COURSE CURRICULUM
- An overview of the screen, navigation and basic spreadsheet concepts
- Various selection techniques
- Shortcut Keys
- Customizing the Ribbon
- Using and Customizing Auto Correct
- Changing Excel’s Default Options Using Basic Functions
- Using Functions – Sum, Average, Max, Min, Count
- Absolute, Mixed and Relative Referencing
• SumIf, SumIfs CountIf, CountIfs AverageIf, AverageIfs, Nested IF, IFERROR Statement, AND, OR, NOT
- File Level Protection
- Workbook, Worksheet Protection
- Upper, Lower, Proper
- Left, Mid, Right
- Trim, Len, Exact
- Concatenate
- Find, Substitute
- Today, Now
- Day, Month, Year
- Date, Date if, DateAdd
- EOMonth, Weekday
- Paste Formulas, Paste Formats
- Paste Validations
- Transpose Tables
- New Charts – Tree map & Waterfall
- Sunburst, Box and whisker Charts
- Combo Charts – Secondary Axis
- Adding Slicers Tool in Pivot & Tables
- Using Power Map and Power View
- Forecast Sheet
- Sparklines -Line, Column & Win/ Loss
- Using 3-D Map
- New Controls in Pivot Table – Field, Items and Sets
- Various Time Lines in Pivot Table
- Auto complete a data range and list
- Quick Analysis Tool Smart Lookup and manage Store
- Filtering on Text, Numbers & Colors
- Sorting Options
- Advanced Filters on 15-20 different criteria(s)
- Setting Up Print Area
- Customizing Headers & Footers
- Designing the structure of a template
- Print Titles –Repeat Rows / Columns
- Goal Seek
- Scenario Analysis
- Data Tables (PMT Function)
- Solver Tool
- If Function
- How to Fix Errors – if error
- Nested If
- Complex if and or functions
- Number, Date & Time Validation
- Text and List Validation
- Custom validations based on formula for a cell
- Dynamic Drop-down List Creation using Data Validation – Dependency List
- Vlookup / HLookup
- Index and Match
- Creating Smooth User Interface Using Lookup
- Nested VLookup
- Reverse Lookup using Choose Function
- Worksheet linking using Indirect
- Vlookup with Helper Column Pivot Tables
- Creating Simple
- Basic and Advanced Value Field Setting
- Classic Pivot table
- Choosing Field
- Filtering PivotTables
- Modifying PivotTable Data
- Grouping based on numbers and Dates
- Calculated Field & Calculated Items
- Arrays Functions
- What are the Array Formulas, Use of the Array Formulas?
- Basic Examples of Arrays (Using ctrl+shift+enter).
- Array with if, len and mid functions formulas.
- Array with Lookup functions. • Advanced Use of formulas with Array.
- Various Charts i.e. Bar Charts / Pie Charts / Line Charts
- Using SLICERS, Filter data with Slicers
- Manage Primary and Secondary Axis
- Planning a Dashboard
- Adding Tables and Charts to Dashboard
- Adding Dynamic Contents to Dashboard
- Using Outlook Namespace
- Send automated mail
- Outlook Configurations, MAPI
- Worksheet / Workbook Operations
- Merge Worksheets using Macro
- Merge multiple excel files into one sheet
- Data Analyst. Data Analyst. …
- Growth Analyst. Growth Analyst. …
- Excel Consultant. QS Quacquarelli Symonds. …
- Associate-RPA Tech Support. Associate-RPA Tech Support. …
- Reporting Analyst. Reporting Analyst. …
- Excel Developer. …
- Data Analyst (Growth) …
- Business Analyst (Banking Domain|SQL|Excel)
Why is BIIT best For short term Training ?
BIIT offers Short Term IT course in advanced excel 2013 which is extremely valuable for businesses. We not only work on theoretical knowledge but also tend to provide practical skills make them understand the concept using live project. BIIT is the best for short term training institute in East Delhi (Laxmi Nagar) As along with the best tutoring, we also offer job support and interview preparation.
Why Choose BIIT?
Book A Live Class to Know More
For any further queries and doubts, kindly fill in the details given below and hit send. You will get a callback within 24 hours.
ENQUIRE NOW OR CALL : +91-9318356685
