0

  • No products in the cart.

Harness Microsoft Excel 2024 Office 365- From Basic To Advanced Proficiency

ratings 

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.

₵20.00
Course Access

Unlimited Duration

Last Updated

September 3, 2024

Students Enrolled

Total Video Time

19 hours, 48 minutes

Posted by

Anythingvideo School

Topics covered:

  • Creating excel tables, pivot tables and pivot chart
  • Analysing sales data in pivot tables and pivot chart
  • Data validation and inserting comments
  • Analysing data in the tables
  • Analysing data in the pivot tables
  • Analysing data with business intelligence
  • Extracting data from the website
  • Loading websites data into power maps


This course includes:

  • 19 Hours, 48 minutes on demand videos
  • Videos
  • Full lifetime access


Profile Photo
Anythingvideo School
4 4
134

Student(s)

About Instructor

Meet the dynamic trio behind Anythingvideoschool: Blago, Michael, and Susan. Together, they form a powerhouse team dedicated to providing comprehensive online courses designed to empower individuals in various aspects of their lives. Blago: I am accomplished online educator and entrepreneur dedicated to empowering individuals with practical knowledge and skills to thrive in today's digital landscape. With a diverse array of courses spanning topics from digital marketing to personal development, I have established myself as a trusted authority in the online learning community. Susan: As the mindfulness advocate of the group, Susan is deeply passionate about promoting mental well-being and personal growth. Her courses, including "Meditation For Busy People: A Step-By-Step Guide" and "Mindfulness: A Beginner's Guide To Mindfulness To Improve Your Body, Mind and Spirit In Times Of Chaos," reflect his dedication to fostering inner peace and resilience in the face of challenges. Michael: A creative visionary with a flair for storytelling, Michael specializes in content creation and communication strategies. His courses, such as "The Animated Video Playbook: How To Create Engaging Videos" and " Leadership Authority: The Unfair Advantage," empower learners to harness the power of compelling narratives and persuasive communication to achieve their goals. Together, Blago, Michael, and Susan combine their diverse skills and experiences to offer a comprehensive range of courses that cater to the multifaceted needs of today's learners. With their collective expertise in online business,digital marketing, personal development, and effective communication, they are committed to guiding students on a transformative journey towards success. Join Blago, Michael, and Susan at Anythingvideoschool and unlock your full potential today!

Course Currilcum

    • Starting With Excel 00:01:42
    • Excel Tabs,Groups and Commands 00:02:25
    • Excel Rows and Columns 00:03:23
    • Changing the Size of Columns and Rows 00:01:30
    • Entering Text and Numbers in Worksheet 00:04:06
    • Wrap Text Inside the Cell 00:00:43
    • Edit Text Within a Cell 00:00:34
    • Merging and Formatting Cells in a Worksheet 00:01:53
    • Formatting Header in a Worksheet 00:01:08
    • Adding Image in a Worksheet 00:01:54
    • Formatting Date in Excel Worksheet 00:01:23
    • Working of Undo & Redo Commands in an Excel Worksheet 00:01:07
    • Home Work 00:00:41
    • Introduction to Arithmetic Operators 00:01:45
    • Calculations with Arithmetic Operators 00:07:12
    • Copy and Paste the Formula 00:01:56
    • Auto Complete Formula 00:01:40
    • Inserting and Deleting Columns and Rows 00:02:03
    • Hide and Unhide Columns and Rows 00:01:25
    • Moving a Cell or Range by Drag and Drop Method 00:01:27
    • Moving a Cell or Range by Cut and Paste Method 00:00:41
    • Relative and Absolute Cell References 00:04:07
    • Home Work 00:00:55
    • Specifying a Validation Rule by Using List 00:04:34
    • Show an Input Message on an Active Cell 00:04:09
    • Displaying Error Alert Message 00:04:00
    • Circle Invalid Data 00:01:07
    • Inserting Comments in a Worksheet 00:03:17
    • Home Work 00:00:42
      • Introducing and Converting a Range to a Table 00:03:02
      • Sorting a Table using Different Methods 00:03:39
      • Filtering a Table using Different Methods 00:05:48
      • Analyzing Basic Table Operations 00:05:33
      • Analyzing Table Data using COUNTIF,SUMIF and AVERAGEIF Functions 00:06:16
        • Introducing PivotTables 00:02:00
        • Creating PivotTable 00:04:49
        • Inserting Subtotals In the PivotTable 00:03:39
        • Summarizes Value Field by Changing Functions 00:02:11
        • Adding PivotChart and Slicer in the PivotTable 00:03:41
        • Adding PivotChart and Slicer in the PivotTable 00:03:41
        • Introducing Power Query and Upload CSV File 00:03:48
        • Retrieving Power Query Data into an Excel Table and Editing a Query Data 00:05:02
        • Adding a New Column and Grouping Values in a Power Query Data 00:06:39
        • Analyzing Revenue Data by Adding Trendlines in the Chart 00:05:14
        • Analyzing Revenue Data by Creating a Forecast Sheet 00:06:04
        • Introducing Database and Upload Access Database File 00:04:06
        • Creating the Data Model 00:04:26
        • Transferring Data in the Power Pivot 00:03:35
        • Exploring the Data Model in the Diagram View 00:02:00
        • Managing Table Relationships in the Power Pivot 00:04:11
        • Creating a PivotTable from the Data Model 00:05:38
        • Adding a Timeline Slicer in the PivotTable 00:02:48
        • Drilling down into the Data in the PivotTable 00:03:46
        • Visualizing Stores Sale Data with Power Map 00:06:28
        • Importing Population and Area Data from the Website and Creating Queries 00:05:11
        • Extracting Population and Area Data into PivotTable 00:04:40
        • Merging Two Queries into One query 00:05:55
        • Loading Website Data into Power Map 00:06:51
        • Extracting and Transforming User Rating Data from the Website 00:07:52
        • Combining Queries 00:08:43
        • Extracting and Transforming Data from the Website 00:06:50
        • Cost-Volume-Profit(CVP) Chart Analysis 00:02:53
        • Find the Break-Even Point by Using Goal Seek 00:04:08
        • Generate $30000 Net Income of Company by using Goal Seek Tool 00:01:12
        • Creating One-Variable Data Table to Examine the Impact of Changing Sales Volume 00:04:41
        • Completing the One-Variable Data Table 00:02:41
        • Creating the CVP Chart of the Data Table 00:02:59
        • Viewing the Impact of Changing the Sales Price in the Data Table 00:02:45
        • Creating the Two-Variable Data Table 00:05:35
        • Create a Chart of the Two Variable Data Table 00:04:24
        • Define Names for the Income Statement Values 00:02:33
        • Adding the Scenarios in the Scenario Manager 00:07:17
        • View the Impact of the Reduced Operations Scenario 00:03:52
        • Creating the Scenario Summary Report 00:02:36
        • Creating the Scenario PivotTable Report 00:06:20
          • Understand Solver with Simple Example 00:05:51
          • Introducing Product Mix and Find an Optimal Solution with Solver Part 1 00:04:52
          • Introducing Product Mix and Find an Optimal Solution with Solver Part 2 00:06:10
          • Creating a Solver Answer Report 00:02:22
          • Saving and Loading Solver Model 00:02:18
          • Freezing Header or Row 00:01:31
          • Converting Data in an Excel Table 00:02:00
          • Adding Records in an Excel Table 00:04:09
          • Renaming and Finding Records in an Excel Table 00:02:46
          • Editing and Deleting Records in an Excel Table 00:02:26
          • Remove Duplicates 00:02:25
          • Sorting Date Column in an Excel Table 00:01:43
          • Sorting Multiple Columns 00:02:04
          • Filtering Data in an Excel Worksheet and Deleting an Excel Table 00:03:15
          • Filtering Data by Creating Criteria 00:02:57
          • Filtering Data in an Excel Table by Using Slicer 00:02:16
          • Splitting the Worksheet into Panes 00:02:34
          • Calculating Records in an Excel Table 00:02:53
          • Inserting Subtotals 00:03:07
          • Creating and Adding Data in a Pivot Table 00:03:51
          • Filtering Data in a Pivot Table 00:03:13
          • Adding Pivot Chart in a Pivot Table 00:02:14
          • Home Work 00:00:38
          • Adding Data in Excel Table 00:02:50
          • Adding and Formatting First Chart in Pivot Table 00:04:01
          • Adding and Formatting Second Chart in Pivot Table 00:03:26
          • Adding and Formatting Third Chart in Pivot Table 00:04:08
          • Adding and Formatting Fourth Chart in Pivot Table 00:03:17
          • Adding and Formatting Fifth Chart in Pivot Table 00:03:28
          • Adding and Formatting Sixth Chart in Pivot Table 00:03:03
          • Adding Chart in Excel Dashboard 00:03:02
          • Designing Dashboard Layout and Extracting Pivot Tables Data in Text Box 00:03:23
          • Inserting Slicers in the Dashboard for Analyzing Sales Data 00:03:52
          • Introduction to Function Syntax 00:03:56
          • Calculating Total Sales by Using SUM Function 00:02:45
          • Calculating Total Sales Quantities by Using SUM Function 00:01:12
          • Count Price Items by Using COUNT Function 00:01:28
          • Count Food Items by Using COUNTA Function 00:01:38
          • Calculating Average Sales by Using AVERAGE Function 00:02:23
          • Calculating Maximum Sales Value of Customer by Using MAX Function 00:01:30
          • Calculating Minimum Sales Value of Customer by Using MIN Function 00:01:28
          • Calculating Total Price of Products by Using PRODUCT Function 00:02:02
          • Calculating Sales Data by Using Auto FUNCTION Button 00:01:42
          • Calculating a Tax Rate on Total Sales 00:03:03
          • Home Work 00:00:44
          • Merging Two or More Cells into One Cell 00:02:05
          • Alignment of Cell Text 00:02:09
          • Splitting Text into Multiple Lines 00:02:07
          • Rotating a Cell Text or Numbers 00:01:31
          • Formatting Background Color of Text and Numbers 00:03:11
          • Formatting Font Size and Font Color 00:02:18
          • Adding Border into Cells 00:01:39
          • Formatting Cell Styles 00:02:10
          • Find and Replace Text in a Worksheet 00:03:06
          • Calculating Students Enrollment and Difference Between two Columns Values 00:04:21
          • Calculating Percentage Difference Between two Columns Values 00:02:44
          • Conditionally Formatting Cells in a Worksheet 00:02:53
          • Conditionally Formatting Cells with a Top and Bottom Rules 00:01:50
          • Home Work 00:00:36
          • Saving a Workbook 00:01:08
          • Worksheet Views,Page Orientation and Scaling 00:03:37
          • Setting Margins in a Print Page 00:01:23
          • Adding Header and Footer in a Print Page 00:03:42
          • Print Preview and Selecting Print Area 00:03:05
          • Setting Scaling and Margins in a Print Page(Document 1) 00:02:54
          • Calculating the Area of Field and Plots 00:03:32
          • Calculating the Grown and Empty Area of Vegetables Field 00:01:58
          • Calculating the Percentage of Grown and Empty area in Vegetables Field 00:02:18
          • Calculating Cost of Sales and Weightages of Vegetables 00:04:08
          • Calculating Profit and Percentage of Profit from Vegetables 00:03:40
          • Calculating Revenue by Using Sum,Max,Min,Average and Median Functions 00:04:53
          • Introduction to NESTED Function 00:01:38
          • Nesting the SUM and MEDIAN Functions within ROUND Function 00:01:52
          • Home Work 00:01:04
          • Introduction to IF Function and Apply Weather Condition on IF Function 00:04:10
          • Apply Different Conditions on IF Function 00:08:07
          • Introduction to VLOOKUP Function 00:03:30
          • Apply VLOOKUP Function on Data Table 00:02:02
          • Retrieving Values from Data Table by Using VLOOKUP Function 00:02:26
          • Errors in VLOOKUP Function 00:02:28
          • Home Work 00:00:45
          • Embed Column Chart in a Worksheet 00:02:41
          • Analyzing Data with a Column Chart 00:05:20
          • Analyzing Data with a Pie Chart 00:03:47
          • Recommended Charts 00:02:52
          • Home Work 00:00:36
          • NOW and TIME Functions 00:03:40
          • HOUR,MINUTE and SECOND Functions 00:03:27
          • TODAY,DATE and DAYS Functions 00:03:56
          • YEAR,MONTH and DAY Functions 00:04:22
          • WEEKDAY Function 00:02:37
          • WEEKNUM Function 00:01:47
          • EDATE Function 00:02:31
          • EOMONTH Function 00:02:57
          • Determining Person’s Birthday 00:02:02
          • Calculating Age of Person 00:02:13
          • Formatting Date in a Cell 00:01:24
          • DATEVALUE Function 00:01:13
          • DAYS360 Function 00:02:01
          • ISOWEEKNUM Function 00:01:37
          • NETWORKDAYS Function 00:01:28
          • TIMEVALUE Function 00:01:57
          • YEARFRAC Function 00:02:21
          • Calculating the Age of Employees and Length of Service 00:02:45
          • Analyzing Data by Using IF Function 00:04:15
          • Determining Birthday of Employees 00:02:23
          • Specifying Day of Birthdate by Nesting DAY Function Within IF Function 00:03:06
          • Determining Employee Eligibility for Promotion by Using AND Function 00:04:13
          • Nesting the AND Function Within IF Function 00:04:23
          • Determining Employee Eligibility for Promotion by Using OR Function 00:03:48
          • Nesting the OR Function Within IF Function 00:04:23
          • IFERROR Function 00:02:59
          • IFNA Function 00:05:31
          • FALSE Function 00:02:48
          • IFS Function 00:04:42
          • NOT Function 00:03:23
          • SWITCH Function 00:04:19
          • TRUE Function 00:03:00
          • XOR Function 00:02:37
          • Home Work 00:00:31
          • Extracting Value from Data Table by Using VLOOKUP Function 00:07:05
          • Extracting Value from Data Table by Using HLOOKUP Function 00:05:05
          • Calculating Discount and Total Price 00:02:01
          • Calculating Tax Rate on Total Price Value 00:01:09
          • Extracting Value by Using CHOOSE Function 00:03:58
          • Nesting the CHOOSE Function Within Sum Function 00:04:17
          • MATCH Function 00:02:58
          • Extracting Value by Using INDEX Function 00:03:19
          • Nesting the MATCH Function Within an INDEX Function 00:03:24
          • Nesting the VLOOKUP Function Within an IFERROR Function 00:04:28
          • COLUMN Function 00:01:45
          • LOOKUP Function 00:06:32
          • TRANSPOSE Function 00:03:41
          • Home Work 00:00:22
          • Adding and Formatting Line Chart 00:03:39
          • Adding and Formatting Combination Chart 00:04:07
          • BHATTEXT Function 00:01:50
          • CHAR Function 00:02:18
          • CLEAN Function 00:01:30
          • CODE Function 00:01:17
          • CONCAT Function 00:02:25
          • DOLLAR Function 00:02:19
          • EXACT Function 00:02:29
          • FIND Function 00:03:39
          • FIXED Function 00:02:45
          • LEFT Function 00:02:43
          • LEN Function 00:01:54
          • LOWER Function 00:02:01
          • MID Function 00:04:05
          • NUMBERVALUE Function 00:02:49
          • PROPER Function 00:01:19
          • REPLACE Function 00:04:26
          • REPT Function 00:03:58
          • RIGHT Function 00:02:54
          • SEARCH Function 00:03:51
          • SUBSTITUTE Function 00:03:55
          • T Function 00:01:40
          • TEXT Function 00:04:09
          • TEXTJOIN Function 00:03:34
          • TRIM Function 00:01:48
          • UNICHAR Function 00:01:17
          • UNICODE Function 00:01:41
          • UPPER Function 00:02:14
          • VALUE Function 00:01:56
          • SUM Function 00:05:43
          • MOD Function 00:01:39
          • POWER Function 00:02:57
          • SUBTOTAL Function 00:06:18
          • SUMIF Function 00:07:19
          • SUMIFS Function 00:08:08
          • SUMPRODUCT Function 00:04:20
          • ROUND Function 00:05:37
          • ROUNDDOWN Function 00:02:18
          • ROUNDUP Function 00:02:07
          • CEILING.MATH Function 00:03:21
          • EVEN Function 00:01:50
          • ODD Function 00:01:45
          • INT Function 00:02:25
          • TRUNC Function 00:03:23
          • AVERAGE Function 00:01:50
          • AVERAGEIF Function 00:08:31
          • AVERAGEIFS Function 00:09:46
          • COUNT and COUNTA Function 00:04:45
          • COUNTBLANK Function 00:02:52
          • COUNTIF Function 00:07:15
          • COUNTIFS Function 00:08:08
          • LARGE Function 00:04:28
          • SMALL Function 00:03:51
          • MAX and MIN Function 00:02:55
          • MEDIAN Function 00:03:02
          • MODE.MULT Function 00:03:39
          • MODE.SNGL Function 00:02:59
          • DAVERAGE Function 00:04:17
          • DSUM Function 00:02:32
          • DMAX and DMIN Functions 00:03:53
          • DCOUNTA Function 00:03:58
          • Calculating a Quarterly Payment of Loan by using the PMT Function 00:07:14
          • Calculating a Future Value of Loan by using the FV Function 00:05:46
          • Calculating a Payment Period of Loan by using the NPER Function 00:04:11
          • Calculating a Present Value of Loan by using the PV Function 00:04:37
          • Calculating an Interest Rate of Loan by using the RATE Function 00:04:12
          • Positive Cash Flow and Negative Cash Flow 00:03:18
          • Calculating the Value of Inflation by Using FV Function 00:03:20
          • Calculating a Monthly Car Payment 00:04:20
          • Calculating the Interest Payment by using IPMT Function 00:05:39
          • Calculating the Principal Payment by using PPMT Function 00:03:26
          • Calculating Remaining Principal Amount and Total Payment 00:04:09
          • Completing the Amortization Schedule of Loan 00:06:25
          • Plotting Interest and Principal Payments 00:03:22
          • Calculating Cumulative Interest Payments by Using CUMIPMT Function 00:05:11
          • Calculating Cumulative Principal Payments by Using CUMPRINC Function 00:05:31
          • Calculating Remaining Principal,Total Interest and Total Principal Payments 00:07:04
          • Calculating Total Loan Amount 00:04:48
          • Calculating the Compound Interest 00:05:27
          • Calculating Nominal and Effective Interest Rates Using NOMINAL&EFFECT Functions 00:06:10
          • Calculating the Future Value of an Investment by Monthly and Initial Deposits 00:06:36
          • Calculating the Interest Rate of an Investment 00:06:25
          • Calculating the Total Number of Deposits of an Investment 00:06:30
          • Calculating the Initial Deposit or Present Value of an investment 00:05:18
          • Calculating the Value of Deposit Per Month 00:04:38
          • Calculating the Variable Interest Rates by using FVSCHEDULE Function 00:05:08
          • Amortization Schedule of an Investment 1 00:05:28
          • Amortization Schedule of an Investment 2 00:05:11
          • Introduction to Income Statement Worksheet 00:02:14
          • Linear and Growth Trend Values 00:02:08
          • Projecting Future Value of Sales or Revenue by using Linear Trend Option 00:05:01
          • Projecting Future Value of Sales or Revenue by Inserting a Growth Trend 00:04:59
          • Calculating the Cost of Research and Development 00:03:32
          • Calculating the Cost of Sales and Marketing 00:03:36
          • Calculating the Gross Profit 00:03:26
          • Calculating the Expenses of Company Part 1 00:03:21
          • Calculating the Expenses of Company Part 2 00:04:19
          • Calculating the Expenses of Company Part 3 00:04:28
          • Calculating the Total General Expenses and Initial Earnings 00:03:52
          • Adding Depreciation of an Asset in the Income Statement 00:03:09
          • Calculating Operating Profit in the Income Statement 00:02:32
          • Adding Interest Expenses in the Income Statement 00:04:00
          • Calculating Profit Without Adding Tax 00:01:34
          • Adding Taxes in the Income Statement 00:03:58
          • Calculating Final Profit of the Company in the Income Statement 00:03:00
          • Straight Line Depreciation of an Asset Part 1 00:03:22
          • Straight Line Depreciation of an Asset Part 2 00:04:03
          • Straight Line Depreciation of an Asset Part 3 00:03:07
          • Declining Balance Depreciation of an Asset Part 1 00:03:57
          • Declining Balance Depreciation of an Asset Part 2 00:05:14
          • Calculating Depreciation of an asset by Using SYD Function 00:04:57
          • Calculating Depreciation of an asset by Using DDB Function 00:04:00
          • Calculating Depreciation of an asset by Using VDB Function 00:05:27
          • Calculating Depreciation Value of a Car 00:02:37
          • Selecting Method of Depreciation to Calculate Depreciation of an Asset 00:02:20
          • Calculating Yearly Interest Rate of an Investment by Using Rate Function Part 1 00:02:40
          • Calculating Yearly Interest Rate of an Investment by Using Rate Function Part 2 00:03:31
          • Calculating Payback Period of an Investment Part 1 00:04:29
          • Calculating Payback Period of an Investment Part 2 00:02:48
          • Calculating Payback Period of an Investment Part 3 00:02:44
          • Calculate Present Value of an Invetment by Using NPV Function Part 1 00:03:13
          • Calculate Present Value of an Invetment by Using NPV Function Part 2 00:02:25
          • Calculate Net Present Value of an Invetment 00:02:08
          • Calculate Internal Rate of Return of an Invetment by Using IRR Function 00:02:03
          • Calculate Net Present Value & Internal Rate of Return using XNPV & XIRR Functons 00:03:33
          • Calculate Equivalent Value of Interest Rate by Using RRI Function 00:02:57
          • Calculating the Remaining Amount with 30% Rate 00:03:30
          • Calculating the Remaining Amount with 15% and 40% Rate 00:04:25
          • Calculating the Percentage of Remaining Amount 00:04:30
          • Calculating the Percentage of Savings 00:04:10
          • Finding the Value of Actual Amount 00:04:57
          • Calculating the Value of Expense,Save and Total Amount 00:05:23
          • Calculating the Remaining Profit 00:04:03
          • Calculating the Values of Profit and Percentage of Profit 00:03:25
          • Calculating the Values of Loss and Percentage of Loss 00:04:43

        Course Reviews

        ​