Formulas and Functions
Navigate to theFormulas and FunctionsTutorials using this linkhttps://edu.gcfglobal.org/en/excel/(Links to an external site.).Follow the directions next to each tutorial title. Remember, you may be quizzed on this material as well.The documents you submit should look like the documents shown at the end of each Challenge.
13. Intro to Formulas - Save the Challenge! Practice Document as YourUsername_Intro and attach to assignment. (10 points)
14. Creating More Complex Formulas- Review the tutorial.
15. Relative and Absolute Cell References - Review the tutorial.
16. Functions - Review the tutorial.
Free Excel Tutorial at GCFGlobal close search search menu Topics English expand_more expand_less Español Português Excel In this free Excel tutorial, learn how to create formulas and charts, use functions, format cells, and do more with your spreadsheets. Go to YouTube Playlist close I want to... Get started with computers Learn Microsoft Office Apply for a job Improve my work skills Design nice-looking docs More... Microsoft Office 2019 | 2016 | 2013 Word Excel PowerPoint Access Excel Formulas More... Basic Skills Computers Smartphones & Tablets Typing Tutorial Windows More... Internet Skills Internet Online Safety Social Media Email Search Better More... Google Gmail Google Docs Google Sheets More... Work & Career Career Planning Resume Writing Cover Letters Job Search and Networking Business Communication More... Skills for Today Adapting to Change 3D Printing Wearables Freelance Work Personal Finance Sharing Economy Decision-Making More... Creativity & Design Graphic Design Creativity Photography Image Editing Photoshop More... Core Skills Math Reading Grammar Language Learning More... For Educators Translations Staff Picks All Topics search menu All Topics My Account About Us FAQ Contact Us EN ES PT search 5c096a7d77c050035472858c Excel Basics 1 Getting Started with Excel arrow_forward_ios ✓ Learn your way around the Excel environment. 2 Understanding OneDrive arrow_forward_ios ✓ Learn all about working with your Microsoft account and OneDrive. 3 Creating and Opening Workbooks arrow_forward_ios ✓ Learn how to create and open Excel workbooks. 4 Saving and Sharing Workbooks arrow_forward_ios ✓ Learn how to save and share Excel workbooks. Working with Cells and Sheets 5 Cell Basics arrow_forward_ios ✓ Learn how to insert and delete cells and cell content, drag and drop cells, use the fill handle, and use the cut, copy, and paste functions. 6 Modifying Columns, Rows, and Cells arrow_forward_ios ✓ Learn how to modify rows, columns, and cells in Excel. 7 Formatting Cells arrow_forward_ios ✓ Learn all about formatting text in Excel. 8 Understanding Number Formats arrow_forward_ios ✓ Learn all about formatting numbers in Excel. 9 Working with Multiple Worksheets arrow_forward_ios ✓ Learn how to add, delete, copy, and move worksheets, as well as group and ungroup worksheets. 10 Using Find & Replace arrow_forward_ios ✓ Learn how to use Excel's Find and Replace features to search for specific data. 11 Checking Spelling arrow_forward_ios ✓ Learn how to use Excel's spell check feature. 12 Page Layout and Printing arrow_forward_ios ✓ Learn how to use Excel commands that let you control the way your content will appear on a printed page. Formulas and Functions 13 Intro to Formulas arrow_forward_ios ✓ Learn how to use cell references to create a simple formula in Excel. 14 Creating More Complex Formulas arrow_forward_ios ✓ Learn how to create a complex formula in Excel. 15 Relative and Absolute Cell References arrow_forward_ios ✓ Learn all about absolute and relative cell references and how they're used in Excel. 16 Functions arrow_forward_ios ✓ Learn the different parts of a function and how to create arguments to calculate values and cell references. Working with Data 17 Basic Tips for Working with Data arrow_forward_ios ✓ Learn these basic tips for working with data to help you organize it and find what you need. 18 Freezing Panes and View Options arrow_forward_ios ✓ Learn how to freeze panes and split your worksheet so you're only seeing certain parts of your worksheet. 19 Sorting Data arrow_forward_ios ✓ Learn how to sort data to better view and organize the contents of your spreadsheet. 20 Filtering Data arrow_forward_ios ✓ Learn how to filter the data in your worksheet to display only the information you need. 21 Groups and Subtotals arrow_forward_ios ✓ Learn how to organize data in groups, summarize different groups using the Subtotal command, and create an outline for your worksheet. 22 Tables arrow_forward_ios ✓ Learn how to use styles to format tables in Excel. 23 Charts arrow_forward_ios ✓ Learn how to insert and modify Excel charts to visualize comparisons in your data. 24 Conditional Formatting arrow_forward_ios ✓ Learn how to apply, modify, and delete conditional formatting rules in Excel. Doing More with Excel 25 Comments and Co-authoring arrow_forward_ios ✓ Learn how to use Excel's track changes and comments features when proofreading workbooks. 26 Inspecting and Protecting Workbooks arrow_forward_ios ✓ Learn how to inspect and protect your Excel workbook. 27 Intro to PivotTables arrow_forward_ios ✓ Learn how to use PivotTables in Excel for stronger data analysis. 28 Doing More with PivotTables arrow_forward_ios ✓ Learn how to do more with PivotTables to better summarize data. 29 What-if Analysis arrow_forward_ios ✓ Learn how to use what-if analysis to answer different types of questions. Extras 30 What is Office 365? arrow_forward_ios ✓ Learn what Office 365 has to offer in this free lesson. 31 New Features in Office 2019 arrow_forward_ios ✓ Discover some of the new features in Office 2019. 32 What are Reference Styles? arrow_forward_ios ✓ Learn all about using reference styles in Excel. 33 Office Intelligent Services arrow_forward_ios ✓ Learn more about the features available through Intelligent Services. 34 Using the Draw Tab arrow_forward_ios ✓ Learn how to use the features available on the Draw tab. 35 Working with Icons arrow_forward_ios ✓ Learn how to add and customize icons. Quiz 36 Excel Quiz arrow_forward_ios ✓ Test your knowledge of Excel by taking our quiz. keyboard_arrow_up keyboard_arrow_down About Us Who We Are Meet the Staff Who Uses Us + Our Partners Educators' Resources Teacher Guides Resources and Tools Help and Support FAQ Terms of Use Contact Us My Account ©1998-2020 Goodwill Community Foundation, Inc. All rights reserved. keyboard_arrow_up keyboard_arrow_down ©1998-2020 Goodwill Community Foundation, Inc. All rights reserved.