Excel Tips Rachael Wright & Dotti Davidson Excel Terms - PowerPoint PPT Presentation

Jun 11, 2023 •495 likes •594 views

Excel Tips Rachael Wright & Dotti Davidson Excel Terms Knowing the proper names of excel elements will help you: Find information on how to use the tools you need Avoid miscommunication Delegate excel based tasks effectively

Excel Tips Rachael Wright & Dotti Davidson
Excel Terms • Knowing the proper names of excel elements will help you: • Find information on how to use the tools you need • Avoid miscommunication • Delegate excel based tasks effectively
Where to Start • Open your workbook • Recent workbooks • Pinning a workbook • Name it and save it! • Prevention of data loss • Entering your data • Format before you start • How to enter data • Auto fill TIP: Ctrl + S = save
Working With Data • How to sort • Data manipulation • Text to columns • Remove duplicates • Filter • Hide TIP: ctrl + c = copy ctrl + v = paste
Charts • How to create a chart • Types of charts • Formatting charts TIP: F11 is the keystroke shortcut to put highlighted data into a chart
Formulas • How to manually build a formula • Start with an equals sign • Order of operations (Please Excuse My Dear Aunt Sally) • Auto fill • Absolute referencing • Functions in excel TIP: holding the ctrl key while selecting a data range allows you to select data that is non-sequential
Formatting • Column width • Row height • Merge & Center • Fill TIP: use pre-designed style templates
Resources • Fred Pryor Seminars • Unlocking the Secrets of Excel • YouTube • Microsoft Office Support • The Excel Bible by Dr. Stephen Covey

Download Presentation

Download Policy: The content available on the website is offered to you 'AS IS' for your personal information and use only. It cannot be commercialized, licensed, or distributed on other websites without prior consent from the author. To download a presentation, simply click this link. If you encounter any difficulties during the download process, it's possible that the publisher has removed the file from their server.

Recommend

Atlanta Area Compensation Association (AACA) October 11, 2016 Excel Tips and Dashboard Design

Atlanta Area Compensation Association (AACA) October 11, 2016 Excel Tips and Dashboard Design Techniques Eric Hurst, Culpepper and Associates R. Wayne Camp, CCCG, LLC 10/10/2016 1 Introduction Excel tips and an introduction to

221 views • 8 slides

Excel Tips for handling large spreadsheets of collections data Melissa Belvadi University of

Excel Tips for handling large spreadsheets of collections data Melissa Belvadi University of Prince Edward Island October 2017 Excel Spreadsheet Vocabulary and Limits Spreadsheet = Workbook = Book = Entire File Sheet = Tab =

585 views • 35 slides

5.2 Microsoft Excel Microsoft Excel Microsoft Excel is the spreadsheet component of the

5.2 Microsoft Excel Microsoft Excel Microsoft Excel is the spreadsheet component of the Microsoft Office Suite. It is used primarily to enter, edit, format, sort, perform mathematical computations, save, retrieve and print numeric

717 views • 32 slides

Session 9 Session 9 Tool Time Tuesday Tool Time Tuesday Discounts, Outlook and Excel Basics

Session 9 Session 9 Tool Time Tuesday Tool Time Tuesday Discounts, Outlook and Excel Basics Tips Discounts, Outlook and Excel Basics Tips Hello! Hello! Laurissa Gann, MSLS, AHIP Lesli Moore, MLS Research Medical Library Research Medical

775 views • 19 slides

Introduction to Excel and Visual Basic for Excel Gilbert Ritschard Department of economics,

Excel and Visual Basic for Excel Introduction to Excel and Visual Basic for Excel Gilbert Ritschard Department of economics, University of Geneva http://mephisto.unige.ch Master in International Trading, Commodity Finance and Shipping

690 views • 44 slides

Excel In Extreme Ways Integrating Excel into your development cycle Introduction Andres

Excel In Extreme Ways Integrating Excel into your development cycle Introduction Andres Fradkin Data Analyst F&S IT What is Extreme Excel to you? Why should we use Excel Everyone has it, and many people already feel

410 views • 24 slides

1.3 EXCEL to New Heights PACE April 2017 Chad Carter And Bonnie Chisholm Why should I use

1.3 EXCEL to New Heights PACE April 2017 Chad Carter And Bonnie Chisholm Why should I use EXCEL? Excel is a great resource for keeping lists of all kinds. Microsoft Excel is a program that provides worksheets comprised of rows and

539 views • 25 slides

Excel Tutorial 1 Getting Started with Excel Tutorial 2 Formatting a Workbook Tutorial 3

Excel Tutorial 1 Getting Started with Excel Tutorial 2 Formatting a Workbook Tutorial 3 Working with Formulas and Functions COMPREHENSIVE Excel Tutorial 1 Getting Started with Excel COMPREHENSIVE Objectives XP XP Understand

1.18k views • 81 slides

MS EXCEL Utilities THE EXCEL DEMOGRAPHIC Data Management and Building Reports My Boss Said

MS EXCEL Utilities THE EXCEL DEMOGRAPHIC Data Management and Building Reports My Boss Said So - He will I can type out only see my Balance reports in Sheet even The Excel though I Functions manually add are Just the numbers

390 views • 20 slides

How You Use Excel in Banking This Tutorial: A quick Excel tip that takes <10 minutes to

How You Use Excel in Banking This Tutorial: A quick Excel tip that takes <10 minutes to set up and will save you hours each week Its a follow-up to the previous tutorial on optimizing PowerPoint shortcuts, and the idea is the same

307 views • 12 slides

4845 US Hwy 271 North | Pittsburg, TX 75686 www.tips-usa.com 866-839-8477 tips@tips-usa.com

4845 US Hwy 271 North | Pittsburg, TX 75686 www.tips-usa.com 866-839-8477 tips@tips-usa.com December 18,2017 CCS Presentation Systems Ben Pickrel 20212 Hempstead Rd, Bldg 1 Houston, TX 77065 RE: TIPS Awarded Contract Audio Visual

42 views • 3 slides

Greece Central School District EXCEL II Reconstruction Projects OUTLINE | Greece CSD EXCEL II

9/11/2012 Greece Central School District EXCEL II Reconstruction Projects OUTLINE | Greece CSD EXCEL II 1. Greece CSD EXCEL II, Project Understanding 2. Greece CSD EXCEL II, Phase 1 : Scope 3. Greece CSD EXCEL II, Phase 2 : Scope 4. The

85 views • 4 slides

VXL XL Vince Excel Makes M3 Easy The Challenge The Solution Cloud enabled Excel as

VXL XL Vince Excel Makes M3 Easy The Challenge The Solution Cloud enabled Excel as User Interface Security from M3 API Technology Version independent VXL Technical Design M3 PPS101 Purchase Agreement. Open Lines Example PPS100

128 views • 11 slides

PV Excel Designer & Installer 2 Day solar PV Excel Course for Designers and Installers of

2/13/17 PV Excel Designer & Installer 2 Day solar PV Excel Course for Designers and Installers of PV systems Created by Carel Ballack www.pqrs.co.za q=`=a=^~=^~=

1.35k views • 116 slides

WorldStrides Excel ODP : Excel began working with state Olympic Development Programs in 1999

WorldStrides Excel ODP : Excel began working with state Olympic Development Programs in 1999 when we organized Marylands first international trip. Additional partners include: Eastern Pennsylvania, Missouri, Arizona, Arkansas,

277 views • 13 slides

Who is WorldStrides Excel? Founded in 1998, formerly Excel International Sports. Acquired

Who is WorldStrides Excel? Founded in 1998, formerly Excel International Sports. Acquired by WorldStrides in January 2015. Industry leader in organizing international travel for North American sports teams. Headquartered in

143 views • 12 slides

Poors Living Standards By Justina Banyt MOTIVATION BEHIND Poor people pay more than rich?

Critical review of the paper by Christian Broda, Ephraim Leibtag, and David E. Weinstein The Role of Prices in Measuring the Poors Living Standards By Justina Banyt MOTIVATION BEHIND Poor people pay more than rich? > location (Chung

447 views • 5 slides

Principles of Data Management (for Biologists) Dr Joe Thorley R.P.Bio. Poisson Consulting August

Principles of Data Management (for Biologists) Dr Joe Thorley R.P.Bio. Poisson Consulting August 14th, 2017 Introduction Biologists spends $1,000,000s of dollars collecting data with little regard for its management. Study Design Study

804 views • 21 slides

Michigan STRATEGY GROUP #2 Critical Access DATA M A MANA NAGEMENT NT AND ND A ANAL ALYSI

Michigan STRATEGY GROUP #2 Critical Access DATA M A MANA NAGEMENT NT AND ND A ANAL ALYSI SIS S Hospital Quality NOVEMBER 7, 7, 201 2019 Network AS A PREMIER SYSTEM OF QUALITY, THE MICHIGAN CRITICAL ACCESS HOSPITAL QUALITY NETWORK

497 views • 11 slides

The Safe and Drug-Free Schools and Communities Quality Data Management Project Thomas G.

The Safe and Drug-Free Schools and Communities Quality Data Management Project Thomas G. Blomberg, Principal Investigator Kathy G. Padgett, Director The Florida State University Center for Criminology and Public Policy Research 1 Project

515 views • 30 slides

Approaches to Probabilistic Model Learning for Mobile Manipulation Robots Jrgen Sturm

Approaches to Probabilistic Model Learning for Mobile Manipulation Robots Jrgen Sturm University of Freiburg (now at Technical University of Munich) PhD Supervisor: Wolfram Burgard Motivation What could flexible service robots do for us?

1.04k views • 79 slides

Op Open en Fo Fort rt Co Collins lins: : A framework for advancing transparency and

Op Open en Fo Fort rt Co Collins lins: : A framework for advancing transparency and solutions to complex problems Project Team: Patrick Niland, Telly Whitfield, Ph.D., Rebecca VanRegenmorter What is Open Data? Open data is data that

934 views • 34 slides

DATA REPORTING AND SHARING FOR THE 2030 AGENDA NATIONAL PLATFORM DEVINFO AND THE MDGS

DATA REPORTING AND SHARING FOR THE 2030 AGENDA NATIONAL PLATFORM DEVINFO AND THE MDGS Watershed moment Underlined challenges Left development community looking for whats next SIC-CC COMMUNITY .StatSuite SIS-CC

517 views • 9 slides

Scanning packs what to look for Implementing the EU Falsified Medicines Directive in the UK

Scanning packs what to look for Implementing the EU Falsified Medicines Directive in the UK FMD what the right packs look like FMD safety features what to look for 2D data matrix [printed on low-reflecting area] Anti-tampering

276 views • 14 slides