Buying for a team?Choose 5 or 10 licences to purchase access for multiple learners at a reduced per-person rate. After purchase, eBSI will contact you to confirm the learner details and arrange course access for each participant. Develop practical knowledge and confidence in Excel 365 Essentials. Welcome to the Office 365 Excel Essentials course. With Office 365, you can access your spreadsheets anywhere, and make some basic changes without using a computer where your desktop Office applications are installed. In the Office 365 Excel web app, you can collaborate on a spreadsheet with anyone, no matter what version of Excel they have, and your changes are automatically saved. Why this course matters This course turns the subject into practical, structured learning you can apply in real business and workplace situations. It is designed to help you move beyond definitions and understand how the ideas, tools and decisions covered in the course fit together. What you will gain Use the key features and workflows covered in Excel 365 Essentials with greater confidence. Apply the tools and techniques to practical business tasks. Recognise common mistakes and work more efficiently in day-to-day use. Who is this course for? This course is suitable for business users, administrators, managers and professionals who want to work more efficiently with everyday digital tools. Course at a glance Format: self-paced online learning. Professional development: CPD course. Welcome to the Office 365 Excel Essentials course. With Office 365, you can access your spreadsheets anywhere, and make some basic changes without using a computer where your desktop Office applications are installed. In the Office 365 Excel web app, you can collaborate on a spreadsheet with anyone, no matter what version of Excel they have, and your changes are automatically saved. The Office 365 experience is designed to render your documents to look exactly like they would when printed, from nearly anywhere in the world. This tool provides its users the freedom to work from anywhere. Completing this course will confer 2 CPD Credits towards internationally recognised Continuous Professional Development Requirements within organisations operating this kind of staff development methodology. Course Outline Module One: Getting Started Workshop Objectives Module Two: Welcome to Office 365 Excel The Home Page The Team Site Shared Documents Uploading a Spreadsheet Module Two: Review Questions Module Three: Worksheets and Workbooks Opening a Spreadsheet Overview of the Reading View Understanding Worksheets vs. Workbooks Downloading and Reloading Closing Spreadsheets Module Three: Review Questions Module Four: Working with Excel Files Using the Find Command Saving a Copy Editing in Browser The Excel Web App Interface Opening in Excel Module Four: Review Questions Module Five: Editing in the Browser (I) About Saving and Save As A New File and Autosaving Entering Data Editing Data Using the Wrap Command Module Five: Review Questions Module Six: Editing in the Browser (II) Using Undo and Redo Adding Rows and Columns Deleting Cells Using Timesaving Shortcuts Module Six: Review Questions Module Seven: Building Formulas The Math Basics of Excel Building a Formula Editing a Formula Copying a Formula Relative vs. Absolute References Module Seven: Review Questions Module Eight: Understanding Functions Formulas vs. Functions Using the SUM Function Using Other Basic Excel Functions Using AutoComplete Module Eight: Review Questions Module Nine: Working with Data Sorting Data Filtering Data About Collaborating About Refreshing External Data Module Nine: Review Questions Module Ten: Formatting Your Data Changing the Appearance of Text Changing the Appearance of Numbers Setting Alignment Options Adding Borders Adding Fill Color Module Ten: Review Questions Module Eleven: The Insert Tools Inserting Tables Inserting Charts Working with Charts Inserting Links Module Eleven: Review Questions Continue your learning Part of this learning pathway: Microsoft Office & Windows Learners also take: Excel 2013 Advanced | Excel 2013 Essentials | Excel 2013 Expert Course pathway: eBSI SME Academy > Microsoft Office & Windows > Excel 365 Essentials Explore more Microsoft Office & Windows training or return to the eBSI SME Academy.
Related
Related
Related
Related