Advance Excel Training In Nepal
Advance Excel Training (Basic & Advance Excel)
: Data Analyst : 20 Days
Microsoft Excel is one of the most powerful tools for data analysis. This course is designed for managers, accountants, data analysts, operators, students and other professionals. Soft-Tech C.I Pvt. Ltd. is a best place for those who are seeking for advance excel training institution in Nepal. Our highly qualified teachers/data analysts experts provide quality education/training in professional way.
For course detail click on below tabs:
- Introduction
- About basic terminology – Preface
- Differentiation between Number and Text
- Keyboard shortcuts – Basic & advanced
- Formulas, uses of operation & order of operation
- Built in function like sum, average & ways of applying efficient formulas
- Other function like count, median, sumif, countif
- Cell reference – Relative & absolute cell reference
- Assumption tables
- Basics of style, number formatting & round function
- Basics of Charts
- Page setup
- Data formatting required for Data analysis
- Assumption tables – Worksheet reference & Workbook references
- Vlookup, Hlookup, Xloopup function – With examples
- index and match function with example
- 3D references
- Detailed sumif – Within worksheet & other worksheet reference
- Cell contents, comparative operations, AND, OR, IS, IF functions followed with further detailed examples
- Dates and Text function – Detailed review along with concatenate function
- Data – Importance of a proper format & types of Bad formats
- Excel Table – Basics, Nomenclature, Formatting, Styling, Designing
- Sorting – Basics, Multiple sorting, Color sorting, Directional sorting
- Filter – Basics, different types – Date, Text, Color, Custom, Copying filter Data
- Subtotal – Basics, Types, Single & Multiple Subtotaling
- Advanced filter – Basics, Detailed Explanation covering single criteria, Criteria – And/or, within worksheet & different workbook, Extraction of unique records, Data extraction using True/False functionalities
- Pivot Table – With multiple Illustrative Examples
- Conditional Formatting – Few Examples
- Scenario Analysis, Data Tables at different levels & examples & Goal Seek Function
- Importing Data from various external sources
- Order of Precedents, Average Function & Revision – Nature of Text & Number
- Errors : Types & Reason & Fixing Other Spreadsheet
- Custom Number & Data Formatting (CNF, CTF) with Illustrative Examples
- Detailed understanding about Round Function & Paste Special utility along with Freeze Panes
- Goalseek function
| Upcoming Class | |
| 1 Jan 2023 11:00 AM-12:30 PM |
15 Jan 2023 10:00 AM-11:30 AM |