Description
Curriculum
Instructor
Curriculum
- 9 Sections
- 82 Lessons
- 12 Weeks
Expand all sectionsCollapse all sections
- Advanced Excel38
- 1.1Quick review on MS Excel Options, Ribbon, Sheets
- 1.2Saving Excel File as PDF, CSV and Older versions
- 1.3Using Excel Shortcuts with Full List of Shortcut
- 1.4Copy, Cut, Paste, Hide, Unhide, and Link the Data in Rows, Columns and Sheet
- 1.5Using Paste Special Options
- 1.6Formatting Cells, Rows, Columns and Sheet
- 1.7Advanced Filtering in Excel
- 1.8Grouping & Subtotal in Excel
- 1.9Protecting & Unprotecting Cells, Rows, Columns and Sheets with or without Password
- 1.10Page Layout and Printer Properties
- 1.11Working with Formulas / function
- 1.12Logical Function: IF / ELSE, AND, OR, NOT, TRUE, NESTED IF/ELSE etc
- 1.13Database Functions
- 1.14Date & Time Functions: DATE, DATEVALUE, DAY, DAY360, SECOND, MINUTES, HOURS, NOW, TODAY, MONTH, YEAR, YEARFRAC, TIME, WEEKDAY, WORKDAY
- 1.15Information Functions
- 1.16Math & Trigonometry Functions: RAND, ROUND, CEILING, FLOOR, INT, LCM, EVEN, SUMIF
- 1.17Statistical Functions: AVEDEV, AVERAGE, AVERAGEA, AVERAGEIF, COUNT, COUNTA, COUNTBLANK,COUNTIF, MAX, MAXA,MIN, MINA, STDEVA
- 1.18Text Functions: LEFT, RIGHT, TEXT, TRIM, MID, LOWER, UPPER, PROPER, REPLACE, REPT, FIND, SEARCH, SUBSTITUTE, TRIM, TRUNC, CONVERT, CONCATENATE
- 1.19Conditional Formatting
- 1.20Using Conditional Formatting
- 1.21Using Conditional Formatting with Multiple Cell Rules
- 1.22Using Color Scales and Icon Sets in Conditional Formatting
- 1.23Creating New Rules and Managing Existing Rules
- 1.24Data Lock & Protection
- 1.25Advance Charts in Excel
- 1.26Area Charts and Surface Charts
- 1.27Trend line Charts and Candle Stick
- 1.28Charts and Pie Charts
- 1.29XY (Scatter Charts)
- 1.30Time Series Charts and Bubble Charts
- 1.31Radar Charts and Doughnut Charts
- 1.32Rotating 3D Excel Charts
- 1.33Working with Fill Series & Go to Special
- 1.34Consolidation in Excel
- 1.35What if Analysis in Excel
- 1.36Goal Seek
- 1.37Scenario Manager
- 1.38Data Table
- AI Automation with Excel4
- Regression Analysis in Excel5
- 3.1To Measure the Effectiveness of the Marketing Campaigns, Pricing, And Promotions On Sales Of A Product
- 3.2Used To Analyse Categorical Data
- 3.3Commonly Used In Understanding Customer Behaviour
- 3.4To Understand the Relationship between a Company’s Stock Price & The Company’s Quarterly Earnings
- 3.5Credit Risk Assessment
- Creating Automation Tools With Excel Scripts6
- Working With Forecasting5
- Solving Complex Data Using The Power Query In Excel0
- Professional Dashboards In Excel5
- Tally Accounting (Module 1)9
- 8.1Fundamental of Accounts Rules of Accounts
- 8.2Creating/Altering/Deleting Company in Tally Prime
- 8.3Group & Ledger Creation in Tally Prime
- 8.4Journal Entries in in Tally Prime
- 8.5Day Book & Cash/Bank Book
- 8.6Trading & P&L Account
- 8.7Trial Balance, Balance Sheet & Reports
- 8.8Managing Accounts of Sole Proprietorship
- 8.9Managing Accounts of Consultancy Firm
- Tally Accounting (Module 2)10
Yash Jain
0 Students47 Courses
You might be interested in
₹ 18,000.00₹ 15,000.00
-
All levels
₹ 18,000.00₹ 15,000.00
Graphic Design Courses in Surat | learn Adobe Photoshop | Learn Graphic design | Video Editing Course near me Illustrator...
₹ 23,000.00₹ 18,000.00
-
All levels
₹ 23,000.00₹ 18,000.00
Graphic Design Courses in Surat | learn Adobe Photoshop | Learn Graphic design | Video Editing Course near me Illustrator...
₹ 15,000.00₹ 11,000.00
-
All levels
₹ 15,000.00₹ 11,000.00
Graphic Design Courses in Surat | learn Adobe Photoshop | Learn Graphic design | Video Editing Course near me Illustrator...
₹ 15,000.00₹ 12,500.00
-
All levels
₹ 15,000.00₹ 12,500.00
Graphic Design Courses in Surat | learn Adobe Photoshop | Learn Graphic design | Video Editing Course near me Illustrator...
Sign up to receive our latest updates
Get in touch
Quick Links
- Contact Us
- About Us
- Privacy Policy
- Terms & Conditions
