• Course Categories
    • Business, Management & Law
    • Finance
    • Personal Development
    • Productivity
    • Marketing
    • Trading
    • Design
    • Health & Fitness
    • Languages
    • Videography
    • Photography
    • Web Development
  • Cart
  • Gift Bundles
  • Popular courses
  • All Courses
  • All Access Pass
      • Sign UpLogin
    EDPLX.COM | Over 1000 Home Study, Distance Learing Courses.EDPLX.COM | Over 1000 Home Study, Distance Learing Courses.
    • Course Categories
      • Business, Management & Law
      • Finance
      • Personal Development
      • Productivity
      • Marketing
      • Trading
      • Design
      • Health & Fitness
      • Languages
      • Videography
      • Photography
      • Web Development
    • Cart
    • Gift Bundles
    • Popular courses
    • All Courses
    • All Access Pass
    • Browse
    • Cart
    • All Access Pass
      • Sign UpLogin
      • Build
      • Business
      • Finance
      • Personal Development
      • Productivity
      • Marketing
      • Trading
      • Create
      • Design
      • Health & Fitness
      • Languages
      • Photography
      • Videography
      • Web Development
      • All Courses
      • Gift Bundles
      • Popular Courses
      • Live Courses

      Productivity

      Test
      • Home
      • All courses
      • Productivity
      • Excel Simplified – 101 Tips
      CoursesBusiness, Management & LawProductivityExcel Simplified – 101 Tips
      • Section 1: Introduction to the course and your tutor 2

        • Lecture1.1
          Introduction to what we’ll cover and how 02 min
        • Lecture1.2
          Downloadable Resource
      • Section 2: Data 11

        • Lecture2.1
          Enter numbers and fractions 05 min
        • Lecture2.2
          Dates and Times 08 min
        • Lecture2.3
          Name Cells and Ranges 04 min
        • Lecture2.4
          Validate Data entry using a pick list 08 min
        • Lecture2.5
          Extend a series of dates with autofill 05 min
        • Lecture2.6
          Add a symbol or special character 04 min
        • Lecture2.7
          Compare multiple spreadsheets using freeze panels 06 min
        • Lecture2.8
          Hide rows 05 min
        • Lecture2.9
          Keyboard 10 min
        • Lecture2.10
          Speak Cells 04 min
        • Lecture2.11
          Find and replace data 11 min
      • Section 3: Formulas and Functions 18

        • Lecture3.1
          Add values 03 min
        • Lecture3.2
          Function wizard 06 min
        • Lecture3.3
          Formulas with comments 05 min
        • Lecture3.4
          OneNote 06 min
        • Lecture3.5
          Define a constant 04 min
        • Lecture3.6
          Apply names in functions 05 min
        • Lecture3.7
          Figure out the best loan terms 05 min
        • Lecture3.8
          Internal Rates of Return 04 min
        • Lecture3.9
          Nth largest value 04 min
        • Lecture3.10
          Large. Small. Max, Min 05 min
        • Lecture3.11
          Conditional formula 03 min
        • Lecture3.12
          Conditional formula with names 04 min
        • Lecture3.13
          Count If 02 min
        • Lecture3.14
          Conditional sum 03 min
        • Lecture3.15
          Inner calculator 03 min
        • Lecture3.16
          Square Roots 03 min
        • Lecture3.17
          Calculate the duration between two times 04 min
        • Lecture3.18
          Calculate days between two dates 05 min
      • Section 4: Copying Data, Formats etc. 6

        • Lecture4.1
          Copy a range 03 min
        • Lecture4.2
          Transpose a row into a column 02 min
        • Lecture4.3
          Copy styles to another workbook 08 min
        • Lecture4.4
          Chart formatting 07 min
        • Lecture4.5
          Paste special and copying worksheets 07 min
        • Lecture4.6
          Track changes while Editing 06 min
      • Section 5: Lists 13

        • Lecture5.1
          Enter list data using a form 05 min
        • Lecture5.2
          Searching through a data list 04 min
        • Lecture5.3
          Import a word list into excel 05 min
        • Lecture5.4
          Sort a list 02 min
        • Lecture5.5
          Filter a list 03 min
        • Lecture5.6
          Sort by multiple criteria 03 min
        • Lecture5.7
          Find averages in a sorted group 05 min
        • Lecture5.8
          Filter by multiple criteria 03 min
        • Lecture5.9
          Remove duplicate records from a list 03 min
        • Lecture5.10
          Count filtered records 07 min
        • Lecture5.11
          Filter by multiple criteria in the same column 06 min
        • Lecture5.12
          Chart a filtered list 03 min
        • Lecture5.13
          Look up information in a List 05 min
      • Section 6: Data Patterns 14

        • Lecture6.1
          Create a PivotTable 06 min
        • Lecture6.2
          Modify a PivotTable and layout 03 min
        • Lecture6.3
          Find the average of a field 04 min
        • Lecture6.4
          Create a calculated field 02 min
        • Lecture6.5
          Calculated fields and charts 02 min
        • Lecture6.6
          Hide rows and columns in a PivotTable 01 min
        • Lecture6.7
          AutoFormat a PivotTable 03 min
        • Lecture6.8
          Create a PivotChart 03 min
        • Lecture6.9
          Turning on the Data Analysis function so that statistical info can be run 03 min
        • Lecture6.10
          Describe Data with Statistics 03 min
        • Lecture6.11
          Discover associations within your data 04 min
        • Lecture6.12
          Product Numbers 02 min
        • Lecture6.13
          What-if analysis 05 min
        • Lecture6.14
          Goal seek 07 min
      • Section 7: Creating Charts 14

        • Lecture7.1
          Create a Chart 06 min
        • Lecture7.2
          Modify Chart details 04 min
        • Lecture7.3
          Change the Chart Type 04 min
        • Lecture7.4
          Add a Trendline to a Chart 07 min
        • Lecture7.5
          Remove Chart Data 02 min
        • Lecture7.6
          Add chart data 02 min
        • Lecture7.7
          Missing chart data 04 min
        • Lecture7.8
          Error bars 04 min
        • Lecture7.9
          Pull a slice from a Pie Chart 03 min
        • Lecture7.10
          Label slices of a Pie Chart 04 min
        • Lecture7.11
          Histogram 07 min
        • Lecture7.12
          Paste a chart into Word 04 min
        • Lecture7.13
          Amending a chart in Word 02 min
        • Lecture7.14
          Paste-link a Chart into Word 05 min
      • Section 8: Worksheets 6

        • Lecture8.1
          Format Numbers as Percentages 04 min
        • Lecture8.2
          Format Currencies in Currency and Accounting Formats 04 min
        • Lecture8.3
          Format Column Headings 05 min
        • Lecture8.4
          Format Quickly with Format painter 03 min
        • Lecture8.5
          Insert a background image into your worksheet 03 min
        • Lecture8.6
          Create a Transparent image 03 min
      • Section 9: Saving and Printing Worksheets 8

        • Lecture9.1
          Save a workbook as a Template 07 min
        • Lecture9.2
          Save a workbook as an XML spreadsheet 05 min
        • Lecture9.3
          Print multiple cell ranges on One Page 03 min
        • Lecture9.4
          Page setup, header, footer, margins – 1 page printing 05 min
        • Lecture9.5
          Print multiple areas of a workbook 08 min
        • Lecture9.6
          Print multiple worksheets of a workbook 02 min
        • Lecture9.7
          Repeat Headings of a Row or Column 07 min
        • Lecture9.8
          Print functions to show calculations & comments 08 min
      • Section 10: Extending Excel 6

        • Lecture10.1
          Hyperlink a worksheet to another office documents 03 min
        • Lecture10.2
          Embed a chart within PowerPoint 06 min
        • Lecture10.3
          Publish an Interactive Workbook 05 min
        • Lecture10.4
          Importing data from a Website or Access Database 03 min
        • Lecture10.5
          Import a Worksheet into Access 09 min
        • Lecture10.6
          Use Excel Data to create labels in Word 10 min
      • Section 11: Customizing Excel 5

        • Lecture11.1
          Launch a specific Workbook when Excel Opens 04 min
        • Lecture11.2
          Save Time by Creating a Custom View 04 min
        • Lecture11.3
          Create a Custom Number Format 06 min
        • Lecture11.4
          Changing Text to Columns 06 min
        • Lecture11.5
          Create a Macro to Format Numbers 07 min
      • Section 12: Next steps 1

        • Lecture12.1
          What to study next – Excel advanced 01 min
        This content is protected, please login and enroll course to view this content!
        Prev Use Excel Data to create labels in Word
        Next Save Time by Creating a Custom View

        Categories

        • Business, Management & Law
          • Finance
          • Marketing
          • Personal Development
          • Productivity
          • Trading
        • Course Builder
        • Design
        • Finance
        • Health & Social Care
        • Information Technology
        • Languages
        • Marketing
        • Open Learning College
          • Course Builder
        • Personal Development
        • Photography
        • Productivity
        • Trading
        • Videography

        EDPLX is a learning community with online courses in design, business, web development, photography, fitness and more. Anyone can join the community to learn cutting-edge skills, network with other creatives and discover new oppotunities.

        Company
        • About
        • Blog
        • Contact
        • FAQ
        Community
        • Become an Instructor
        • Redeem Voucher
        new-logo

        @2024 All rights reserved. Privacy Policy and Terms and condition.

        EDPLX Limited 15398152

        Facebook-f
        Youtube
        Twitter
        Instagram

        Connect with

        Login with Facebook

        logo

        Login

        Connect with

        Login with Facebook

        logo


        Lost your password?

        Not a member yet? Register now

        Sign up with your Email

        Are you a member? Login now

        • Login
        • Sign Up
        Forgot Password?
        Lost your password? Please enter your username or email address. You will receive a link to create a new password via email.