->

Microsoft Excel-Learn Basic To Advanced 2023

Published 3/2023MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHzLanguage: 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

Master unique tips & techniques that you won't find in ANY other course, guaranteed

Automate, streamline, and completely revolutionize your workflow with Excel

Get LIFE 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 transfog 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 .........

Microsoft Excel 2007-2021 or Office 365 (Note: some tips may not apply to all versions of Excel)

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 bner 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 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, able 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 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!

Section 1: Introduction

Lecture 1 Introduction

Lecture 2 Excel Tabs,Groups and Commands

Lecture 3 Excel Rows and Columns

Lecture 4 Chag 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 Meg 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 Chag 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 line 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 Meg 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 Transfog 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 Transfog 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 Chag 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 Chag 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 Meg 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 Mas 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 Mas 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 Functions in an Excel

Lecture 161 NOW and 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 Deteing 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 VALUE 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 Deteing Birthday of Employees

Lecture 181 Specifying Day of Birthdate by Nesting DAY Function Within IF Function

Lecture 182 Deteing Employee Eligibility for Promotion by Using AND Function

Lecture 183 Nesting the AND Function Within IF Function

Lecture 184 Deteing 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: Eeering 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, eeering and business intelligence,Anyone hoping to maximize productivity, work more efficiently, and take their career to a new level,recommended for absolute bners and also for experts

HomePage:

https://www.udemy.com/course/microsoft-excel-learn-basic-to-advanced/

 

 

 


 TO MAC USERS: If RAR password doesn't work, use this archive program: 

RAR Expander 0.8.5 Beta 4  and extract password protected files without error.


 TO WIN USERS: If RAR password doesn't work, use this archive program: 

Latest Winrar  and extract password protected files without error.


 Themelli   |  

Information
Members of Guests cannot leave comments.




rss