microsoft excel in water operationsmicrosoft excel in water operations an overview of best practices...
TRANSCRIPT
![Page 1: MICROSOFT EXCEL IN WATER OPERATIONSMICROSOFT EXCEL IN WATER OPERATIONS An Overview of Best Practices This Photo by Unknown Author is licensed under CC BY-SA](https://reader033.vdocuments.us/reader033/viewer/2022041822/5e5ee7ddc33f09456d4169c2/html5/thumbnails/1.jpg)
MICROSOFT EXCEL IN WATER
OPERATIONS
An Overview of Best Practices
This Photo by Unknown Author is licensed under CC BY-SA
![Page 2: MICROSOFT EXCEL IN WATER OPERATIONSMICROSOFT EXCEL IN WATER OPERATIONS An Overview of Best Practices This Photo by Unknown Author is licensed under CC BY-SA](https://reader033.vdocuments.us/reader033/viewer/2022041822/5e5ee7ddc33f09456d4169c2/html5/thumbnails/2.jpg)
WOODGROVEBANK
INTRODUCTIONThe Role of Excel in the
Water Business
2
![Page 3: MICROSOFT EXCEL IN WATER OPERATIONSMICROSOFT EXCEL IN WATER OPERATIONS An Overview of Best Practices This Photo by Unknown Author is licensed under CC BY-SA](https://reader033.vdocuments.us/reader033/viewer/2022041822/5e5ee7ddc33f09456d4169c2/html5/thumbnails/3.jpg)
WOODGROVEBANK
WHY EXCEL?
3
![Page 4: MICROSOFT EXCEL IN WATER OPERATIONSMICROSOFT EXCEL IN WATER OPERATIONS An Overview of Best Practices This Photo by Unknown Author is licensed under CC BY-SA](https://reader033.vdocuments.us/reader033/viewer/2022041822/5e5ee7ddc33f09456d4169c2/html5/thumbnails/4.jpg)
WOODGROVEBANK4
Excel is a useful tool for:
•Math
•Money
•Records
![Page 5: MICROSOFT EXCEL IN WATER OPERATIONSMICROSOFT EXCEL IN WATER OPERATIONS An Overview of Best Practices This Photo by Unknown Author is licensed under CC BY-SA](https://reader033.vdocuments.us/reader033/viewer/2022041822/5e5ee7ddc33f09456d4169c2/html5/thumbnails/5.jpg)
WOODGROVEBANK
This is meant to be a student centered class
5
Our Big Hairy Audacious Goal is to make this the last Excel Class you ever take!
How will we do that?
• Start by discussing bare bones universal ideas
• Have a discussion to develop subject area goals to are relevant to everyone
• Spend the rest of the day working to meet those goals
Topics covered can be simple or complex depending on your interests
![Page 6: MICROSOFT EXCEL IN WATER OPERATIONSMICROSOFT EXCEL IN WATER OPERATIONS An Overview of Best Practices This Photo by Unknown Author is licensed under CC BY-SA](https://reader033.vdocuments.us/reader033/viewer/2022041822/5e5ee7ddc33f09456d4169c2/html5/thumbnails/6.jpg)
WOODGROVEBANK
WHY IS EXCEL
IMPORTANT
6
In 2019 effective data management is more important than ever.
Data is everywhere
Why Excel skills matter:
• Excel is ubiquitous, Microsoft Office is becoming a standard business application.
• Math is easy to mess up
• Easily arranges complex equations
• Excel is Repeatable!
• Excel makes it easy to show your work!
![Page 7: MICROSOFT EXCEL IN WATER OPERATIONSMICROSOFT EXCEL IN WATER OPERATIONS An Overview of Best Practices This Photo by Unknown Author is licensed under CC BY-SA](https://reader033.vdocuments.us/reader033/viewer/2022041822/5e5ee7ddc33f09456d4169c2/html5/thumbnails/7.jpg)
WOODGROVEBANK
WHAT MAKES
EFFECTIVE EXCEL?
7
• Structure balances simplicity and complexity required to be effective
• Uses Formatting to aid the desired task
• Utilizes Functions and Formulas to accomplish Tasks
• Data Elements are Separated
• Utilizing Hidden Fields, Locked Fields, Frozen Panes to more easily access data
• Users navigate easily using menus and keyboard shortcuts
![Page 8: MICROSOFT EXCEL IN WATER OPERATIONSMICROSOFT EXCEL IN WATER OPERATIONS An Overview of Best Practices This Photo by Unknown Author is licensed under CC BY-SA](https://reader033.vdocuments.us/reader033/viewer/2022041822/5e5ee7ddc33f09456d4169c2/html5/thumbnails/8.jpg)
WOODGROVEBANK
EXCEL POWER TOOLS
How to work smarter,
not harder in Excel.
8
![Page 9: MICROSOFT EXCEL IN WATER OPERATIONSMICROSOFT EXCEL IN WATER OPERATIONS An Overview of Best Practices This Photo by Unknown Author is licensed under CC BY-SA](https://reader033.vdocuments.us/reader033/viewer/2022041822/5e5ee7ddc33f09456d4169c2/html5/thumbnails/9.jpg)
WOODGROVEBANK
KEYBOARD SHORTCUTS
• Make Navigating and Formatting quicker and easier
• Are fairly universal across platforms
9
![Page 10: MICROSOFT EXCEL IN WATER OPERATIONSMICROSOFT EXCEL IN WATER OPERATIONS An Overview of Best Practices This Photo by Unknown Author is licensed under CC BY-SA](https://reader033.vdocuments.us/reader033/viewer/2022041822/5e5ee7ddc33f09456d4169c2/html5/thumbnails/10.jpg)
WOODGROVEBANK
DISSECTING WORKBOOKS
10
Observe the Data Structure
• What is this data for?
• What do Columns represent?
• What do Rows represent?
• Are Functions used?
• Are Lock Cells or Hidden Cells used?
Where is this data coming from?
What am I trying to do with it?
![Page 11: MICROSOFT EXCEL IN WATER OPERATIONSMICROSOFT EXCEL IN WATER OPERATIONS An Overview of Best Practices This Photo by Unknown Author is licensed under CC BY-SA](https://reader033.vdocuments.us/reader033/viewer/2022041822/5e5ee7ddc33f09456d4169c2/html5/thumbnails/11.jpg)
WOODGROVEBANK
IT IS OK TO FAKE IT TILL YOU MAKE IT!
11
![Page 12: MICROSOFT EXCEL IN WATER OPERATIONSMICROSOFT EXCEL IN WATER OPERATIONS An Overview of Best Practices This Photo by Unknown Author is licensed under CC BY-SA](https://reader033.vdocuments.us/reader033/viewer/2022041822/5e5ee7ddc33f09456d4169c2/html5/thumbnails/12.jpg)
WOODGROVEBANK
GOOD GOOGLING
• Be specific
• Try different ways of describing what you are looking for
• Pay Attention to the source of search results
• For general use trust Microsoft and Academic Sources
• For Business specific applications search out Utilities, Engineers etc.
12
![Page 13: MICROSOFT EXCEL IN WATER OPERATIONSMICROSOFT EXCEL IN WATER OPERATIONS An Overview of Best Practices This Photo by Unknown Author is licensed under CC BY-SA](https://reader033.vdocuments.us/reader033/viewer/2022041822/5e5ee7ddc33f09456d4169c2/html5/thumbnails/13.jpg)
WOODGROVEBANK
WHERE TO LEARN MORE?
13
Excel Specific SitesExceljet.net
Excelatworkbook.com
Online Courses• Coursera.com
• Lynda.com
• Udemy.com
![Page 14: MICROSOFT EXCEL IN WATER OPERATIONSMICROSOFT EXCEL IN WATER OPERATIONS An Overview of Best Practices This Photo by Unknown Author is licensed under CC BY-SA](https://reader033.vdocuments.us/reader033/viewer/2022041822/5e5ee7ddc33f09456d4169c2/html5/thumbnails/14.jpg)
THANK YOU
Kevin Wyckoff
Jason Van Gilder
Pacific Northwest Section AWWAWater Information Technology
Committee
Please let us know how we did. Use the link
below to evaluate this presentation.
https://forms.gle/FcW7KAvMuJEu3Cpn7