Interactive Training session through demonstrations and practical Assignments
About Us
I am glad that you have made it here to send a distress signal, and inform the Senate that all on board killed. Dantooine. I’m not going to Alderaan. I really got to go. But that to me.
ConsultationContact Info
- Chicago 12, Melborne City, USA
- (111) 111-111-1111
- [email protected]
- Week Days: 09.00 to 18.00 Sunday: Closed
Description
Requirements
Formatted a worksheet using colors and fonts before
VLOOKUP, IF, MAX, MIN, COUNTIF...
Worked with general formulas and used basic worksheet functions like
Have used basic of conditional formatting
Built a table before and performed drag and fill operations on formulas (little black dot bottom right hand-side of a cell)
Used logic before in general and know the relational operators , =, , =
Used basic Excel features like Sort, AutoFilter and have built Basic charts
Target Audience
- Executives and Management team who has Basic knowledge of Excel.
Course Content
Lesson 1: Advance Functions
-
Statistical Functions
-
Database Functions
-
Lookup and References Functions
-
Database Functions
-
Date Functions
-
Entering Data
-
Text Functions
-
Logical Functions
Lesson 2: Working with Lookup functions
Lesson 3: Sorting and Filtering Data and Subtotal
Lesson 4: What-If Analysis with Solver
Lesson 5: Formula Auditing
Lesson 6: Conditional Formatting
Lesson 7: Working with External Data
Lesson 8: Working with Pivot Reports/Charts/ Data Visualization
Lesson 9: Data Validation
Lesson 10: Text To Column/External Data
Lesson 11: Data Analysis Tool Pack
Lesson 12: Security and Protection
A course by
Student Ratings & Reviews
No Review Yet
