Welcome to Mobilarian Forum - Official Symbianize forum.

Join us now to get access to all our features. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, and so, so much more. It's also quick and totally free, so what are you waiting for?

Microsoft Excel-Learn Basic To Advanced 2023

Alexhost
OP
TOP 110

TOP

Alpha and Omega
Member
Access
Joined
Jan 21, 2021
Messages
217,469
Reaction score
17,121
Points
113
Age
37
Location
OneDDL
grants
₲171,531
3 years of service
b3cacbd03a6ee3d3ef2726b3794bf168.jpeg

Free Download Microsoft Excel-Learn Basic To Advanced 2023
Published 3/2023
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 9.12 GB | Duration: 21h 18m
Excel with this A-Z Microsoft Excel Course. Microsoft Excel 2010, 2013, 2016, Excel 2019 and Microsoft/Office 365

What you'll learn
Master unique tips & techniques that you won't find in ANY other course, guaranteed
Automate, streamline, and completely revolutionize your workflow with Excel
Get LIFETIME access to project files, quizzes, homework exercises, and 1-on-1 expert support
Explore fun, interactive, and highly eLearn how to THINK like Excel, and write powerful and dynamic Excel forffective demos from a best-selling Excel instructor
Build stunning, professional-quality dashboards in Excel (from scratch!)
Apply powerful techniques for transforming raw data into beautiful, interactive visuals
Learn the same tools used by professional business intelligence analysts and data scientists
Analyzing Data with Business Intelligence (Power Queries and Trendlines)
and more .........
Requirements
Microsoft Excel 2007-2021 or Office 365 (Note: some tips may not apply to all versions of Excel)
Description
This course covers 35 sections.Students can learn basic and advanced concepts of Excel in this course.Learn pivottables ,pivotcharts,power query,power pivot,power map,what-if-analysis tools,solver and others topics.Learn how to add charts in Microsoft Excel sheet.Learn how to use formulas and functions in Microsoft Excel .To see more topics of this course,view course contents below.Who this course is for: If someone want to learn excel from basic to Advance,this course covers basic and advance levels topics.Requirements : This course is recorded on excel 2019 but all previous versions 2007,2010,2013,2016 and office 365 will work on this course.If you're looking to master Microsoft Excel, then this comprehensive course is exactly what you need! Whether you're a beginner just starting out or an experienced user looking to enhance your skills, this course has everything you need to take your Excel knowledge to the next level.With this course, you'll start with the basics of Excel and quickly progress through more advanced topics, such as data analysis, charts, graphs, pivot tables, macros, and more. You'll learn how to create professional-looking spreadsheets, automate repetitive tasks, and streamline your workflow. Plus, you'll learn tips and tricks that will save you time and make your work more efficient.One of the biggest advantages of this course is its accessibility. You can learn at your own pace and on your own schedule. With video tutorials, downloadable practice files, and hands-on exercises, you'll be able to practice what you learn and test your skills every step of the way.The instructor of this course is an expert in Excel with years of experience. He has designed this course to be easy to follow and understand, even for those who have never used Excel before. The lessons are broken down into bite-sized chunks, so you can learn one topic at a time and build upon your knowledge as you go.By the end of this course, you'll be able to confidently use Excel for a wide range of tasks. You'll have the skills you need to create complex spreadsheets, analyze data, and present your findings in a clear and concise manner. Whether you're looking to improve your job performance, advance your career, or simply become more proficient with Excel, this course is the perfect choice.Don't wait any longer to start mastering Microsoft Excel. Enroll in this course today and take the first step towards becoming an Excel expert!
Overview
Section 1: Introduction
Lecture 1 Introduction
Lecture 2 Excel Tabs,Groups and Commands
Lecture 3 Excel Rows and Columns
Lecture 4 Changing the Size of Columns and Rows
Lecture 5 Entering Text and Numbers in Worksheet
Lecture 6 Wrap Text Inside the Cell
Lecture 7 Edit Text Within a Cell
Lecture 8 Merging and Formatting Cells in a Worksheet
Lecture 9 Formatting Header in a Worksheet
Lecture 10 Adding Image in a Worksheet
Lecture 11 Formatting Date in Excel Worksheet
Lecture 12 Working of Undo & Redo Commands in an Excel Worksheet
Lecture 13 Home Work
Section 2: Creating Excel Tables,PivotTables and PivotCharts
Lecture 14 Freezing Header or Row
Lecture 15 Converting Data in an Excel Table
Lecture 16 Adding Records in an Excel Table
Lecture 17 Renaming and Finding Records in an Excel Table
Lecture 18 Editing and Deleting Records in an Excel Table
Lecture 19 Remove Duplicates
Lecture 20 Sorting Date Column in an Excel Table
Lecture 21 Sorting Multiple Columns
Lecture 22 Filtering Data in an Excel Worksheet and Deleting an Excel Table
Lecture 23 Filtering Data by Creating Criteria
Lecture 24 Filtering Data in an Excel Table by Using Slicer
Lecture 25 Splitting the Worksheet into Panes
Lecture 26 Calculating Records in an Excel Table
Lecture 27 Inserting Subtotals
Lecture 28 Creating and Adding Data in a Pivot Table
Lecture 29 Filtering Data in a Pivot Table
Lecture 30 Adding Pivot Chart in a Pivot Table
Lecture 31 Home Work
Section 3: Analyzing Sales Data in Pivot Tables and Pivot Charts
Lecture 32 Adding Data in Excel Table
Lecture 33 Adding and Formatting First Chart in Pivot Table
Lecture 34 Adding and Formatting Second Chart in Pivot Table
Lecture 35 Adding and Formatting Third Chart in Pivot Table
Lecture 36 Adding and Formatting Fourth Chart in Pivot Table
Lecture 37 Adding and Formatting Fifth Chart in Pivot Table
Lecture 38 Adding and Formatting Sixth Chart in Pivot Table
Lecture 39 Adding Chart in Excel Dashboard
Lecture 40 Designing Dashboard Layout and Extracting Pivot Tables Data in Text Box
Lecture 41 Inserting Slicers in the Dashboard for Analyzing Sales Data
Section 4: Data Validation and Inserting Comments
Lecture 42 Specifying a Validation Rule by Using List
Lecture 43 Displaying Error Alert Message
Lecture 44 Show an Input Message on an Active Cell
Lecture 45 Circle Invalid Data
Lecture 46 Inserting Comments in a Worksheet
Lecture 47 Home Work
Section 5: Analyzing Data in the Table
Lecture 48 Introducing and Converting a Range to a Table
Lecture 49 Sorting a Table using Different Methods
Lecture 50 Filtering a Table using Different Methods
Lecture 51 Analyzing Basic Table Operations
Lecture 52 Analyzing Table Data using COUNTIF,SUMIF and AVERAGEIF Functions
Section 6: Analyzing Data with PivotTables
Lecture 53 Introducing PivotTables
Lecture 54 Creating PivotTable
Lecture 55 Inserting Subtotals In the PivotTable
Lecture 56 Summarizes Value Field by Changing Functions
Lecture 57 Adding PivotChart and Slicer in the PivotTable
Section 7: Analyzing Data with Business Intelligence (Power Queries and Trendlines)
Lecture 58 Introducing Power Query and Upload CSV File
Lecture 59 Retrieving Power Query Data into an Excel Table and Editing a Query Data
Lecture 60 Adding a New Column and Grouping Values in a Power Query Data
Lecture 61 Analyzing Revenue Data by Adding Trendlines in the Chart
Section 8: Analyzing Data with Business Intelligence (Forecast Sheet)
Lecture 62 Analyzing Revenue Data by Creating a Forecast Sheet
Section 9: Analyzing Data with Business Intelligence (Power Pivot,Data Model & Power Map)
Lecture 63 Introducing Database and Upload Access Database File
Lecture 64 Creating the Data Model
Lecture 65 Transferring Data in the Power Pivot
Lecture 66 Exploring the Data Model in the Diagram View
Lecture 67 Managing Table Relationships in the Power Pivot
Lecture 68 Creating a PivotTable from the Data Model
Lecture 69 Adding a Timeline Slicer in the PivotTable
Lecture 70 Drilling down into the Data in the PivotTable
Lecture 71 Visualizing Stores Sale Data with Power Map
Section 10: Extracting Data from the Website(Power Query,Power Pivot,Pivot Table)
Lecture 72 Importing Population and Area Data from the Website and Creating Queries
Lecture 73 Extracting Population and Area Data into PivotTable
Lecture 74 Merging Two Queries into One query
Section 11: Loading Website Data into Power Map(Power Query,Power Map)
Lecture 75 Loading Website Data into Power Map
Section 12: Extracting Data from the Website(Power Query,Pivot Table)
Lecture 76 Extracting and Transforming User Rating Data from the Website
Lecture 77 Combining Queries
Section 13: Extracting Football Team Data from the Website(Power Query,Pivot Table)
Lecture 78 1. Extracting and Transforming Data from the Website
Section 14: Analyzing Business Data by using What-If Analysis Tools(Goal Seek,Data Table)
Lecture 79 Cost-Volume-Profit(CVP) Chart Analysis
Lecture 80 Find the Break-Even Point by Using Goal Seek
Lecture 81 Generate $30000 Net Income of Company by using Goal Seek Tool
Lecture 82 Creating One-Variable Data Table to Examine the Impact of Changing Sales Volume
Lecture 83 Completing the One-Variable Data Table
Lecture 84 Creating the CVP Chart of the Data Table
Lecture 85 Viewing the Impact of Changing the Sales Price in the Data Table
Lecture 86 Creating the Two-Variable Data Table
Lecture 87 Create a Chart of the Two Variable Data Table
Section 15: Analyzing Business Data by using What-If Analysis Tools(Scenario Manager)
Lecture 88 Define Names for the Income Statement Values
Lecture 89 Adding the Scenarios in the Scenario Manager
Lecture 90 View the Impact of the Reduced Operations Scenario
Lecture 91 Creating the Scenario Summary Report
Lecture 92 Creating the Scenario PivotTable Report
Section 16: Analyzing Business Data with Solver
Lecture 93 Understand Solver with Simple Example
Lecture 94 Introducing Product Mix and Find an Optimal Solution with Solver Part 1
Lecture 95 Introducing Product Mix and Find an Optimal Solution with Solver Part 2
Lecture 96 Creating a Solver Answer Report
Lecture 97 Saving and Loading Solver Model
Section 17: Calculations With Basic Formulas
Lecture 98 Introduction to Arithmetic Operators
Lecture 99 Calculations with Arithmetic Operators
Lecture 100 Copy and Paste the Formula
Lecture 101 Auto Complete Formula
Lecture 102 Inserting and Deleting Columns and Rows
Lecture 103 Hide and Unhide Columns and Rows
Lecture 104 Moving a Cell or Range by Drag and Drop Method
Lecture 105 Moving a Cell or Range by Cut and Paste Method
Lecture 106 Relative and Absolute Cell References
Lecture 107 Home Work
Section 18: Calculations with Simple Excel Functions
Lecture 108 Introduction to Function Syntax
Lecture 109 Calculating Total Sales by Using SUM Function
Lecture 110 Calculating Total Sales Quantities by Using SUM Function
Lecture 111 Count Price Items by Using COUNT Function
Lecture 112 Count Food Items by Using COUNTA Function
Lecture 113 Calculating Average Sales by Using AVERAGE Function
Lecture 114 Calculating Maximum Sales Value of Customer by Using MAX Function
Lecture 115 Calculating Minimum Sales Value of Customer by Using MIN Function
Lecture 116 Calculating Total Price of Products by Using PRODUCT Function
Lecture 117 Calculating Sales Data by Using Auto FUNCTION Button
Lecture 118 Calculating a Tax Rate on Total Sales
Lecture 119 Home Work
Section 19: Formatting a Worksheet
Lecture 120 Merging Two or More Cells into One Cell
Lecture 121 Alignment of Cell Text
Lecture 122 Splitting Text into Multiple Lines
Lecture 123 Rotating a Cell Text or Numbers
Lecture 124 Formatting Background Color of Text and Numbers
Lecture 125 Formatting Font Size and Font Color
Lecture 126 Adding Border into Cells
Lecture 127 Formatting Cell Styles
Lecture 128 Find and Replace Text in a Worksheet
Lecture 129 Calculating Students Enrollment and Difference Between two Columns Values
Lecture 130 Calculating Percentage Difference Between two Columns Values
Lecture 131 Conditionally Formatting Cells in a Worksheet
Lecture 132 Conditionally Formatting Cells with a Top and Bottom Rules
Lecture 133 Home Work
Section 20: Saving and Printing a Workbook
Lecture 134 Saving a Workbook
Lecture 135 Worksheet Views,Page Orientation and Scaling
Lecture 136 Setting Margins in a Print Page
Lecture 137 Adding Header and Footer in a Print Page
Lecture 138 Print Preview and Selecting Print Area
Lecture 139 Setting Scaling and Margins in a Print Page(Document 1)
Section 21: Project Calculations with Operators and Functions
Lecture 140 Calculating the Area of Field and Plots
Lecture 141 Calculating the Grown and Empty Area of Vegetables Field
Lecture 142 Calculating the Percentage of Grown and Empty area in Vegetables Field
Lecture 143 Calculating Cost of Sales and Weightages of Vegetables
Lecture 144 Calculating Profit and Percentage of Profit from Vegetables
Lecture 145 Calculating Revenue by Using Sum,Max,Min,Average and Median Functions
Lecture 146 Introduction to NESTED Function
Lecture 147 Nesting the SUM and MEDIAN Functions within ROUND Function
Lecture 148 Home Work
Section 22: IF and VLOOKUP Functions
Lecture 149 Introduction to IF Function and Apply Weather Condition on IF Function
Lecture 150 Apply Different Conditions on IF Function
Lecture 151 Introduction to VLOOKUP Function
Lecture 152 Apply VLOOKUP Function on Data Table
Lecture 153 Retrieving Values from Data Table by Using VLOOKUP Function
Lecture 154 Errors in VLOOKUP Function
Lecture 155 Home Work
Section 23: Adding Column and Pie Charts in an Excel worksheet
Lecture 156 Embed Column Chart in a Worksheet
Lecture 157 Analyzing Data with a Column Chart
Lecture 158 Analyzing Data with a Pie Chart
Lecture 159 Recommended Charts
Lecture 160 Home Work
Section 24: Date and Time Functions in an Excel
Lecture 161 NOW and TIME Functions
Lecture 162 HOUR,MINUTE and SECOND Functions
Lecture 163 TODAY,DATE and DAYS Functions
Lecture 164 YEAR,MONTH and DAY Functions
Lecture 165 WEEKDAY Function
Lecture 166 WEEKNUM Function
Lecture 167 EDATE Function
Lecture 168 EOMONTH Function
Lecture 169 Determining Person's Birthday
Lecture 170 Calculating Age of Person
Lecture 171 Formatting Date in a Cell
Lecture 172 DATEVALUE Function
Lecture 173 DAYS360 Function
Lecture 174 ISOWEEKNUM Function
Lecture 175 NETWORKDAYS Function
Lecture 176 TIMEVALUE Function
Lecture 177 YEARFRAC Function
Section 25: Logical Functions in an Excel
Lecture 178 Calculating the Age of Employees and Length of Service
Lecture 179 Analyzing Data by Using IF Function
Lecture 180 Determining Birthday of Employees
Lecture 181 Specifying Day of Birthdate by Nesting DAY Function Within IF Function
Lecture 182 Determining Employee Eligibility for Promotion by Using AND Function
Lecture 183 Nesting the AND Function Within IF Function
Lecture 184 Determining Employee Eligibility for Promotion by Using OR Function
Lecture 185 Nesting the OR Function Within IF Function
Lecture 186 IFERROR Function
Lecture 187 IFNA Function
Lecture 188 FALSE Function
Lecture 189 IFS Function
Lecture 190 NOT Function
Lecture 191 SWITCH Function
Lecture 192 TRUE Function
Lecture 193 XOR Function
Lecture 194 Home Work
Section 26: Lookup and Reference Functions in an Excel
Lecture 195 Extracting Value from Data Table by Using VLOOKUP Function
Lecture 196 Extracting Value from Data Table by Using HLOOKUP Function
Lecture 197 Calculating Discount and Total Price
Lecture 198 Calculating Tax Rate on Total Price Value
Lecture 199 Extracting Value by Using CHOOSE Function
Lecture 200 Nesting the CHOOSE Function Within Sum Function
Lecture 201 MATCH Function
Lecture 202 Extracting Value by Using INDEX Function
Lecture 203 Nesting the MATCH Function Within an INDEX Function
Lecture 204 Nesting the VLOOKUP Function Within an IFERROR Function
Lecture 205 COLUMN Function
Lecture 206 LOOKUP Function
Lecture 207 TRANSPOSE Function
Lecture 208 Home Work
Section 27: Adding Line and Combination Charts in an Excel
Lecture 209 Adding and Formatting Line Chart
Lecture 210 Adding and Formatting Combination Chart
Section 28: Text Functions in an Excel
Lecture 211 BHATTEXT Function
Lecture 212 CHAR Function
Lecture 213 CLEAN Function
Lecture 214 CODE Function
Lecture 215 CONCAT Function
Lecture 216 DOLLAR Function
Lecture 217 EXACT Function
Lecture 218 FIND Function
Lecture 219 FIXED Function
Lecture 220 LEFT Function
Lecture 221 LEN Function
Lecture 222 LOWER Function
Lecture 223 MID Function
Lecture 224 NUMBERVALUE Function
Lecture 225 PROPER Function
Lecture 226 REPLACE Function
Lecture 227 REPT Function
Lecture 228 RIGHT Function
Lecture 229 SEARCH Function
Lecture 230 SUBSTITUTE Function
Lecture 231 T Function
Lecture 232 TEXT Function
Lecture 233 TEXTJOIN Function
Lecture 234 TRIM Function
Lecture 235 UNICHAR Function
Lecture 236 UNICODE Function
Lecture 237 UPPER Function
Lecture 238 VALUE Function
Section 29: Math and Trigonometry Functions in an Excel
Lecture 239 SUM Function
Lecture 240 MOD Function
Lecture 241 POWER Function
Lecture 242 SUBTOTAL Function
Lecture 243 SUMIF Function
Lecture 244 SUMIFS Function
Lecture 245 SUMPRODUCT Function
Lecture 246 ROUND Function
Lecture 247 ROUNDDOWN Function
Lecture 248 ROUNDUP Function
Lecture 249 CEILING.MATH Function
Lecture 250 FLOOR.MATH Function
Lecture 251 EVEN Function
Lecture 252 ODD Function
Lecture 253 INT Function
Lecture 254 TRUNC Function
Section 30: Statistical Functions in an Excel
Lecture 255 AVERAGE Function
Lecture 256 AVERAGEIF Function
Lecture 257 AVERAGEIFS Function
Lecture 258 COUNT and COUNTA Function
Lecture 259 COUNTBLANK Function
Lecture 260 COUNTIF Function
Lecture 261 COUNTIFS Function
Lecture 262 LARGE Function
Lecture 263 SMALL Function
Lecture 264 MAX and MIN Function
Lecture 265 MEDIAN Function
Lecture 266 MODE.MULT Function
Lecture 267 MODE.SNGL Function
Section 31: Engineering Functions in an Excel
Lecture 268 BIN2DEC Function
Lecture 269 BIN2HEX Function
Lecture 270 BIN2OCT Function
Lecture 271 COMPLEX Function
Lecture 272 CONVERT Function
Lecture 273 DEC2BIN Function
Lecture 274 DEC2HEX Function
Lecture 275 DEC2OCT Function
Section 32: Information Functions in an Excel
Lecture 276 CELL Function
Lecture 277 ERROR.TYPE Function
Lecture 278 INFO Function
Lecture 279 ISBLANK Function
Lecture 280 ISERR Function
Lecture 281 ISERROR Function
Lecture 282 ISEVEN Function
Lecture 283 ISFORMULA Function
Lecture 284 ISLOGICAL Function
Lecture 285 ISNA Function
Lecture 286 ISNONTEXT Function
Lecture 287 ISNUMBER Function
Lecture 288 ISODD Function
Lecture 289 ISREF Function
Lecture 290 ISTEXT Function
Lecture 291 N Function
Lecture 292 NA Function
Lecture 293 SHEET Function
Lecture 294 SHEETS Function
Lecture 295 TYPE Function
Section 33: Database Functions in an Excel
Lecture 296 DAVERAGE Function
Lecture 297 DSUM Function
Lecture 298 DMAX and DMIN Functions
Lecture 299 DCOUNTA Function
Section 34: Financial FunctionsBorrow Money to Bank
Lecture 300 Calculating a Quarterly Payment of Loan by using the PMT Function
Lecture 301 Calculating a Future Value of Loan by using the FV Function
Lecture 302 Calculating a Payment Period of Loan by using the NPER Function
Lecture 303 Calculating a Present Value of Loan by using the PV Function
Lecture 304 Calculating an Interest Rate of Loan by using the RATE Function
Lecture 305 Positive Cash Flow and Negative Cash Flow
Lecture 306 Calculating the Value of Inflation by Using FV Functio
Lecture 307 Calculating a Monthly Car Payment
Lecture 308 Calculating the Interest Payment by using IPMT Function
Lecture 309 Calculating the Principal Payment by using PPMT Function
Lecture 310 Calculating Remaining Principal Amount and Total Payment
Lecture 311 Completing the Amortization Schedule of Loan
Lecture 312 Plotting Interest and Principal Payments
Lecture 313 Calculating Cumulative Interest Payments by Using CUMIPMT Function
Lecture 314 Calculating Cumulative Principal Payments by Using CUMPRINC Function
Lecture 315 Calculating Remaining Principal,Total Interest and Total Principal Payments
Lecture 316 Calculating Total Loan Amount
Section 35: Financial FunctionsInvest Money in the Bank Saving Account
Lecture 317 Calculating the Compound Interest
Lecture 318 Calculating Nominal and Effective Interest Rates Using NOMINAL&EFFECT Functions
Lecture 319 Calculating the Future Value of an Investment by Monthly and Initial Deposits
Lecture 320 Calculating the Interest Rate of an Investment
Lecture 321 Calculating the Total Number of Deposits of an Investment
Lecture 322 Calculating the Initial Deposit or Present Value of an investment
Lecture 323 Calculating the Value of Deposit Per Month
Lecture 324 Calculating the Variable Interest Rates by using FVSCHEDULE Function
Lecture 325 Amortization Schedule of an Investment 1
Lecture 326 Amortization Schedule of an Investment 2
Section 36: Financial FunctiomsBuild Future Income Statement of Company
Lecture 327 Introduction to Income Statement Worksheet
Lecture 328 Linear and Growth Trend Values
Lecture 329 Projecting Future Value of Sales or Revenue by using Linear Trend Option
Lecture 330 Projecting Future Value of Sales or Revenue by Inserting a Growth Trend
Lecture 331 Calculating the Cost of Research and Development
Lecture 332 Calculating the Cost of Sales and Marketing
Lecture 333 Calculating the Gross Profit
Lecture 334 Calculating the Expenses of Company Part 1
Lecture 335 Calculating the Expenses of Company Part 2
Lecture 336 Calculating the Expenses of Company Part 3
Lecture 337 Calculating the Total General Expenses and Initial Earnings
Lecture 338 Adding Depreciation of an Asset in the Income Statement
Lecture 339 Calculating Operating Profit in the Income Statement
Lecture 340 Adding Interest Expenses in the Income Statement
Lecture 341 Calculating Profit Without Adding Tax
Lecture 342 Adding Taxes in the Income Statement
Lecture 343 Calculating Final Profit of the Company in the Income Statement
Section 37: Financial FunctionsCalculate Depreciation of an Asset of Company
Lecture 344 Straight Line Depreciation of an Asset Part 1
Lecture 345 Straight Line Depreciation of an Asset Part 2
Lecture 346 Straight Line Depreciation of an Asset Part 3
Lecture 347 Declining Balance Depreciation of an Asset Part 1
Lecture 348 Declining Balance Depreciation of an Asset Part 2
Lecture 349 Calculating Depreciation of an asset by Using SYD Function
Lecture 350 Calculating Depreciation of an asset by Using DDB Function
Lecture 351 Calculating Depreciation of an asset by Using VDB Function
Lecture 352 Calculating Depreciation Value of a Car
Lecture 353 Selecting Method of Depreciation to Calculate Depreciation of an Asset
Section 38: Financial FunctionsInvest Money in Company
Lecture 354 Calculating Yearly Interest Rate of an Investment by Using Rate Function Part 1
Lecture 355 Calculating Yearly Interest Rate of an Investment by Using Rate Function Part 2
Lecture 356 Calculating Payback Period of an Investment Part 1
Lecture 357 Calculating Payback Period of an Investment Part 2
Lecture 358 Calculating Payback Period of an Investment Part 3
Lecture 359 Calculate Present Value of an Invetment by Using NPV Function Part 1
Lecture 360 Calculate Present Value of an Invetment by Using NPV Function Part 2
Lecture 361 Calculate Net Present Value of an Invetment
Lecture 362 Calculate Internal Rate of Return of an Invetment by Using IRR Function
Lecture 363 Calculate Net Present Value & Internal Rate of Return using XNPV & XIRR Functons
Lecture 364 Calculate Equivalent Value of Interest Rate by Using RRI Function
Section 39: Basic Financial Examples(Learn Use of Operators +,-,,)
Lecture 365 Calculating the Remaining Amount with 30% Rate
Lecture 366 Calculating the Remaining Amount with 15% and 40% Rate
Lecture 367 Calculating the Percentage of Remaining Amount
Lecture 368 Calculating the Percentage of Savings
Lecture 369 Finding the Value of Actual Amount
Lecture 370 Calculating the Value of Expense,Save and Total Amount
Lecture 371 Calculating the Remaining Profit
Lecture 372 Calculating the Values of Profit and Percentage of Profit
Lecture 373 Calculating the Values of Loss and Percentage of Loss
Anyone looking to pursue a career in data analysis, finance, engineering and business intelligence,Anyone hoping to maximize productivity, work more efficiently, and take their career to a new level,recommended for absolute beginners and also for experts
Please, Log in or Register to view URLs content!

Free Download Recommend Download Link Hight Speed | Please Say Thanks Keep Topic Live
Links are Interchangeable - Single Extraction
 
K 0

KatzSec DevOps

Alpha and Omega
Philanthropist
Access
Joined
Jan 17, 2022
Messages
386,836
Reaction score
6,566
Points
83
grants
₲42,104
2 years of service
TOP salamat sa pag contribute. Next time always upload your files sa
Please, Log in or Register to view URLs content!
para siguradong di ma dedeadlink. Let's keep on sharing to keep our community running for good. This community is built for you and everyone to share freely. Let's invite more contributors para mabalik natin sigla ng Mobilarian at tuloy ang puyatan. :)
 
I 0

igotanissue

Fancier
Member
Access
Joined
Dec 13, 2022
Messages
849
Reaction score
22
Points
18
Age
26
Location
Qatar
grants
₲2,027
1 years of service
b3cacbd03a6ee3d3ef2726b3794bf168.jpeg

Free Download Microsoft Excel-Learn Basic To Advanced 2023
Published 3/2023
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 9.12 GB | Duration: 21h 18m
Excel with this A-Z Microsoft Excel Course. Microsoft Excel 2010, 2013, 2016, Excel 2019 and Microsoft/Office 365

What you'll learn
Master unique tips & techniques that you won't find in ANY other course, guaranteed
Automate, streamline, and completely revolutionize your workflow with Excel
Get LIFETIME access to project files, quizzes, homework exercises, and 1-on-1 expert support
Explore fun, interactive, and highly eLearn how to THINK like Excel, and write powerful and dynamic Excel forffective demos from a best-selling Excel instructor
Build stunning, professional-quality dashboards in Excel (from scratch!)
Apply powerful techniques for transforming raw data into beautiful, interactive visuals
Learn the same tools used by professional business intelligence analysts and data scientists
Analyzing Data with Business Intelligence (Power Queries and Trendlines)
and more .........
Requirements
Microsoft Excel 2007-2021 or Office 365 (Note: some tips may not apply to all versions of Excel)
Description
This course covers 35 sections.Students can learn basic and advanced concepts of Excel in this course.Learn pivottables ,pivotcharts,power query,power pivot,power map,what-if-analysis tools,solver and others topics.Learn how to add charts in Microsoft Excel sheet.Learn how to use formulas and functions in Microsoft Excel .To see more topics of this course,view course contents below.Who this course is for: If someone want to learn excel from basic to Advance,this course covers basic and advance levels topics.Requirements : This course is recorded on excel 2019 but all previous versions 2007,2010,2013,2016 and office 365 will work on this course.If you're looking to master Microsoft Excel, then this comprehensive course is exactly what you need! Whether you're a beginner just starting out or an experienced user looking to enhance your skills, this course has everything you need to take your Excel knowledge to the next level.With this course, you'll start with the basics of Excel and quickly progress through more advanced topics, such as data analysis, charts, graphs, pivot tables, macros, and more. You'll learn how to create professional-looking spreadsheets, automate repetitive tasks, and streamline your workflow. Plus, you'll learn tips and tricks that will save you time and make your work more efficient.One of the biggest advantages of this course is its accessibility. You can learn at your own pace and on your own schedule. With video tutorials, downloadable practice files, and hands-on exercises, you'll be able to practice what you learn and test your skills every step of the way.The instructor of this course is an expert in Excel with years of experience. He has designed this course to be easy to follow and understand, even for those who have never used Excel before. The lessons are broken down into bite-sized chunks, so you can learn one topic at a time and build upon your knowledge as you go.By the end of this course, you'll be able to confidently use Excel for a wide range of tasks. You'll have the skills you need to create complex spreadsheets, analyze data, and present your findings in a clear and concise manner. Whether you're looking to improve your job performance, advance your career, or simply become more proficient with Excel, this course is the perfect choice.Don't wait any longer to start mastering Microsoft Excel. Enroll in this course today and take the first step towards becoming an Excel expert!
Overview
Section 1: Introduction
Lecture 1 Introduction
Lecture 2 Excel Tabs,Groups and Commands
Lecture 3 Excel Rows and Columns
Lecture 4 Changing the Size of Columns and Rows
Lecture 5 Entering Text and Numbers in Worksheet
Lecture 6 Wrap Text Inside the Cell
Lecture 7 Edit Text Within a Cell
Lecture 8 Merging and Formatting Cells in a Worksheet
Lecture 9 Formatting Header in a Worksheet
Lecture 10 Adding Image in a Worksheet
Lecture 11 Formatting Date in Excel Worksheet
Lecture 12 Working of Undo & Redo Commands in an Excel Worksheet
Lecture 13 Home Work
Section 2: Creating Excel Tables,PivotTables and PivotCharts
Lecture 14 Freezing Header or Row
Lecture 15 Converting Data in an Excel Table
Lecture 16 Adding Records in an Excel Table
Lecture 17 Renaming and Finding Records in an Excel Table
Lecture 18 Editing and Deleting Records in an Excel Table
Lecture 19 Remove Duplicates
Lecture 20 Sorting Date Column in an Excel Table
Lecture 21 Sorting Multiple Columns
Lecture 22 Filtering Data in an Excel Worksheet and Deleting an Excel Table
Lecture 23 Filtering Data by Creating Criteria
Lecture 24 Filtering Data in an Excel Table by Using Slicer
Lecture 25 Splitting the Worksheet into Panes
Lecture 26 Calculating Records in an Excel Table
Lecture 27 Inserting Subtotals
Lecture 28 Creating and Adding Data in a Pivot Table
Lecture 29 Filtering Data in a Pivot Table
Lecture 30 Adding Pivot Chart in a Pivot Table
Lecture 31 Home Work
Section 3: Analyzing Sales Data in Pivot Tables and Pivot Charts
Lecture 32 Adding Data in Excel Table
Lecture 33 Adding and Formatting First Chart in Pivot Table
Lecture 34 Adding and Formatting Second Chart in Pivot Table
Lecture 35 Adding and Formatting Third Chart in Pivot Table
Lecture 36 Adding and Formatting Fourth Chart in Pivot Table
Lecture 37 Adding and Formatting Fifth Chart in Pivot Table
Lecture 38 Adding and Formatting Sixth Chart in Pivot Table
Lecture 39 Adding Chart in Excel Dashboard
Lecture 40 Designing Dashboard Layout and Extracting Pivot Tables Data in Text Box
Lecture 41 Inserting Slicers in the Dashboard for Analyzing Sales Data
Section 4: Data Validation and Inserting Comments
Lecture 42 Specifying a Validation Rule by Using List
Lecture 43 Displaying Error Alert Message
Lecture 44 Show an Input Message on an Active Cell
Lecture 45 Circle Invalid Data
Lecture 46 Inserting Comments in a Worksheet
Lecture 47 Home Work
Section 5: Analyzing Data in the Table
Lecture 48 Introducing and Converting a Range to a Table
Lecture 49 Sorting a Table using Different Methods
Lecture 50 Filtering a Table using Different Methods
Lecture 51 Analyzing Basic Table Operations
Lecture 52 Analyzing Table Data using COUNTIF,SUMIF and AVERAGEIF Functions
Section 6: Analyzing Data with PivotTables
Lecture 53 Introducing PivotTables
Lecture 54 Creating PivotTable
Lecture 55 Inserting Subtotals In the PivotTable
Lecture 56 Summarizes Value Field by Changing Functions
Lecture 57 Adding PivotChart and Slicer in the PivotTable
Section 7: Analyzing Data with Business Intelligence (Power Queries and Trendlines)
Lecture 58 Introducing Power Query and Upload CSV File
Lecture 59 Retrieving Power Query Data into an Excel Table and Editing a Query Data
Lecture 60 Adding a New Column and Grouping Values in a Power Query Data
Lecture 61 Analyzing Revenue Data by Adding Trendlines in the Chart
Section 8: Analyzing Data with Business Intelligence (Forecast Sheet)
Lecture 62 Analyzing Revenue Data by Creating a Forecast Sheet
Section 9: Analyzing Data with Business Intelligence (Power Pivot,Data Model & Power Map)
Lecture 63 Introducing Database and Upload Access Database File
Lecture 64 Creating the Data Model
Lecture 65 Transferring Data in the Power Pivot
Lecture 66 Exploring the Data Model in the Diagram View
Lecture 67 Managing Table Relationships in the Power Pivot
Lecture 68 Creating a PivotTable from the Data Model
Lecture 69 Adding a Timeline Slicer in the PivotTable
Lecture 70 Drilling down into the Data in the PivotTable
Lecture 71 Visualizing Stores Sale Data with Power Map
Section 10: Extracting Data from the Website(Power Query,Power Pivot,Pivot Table)
Lecture 72 Importing Population and Area Data from the Website and Creating Queries
Lecture 73 Extracting Population and Area Data into PivotTable
Lecture 74 Merging Two Queries into One query
Section 11: Loading Website Data into Power Map(Power Query,Power Map)
Lecture 75 Loading Website Data into Power Map
Section 12: Extracting Data from the Website(Power Query,Pivot Table)
Lecture 76 Extracting and Transforming User Rating Data from the Website
Lecture 77 Combining Queries
Section 13: Extracting Football Team Data from the Website(Power Query,Pivot Table)
Lecture 78 1. Extracting and Transforming Data from the Website
Section 14: Analyzing Business Data by using What-If Analysis Tools(Goal Seek,Data Table)
Lecture 79 Cost-Volume-Profit(CVP) Chart Analysis
Lecture 80 Find the Break-Even Point by Using Goal Seek
Lecture 81 Generate $30000 Net Income of Company by using Goal Seek Tool
Lecture 82 Creating One-Variable Data Table to Examine the Impact of Changing Sales Volume
Lecture 83 Completing the One-Variable Data Table
Lecture 84 Creating the CVP Chart of the Data Table
Lecture 85 Viewing the Impact of Changing the Sales Price in the Data Table
Lecture 86 Creating the Two-Variable Data Table
Lecture 87 Create a Chart of the Two Variable Data Table
Section 15: Analyzing Business Data by using What-If Analysis Tools(Scenario Manager)
Lecture 88 Define Names for the Income Statement Values
Lecture 89 Adding the Scenarios in the Scenario Manager
Lecture 90 View the Impact of the Reduced Operations Scenario
Lecture 91 Creating the Scenario Summary Report
Lecture 92 Creating the Scenario PivotTable Report
Section 16: Analyzing Business Data with Solver
Lecture 93 Understand Solver with Simple Example
Lecture 94 Introducing Product Mix and Find an Optimal Solution with Solver Part 1
Lecture 95 Introducing Product Mix and Find an Optimal Solution with Solver Part 2
Lecture 96 Creating a Solver Answer Report
Lecture 97 Saving and Loading Solver Model
Section 17: Calculations With Basic Formulas
Lecture 98 Introduction to Arithmetic Operators
Lecture 99 Calculations with Arithmetic Operators
Lecture 100 Copy and Paste the Formula
Lecture 101 Auto Complete Formula
Lecture 102 Inserting and Deleting Columns and Rows
Lecture 103 Hide and Unhide Columns and Rows
Lecture 104 Moving a Cell or Range by Drag and Drop Method
Lecture 105 Moving a Cell or Range by Cut and Paste Method
Lecture 106 Relative and Absolute Cell References
Lecture 107 Home Work
Section 18: Calculations with Simple Excel Functions
Lecture 108 Introduction to Function Syntax
Lecture 109 Calculating Total Sales by Using SUM Function
Lecture 110 Calculating Total Sales Quantities by Using SUM Function
Lecture 111 Count Price Items by Using COUNT Function
Lecture 112 Count Food Items by Using COUNTA Function
Lecture 113 Calculating Average Sales by Using AVERAGE Function
Lecture 114 Calculating Maximum Sales Value of Customer by Using MAX Function
Lecture 115 Calculating Minimum Sales Value of Customer by Using MIN Function
Lecture 116 Calculating Total Price of Products by Using PRODUCT Function
Lecture 117 Calculating Sales Data by Using Auto FUNCTION Button
Lecture 118 Calculating a Tax Rate on Total Sales
Lecture 119 Home Work
Section 19: Formatting a Worksheet
Lecture 120 Merging Two or More Cells into One Cell
Lecture 121 Alignment of Cell Text
Lecture 122 Splitting Text into Multiple Lines
Lecture 123 Rotating a Cell Text or Numbers
Lecture 124 Formatting Background Color of Text and Numbers
Lecture 125 Formatting Font Size and Font Color
Lecture 126 Adding Border into Cells
Lecture 127 Formatting Cell Styles
Lecture 128 Find and Replace Text in a Worksheet
Lecture 129 Calculating Students Enrollment and Difference Between two Columns Values
Lecture 130 Calculating Percentage Difference Between two Columns Values
Lecture 131 Conditionally Formatting Cells in a Worksheet
Lecture 132 Conditionally Formatting Cells with a Top and Bottom Rules
Lecture 133 Home Work
Section 20: Saving and Printing a Workbook
Lecture 134 Saving a Workbook
Lecture 135 Worksheet Views,Page Orientation and Scaling
Lecture 136 Setting Margins in a Print Page
Lecture 137 Adding Header and Footer in a Print Page
Lecture 138 Print Preview and Selecting Print Area
Lecture 139 Setting Scaling and Margins in a Print Page(Document 1)
Section 21: Project Calculations with Operators and Functions
Lecture 140 Calculating the Area of Field and Plots
Lecture 141 Calculating the Grown and Empty Area of Vegetables Field
Lecture 142 Calculating the Percentage of Grown and Empty area in Vegetables Field
Lecture 143 Calculating Cost of Sales and Weightages of Vegetables
Lecture 144 Calculating Profit and Percentage of Profit from Vegetables
Lecture 145 Calculating Revenue by Using Sum,Max,Min,Average and Median Functions
Lecture 146 Introduction to NESTED Function
Lecture 147 Nesting the SUM and MEDIAN Functions within ROUND Function
Lecture 148 Home Work
Section 22: IF and VLOOKUP Functions
Lecture 149 Introduction to IF Function and Apply Weather Condition on IF Function
Lecture 150 Apply Different Conditions on IF Function
Lecture 151 Introduction to VLOOKUP Function
Lecture 152 Apply VLOOKUP Function on Data Table
Lecture 153 Retrieving Values from Data Table by Using VLOOKUP Function
Lecture 154 Errors in VLOOKUP Function
Lecture 155 Home Work
Section 23: Adding Column and Pie Charts in an Excel worksheet
Lecture 156 Embed Column Chart in a Worksheet
Lecture 157 Analyzing Data with a Column Chart
Lecture 158 Analyzing Data with a Pie Chart
Lecture 159 Recommended Charts
Lecture 160 Home Work
Section 24: Date and Time Functions in an Excel
Lecture 161 NOW and TIME Functions
Lecture 162 HOUR,MINUTE and SECOND Functions
Lecture 163 TODAY,DATE and DAYS Functions
Lecture 164 YEAR,MONTH and DAY Functions
Lecture 165 WEEKDAY Function
Lecture 166 WEEKNUM Function
Lecture 167 EDATE Function
Lecture 168 EOMONTH Function
Lecture 169 Determining Person's Birthday
Lecture 170 Calculating Age of Person
Lecture 171 Formatting Date in a Cell
Lecture 172 DATEVALUE Function
Lecture 173 DAYS360 Function
Lecture 174 ISOWEEKNUM Function
Lecture 175 NETWORKDAYS Function
Lecture 176 TIMEVALUE Function
Lecture 177 YEARFRAC Function
Section 25: Logical Functions in an Excel
Lecture 178 Calculating the Age of Employees and Length of Service
Lecture 179 Analyzing Data by Using IF Function
Lecture 180 Determining Birthday of Employees
Lecture 181 Specifying Day of Birthdate by Nesting DAY Function Within IF Function
Lecture 182 Determining Employee Eligibility for Promotion by Using AND Function
Lecture 183 Nesting the AND Function Within IF Function
Lecture 184 Determining Employee Eligibility for Promotion by Using OR Function
Lecture 185 Nesting the OR Function Within IF Function
Lecture 186 IFERROR Function
Lecture 187 IFNA Function
Lecture 188 FALSE Function
Lecture 189 IFS Function
Lecture 190 NOT Function
Lecture 191 SWITCH Function
Lecture 192 TRUE Function
Lecture 193 XOR Function
Lecture 194 Home Work
Section 26: Lookup and Reference Functions in an Excel
Lecture 195 Extracting Value from Data Table by Using VLOOKUP Function
Lecture 196 Extracting Value from Data Table by Using HLOOKUP Function
Lecture 197 Calculating Discount and Total Price
Lecture 198 Calculating Tax Rate on Total Price Value
Lecture 199 Extracting Value by Using CHOOSE Function
Lecture 200 Nesting the CHOOSE Function Within Sum Function
Lecture 201 MATCH Function
Lecture 202 Extracting Value by Using INDEX Function
Lecture 203 Nesting the MATCH Function Within an INDEX Function
Lecture 204 Nesting the VLOOKUP Function Within an IFERROR Function
Lecture 205 COLUMN Function
Lecture 206 LOOKUP Function
Lecture 207 TRANSPOSE Function
Lecture 208 Home Work
Section 27: Adding Line and Combination Charts in an Excel
Lecture 209 Adding and Formatting Line Chart
Lecture 210 Adding and Formatting Combination Chart
Section 28: Text Functions in an Excel
Lecture 211 BHATTEXT Function
Lecture 212 CHAR Function
Lecture 213 CLEAN Function
Lecture 214 CODE Function
Lecture 215 CONCAT Function
Lecture 216 DOLLAR Function
Lecture 217 EXACT Function
Lecture 218 FIND Function
Lecture 219 FIXED Function
Lecture 220 LEFT Function
Lecture 221 LEN Function
Lecture 222 LOWER Function
Lecture 223 MID Function
Lecture 224 NUMBERVALUE Function
Lecture 225 PROPER Function
Lecture 226 REPLACE Function
Lecture 227 REPT Function
Lecture 228 RIGHT Function
Lecture 229 SEARCH Function
Lecture 230 SUBSTITUTE Function
Lecture 231 T Function
Lecture 232 TEXT Function
Lecture 233 TEXTJOIN Function
Lecture 234 TRIM Function
Lecture 235 UNICHAR Function
Lecture 236 UNICODE Function
Lecture 237 UPPER Function
Lecture 238 VALUE Function
Section 29: Math and Trigonometry Functions in an Excel
Lecture 239 SUM Function
Lecture 240 MOD Function
Lecture 241 POWER Function
Lecture 242 SUBTOTAL Function
Lecture 243 SUMIF Function
Lecture 244 SUMIFS Function
Lecture 245 SUMPRODUCT Function
Lecture 246 ROUND Function
Lecture 247 ROUNDDOWN Function
Lecture 248 ROUNDUP Function
Lecture 249 CEILING.MATH Function
Lecture 250 FLOOR.MATH Function
Lecture 251 EVEN Function
Lecture 252 ODD Function
Lecture 253 INT Function
Lecture 254 TRUNC Function
Section 30: Statistical Functions in an Excel
Lecture 255 AVERAGE Function
Lecture 256 AVERAGEIF Function
Lecture 257 AVERAGEIFS Function
Lecture 258 COUNT and COUNTA Function
Lecture 259 COUNTBLANK Function
Lecture 260 COUNTIF Function
Lecture 261 COUNTIFS Function
Lecture 262 LARGE Function
Lecture 263 SMALL Function
Lecture 264 MAX and MIN Function
Lecture 265 MEDIAN Function
Lecture 266 MODE.MULT Function
Lecture 267 MODE.SNGL Function
Section 31: Engineering Functions in an Excel
Lecture 268 BIN2DEC Function
Lecture 269 BIN2HEX Function
Lecture 270 BIN2OCT Function
Lecture 271 COMPLEX Function
Lecture 272 CONVERT Function
Lecture 273 DEC2BIN Function
Lecture 274 DEC2HEX Function
Lecture 275 DEC2OCT Function
Section 32: Information Functions in an Excel
Lecture 276 CELL Function
Lecture 277 ERROR.TYPE Function
Lecture 278 INFO Function
Lecture 279 ISBLANK Function
Lecture 280 ISERR Function
Lecture 281 ISERROR Function
Lecture 282 ISEVEN Function
Lecture 283 ISFORMULA Function
Lecture 284 ISLOGICAL Function
Lecture 285 ISNA Function
Lecture 286 ISNONTEXT Function
Lecture 287 ISNUMBER Function
Lecture 288 ISODD Function
Lecture 289 ISREF Function
Lecture 290 ISTEXT Function
Lecture 291 N Function
Lecture 292 NA Function
Lecture 293 SHEET Function
Lecture 294 SHEETS Function
Lecture 295 TYPE Function
Section 33: Database Functions in an Excel
Lecture 296 DAVERAGE Function
Lecture 297 DSUM Function
Lecture 298 DMAX and DMIN Functions
Lecture 299 DCOUNTA Function
Section 34: Financial FunctionsBorrow Money to Bank
Lecture 300 Calculating a Quarterly Payment of Loan by using the PMT Function
Lecture 301 Calculating a Future Value of Loan by using the FV Function
Lecture 302 Calculating a Payment Period of Loan by using the NPER Function
Lecture 303 Calculating a Present Value of Loan by using the PV Function
Lecture 304 Calculating an Interest Rate of Loan by using the RATE Function
Lecture 305 Positive Cash Flow and Negative Cash Flow
Lecture 306 Calculating the Value of Inflation by Using FV Functio
Lecture 307 Calculating a Monthly Car Payment
Lecture 308 Calculating the Interest Payment by using IPMT Function
Lecture 309 Calculating the Principal Payment by using PPMT Function
Lecture 310 Calculating Remaining Principal Amount and Total Payment
Lecture 311 Completing the Amortization Schedule of Loan
Lecture 312 Plotting Interest and Principal Payments
Lecture 313 Calculating Cumulative Interest Payments by Using CUMIPMT Function
Lecture 314 Calculating Cumulative Principal Payments by Using CUMPRINC Function
Lecture 315 Calculating Remaining Principal,Total Interest and Total Principal Payments
Lecture 316 Calculating Total Loan Amount
Section 35: Financial FunctionsInvest Money in the Bank Saving Account
Lecture 317 Calculating the Compound Interest
Lecture 318 Calculating Nominal and Effective Interest Rates Using NOMINAL&EFFECT Functions
Lecture 319 Calculating the Future Value of an Investment by Monthly and Initial Deposits
Lecture 320 Calculating the Interest Rate of an Investment
Lecture 321 Calculating the Total Number of Deposits of an Investment
Lecture 322 Calculating the Initial Deposit or Present Value of an investment
Lecture 323 Calculating the Value of Deposit Per Month
Lecture 324 Calculating the Variable Interest Rates by using FVSCHEDULE Function
Lecture 325 Amortization Schedule of an Investment 1
Lecture 326 Amortization Schedule of an Investment 2
Section 36: Financial FunctiomsBuild Future Income Statement of Company
Lecture 327 Introduction to Income Statement Worksheet
Lecture 328 Linear and Growth Trend Values
Lecture 329 Projecting Future Value of Sales or Revenue by using Linear Trend Option
Lecture 330 Projecting Future Value of Sales or Revenue by Inserting a Growth Trend
Lecture 331 Calculating the Cost of Research and Development
Lecture 332 Calculating the Cost of Sales and Marketing
Lecture 333 Calculating the Gross Profit
Lecture 334 Calculating the Expenses of Company Part 1
Lecture 335 Calculating the Expenses of Company Part 2
Lecture 336 Calculating the Expenses of Company Part 3
Lecture 337 Calculating the Total General Expenses and Initial Earnings
Lecture 338 Adding Depreciation of an Asset in the Income Statement
Lecture 339 Calculating Operating Profit in the Income Statement
Lecture 340 Adding Interest Expenses in the Income Statement
Lecture 341 Calculating Profit Without Adding Tax
Lecture 342 Adding Taxes in the Income Statement
Lecture 343 Calculating Final Profit of the Company in the Income Statement
Section 37: Financial FunctionsCalculate Depreciation of an Asset of Company
Lecture 344 Straight Line Depreciation of an Asset Part 1
Lecture 345 Straight Line Depreciation of an Asset Part 2
Lecture 346 Straight Line Depreciation of an Asset Part 3
Lecture 347 Declining Balance Depreciation of an Asset Part 1
Lecture 348 Declining Balance Depreciation of an Asset Part 2
Lecture 349 Calculating Depreciation of an asset by Using SYD Function
Lecture 350 Calculating Depreciation of an asset by Using DDB Function
Lecture 351 Calculating Depreciation of an asset by Using VDB Function
Lecture 352 Calculating Depreciation Value of a Car
Lecture 353 Selecting Method of Depreciation to Calculate Depreciation of an Asset
Section 38: Financial FunctionsInvest Money in Company
Lecture 354 Calculating Yearly Interest Rate of an Investment by Using Rate Function Part 1
Lecture 355 Calculating Yearly Interest Rate of an Investment by Using Rate Function Part 2
Lecture 356 Calculating Payback Period of an Investment Part 1
Lecture 357 Calculating Payback Period of an Investment Part 2
Lecture 358 Calculating Payback Period of an Investment Part 3
Lecture 359 Calculate Present Value of an Invetment by Using NPV Function Part 1
Lecture 360 Calculate Present Value of an Invetment by Using NPV Function Part 2
Lecture 361 Calculate Net Present Value of an Invetment
Lecture 362 Calculate Internal Rate of Return of an Invetment by Using IRR Function
Lecture 363 Calculate Net Present Value & Internal Rate of Return using XNPV & XIRR Functons
Lecture 364 Calculate Equivalent Value of Interest Rate by Using RRI Function
Section 39: Basic Financial Examples(Learn Use of Operators +,-,,)
Lecture 365 Calculating the Remaining Amount with 30% Rate
Lecture 366 Calculating the Remaining Amount with 15% and 40% Rate
Lecture 367 Calculating the Percentage of Remaining Amount
Lecture 368 Calculating the Percentage of Savings
Lecture 369 Finding the Value of Actual Amount
Lecture 370 Calculating the Value of Expense,Save and Total Amount
Lecture 371 Calculating the Remaining Profit
Lecture 372 Calculating the Values of Profit and Percentage of Profit
Lecture 373 Calculating the Values of Loss and Percentage of Loss
Anyone looking to pursue a career in data analysis, finance, engineering and business intelligence,Anyone hoping to maximize productivity, work more efficiently, and take their career to a new level,recommended for absolute beginners and also for experts
Please, Log in or Register to view URLs content!

Free Download Recommend Download Link Hight Speed | Please Say Thanks Keep Topic Live
*** Hidden text: cannot be quoted. ***

Links are Interchangeable - Single Extraction
salamat po
 
Top Bottom