MS Excel For Beginners
Learn Ms Excel, Ms Excel features, functions, fundamentals, making and maintaining employee record, data analysis, formatting, use of formulas, data filtering, charts, graphs and much more.
This course is specially deliberate for trainees and it explains the MS Excel position and its application in business particularly in the HR department. It also defines the several procedures of data creation, examination, structuring and integration methods to give an enhanced look at your work.
Additionally, it permits you with the operational use of the most influential tools and impactful ways of summarizing your data into a comprehensive form for presentation. Enroll yourself in this course and start using MS Excel with the maximum competent ways that bring efficiency to your work.
- Overview
- Getting Started
- Opening Excel
- Familiarity With Excel Interface And Ribbons
- Surfing An Excel Worksheet And How To Use Help In Ms Excel
- Case Study
- Data Entry
- Populating The Case Study In Excel
- Populating The Case Study In Excel
- Calculations
- Formulas
- Formulas - Part 1
- Formulas - Part 2
- Formatting
- Formatting Number Formats
- Formatting Table Formats
- Updating A Calculation
- Percentages & Absolute References
- Percentages & Absolute References
- Conditional Formatting
- If Function
- Countif
- Sumif
- Graphs & Charts
- Graphs And Charts Part 1
- Graphs And Charts Part 2
- Graphs And Charts Part 3
- Pie Chart
- Sorts
- Filter Function
- Pivot Table
- Pivot Table Part 1
- Pivot Table Part 2
- Freeze & Split
- Presentation
- Table Formats
- Indents And Formatting Charts
- Print
- Printing The Worksheet
- Print Layout
- Shortcuts
- Shortcuts Part 1
- Shortcuts Part 2
- Shortcuts Part 3
- Shortcuts Part 4
- Shortcuts Part 5
- Shortcuts Part 6
- Common Errors
Rating 4.5 (50 Reviews)
-
Media heading
incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam,
quis nostrud
-
Media heading
incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam,
quis nostrud
-
Media heading
incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam,
quis nostrud
-
Media heading
incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam,
quis nostrud