Microsoft Excel For Beginners From Cognition Training

Free Download Microsoft Excel For Beginners From Cognition Training
Published 1/2024
MP4 | Video: h264, 1920×1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 1.82 GB | Duration: 5h 58m
Excel Essentials: A Beginner’s Guide to Spreadsheets

What you’ll learn
Learn how to navigate Microsoft Excel
Add and edit data on worksheets
Learn how to work with and organise worksheets in your Excel workbook
Get confident by sorting and finding data, adding borders and customising your workbooks
Learn the essentials of basic formulas, becoming confident to start using them on your own workbooks
Add and edit charts to your workbooks, allowing you to represent your data in a meaningful way
Understand how to use the Print function, whether printing to paper or as a PDF
Requirements
You will need access to Excel to work through the exercises
Description
Get to grips with the basics of Microsoft Excel, using our online course, at your own pace. The modules are specifically designed for self-paced learning and will help you to soon start feeling confident and competent.There are 6 hours of videos, along with Excel workbooks to work through as you go through the videos, allowing you to practice and become confident and competent.The course is designed for:· Absolute Beginners· Those with basic knowledge who want to get the basics rightWhether you have been using Excel for some time but still feel you need guidance or are an absolute beginner with zero knowledge this course will get you using Excel in a basic competent way.You will learn all you need to get you up and running and able to use Excel in a meaningful way.Our online course is divided into bite-size modules, where you can watch videos, clearly explaining both the theory and practice to ensure you truly understand. You will be able to watch the videos as many times as you like during your course, and you will also have downloadable Excel documents to practice with and keep.All you need is a computer, some time, and a quiet space and we are confident you will get off the ground with Excel.
Overview
Section 1: Welcome to Microsoft Excel
Lecture 1 Overview
Lecture 2 What is Microsoft Excel?
Lecture 3 Why use Microsoft Excel?
Lecture 4 Versions of Excel
Lecture 5 Getting Started
Lecture 6 The Grand Tour
Lecture 7 Getting Help!
Lecture 8 Summary
Section 2: Adding and Entering Data
Lecture 9 Overview
Lecture 10 Entering Data
Lecture 11 Resizing and Merging Cells
Lecture 12 Using the Fill Series
Lecture 13 Editing Data
Lecture 14 Spellcheck
Lecture 15 Notes and Comments
Lecture 16 Summary
Section 3: Worksheets
Lecture 17 16 – Overview
Lecture 18 Adding and Moving Worksheets
Lecture 19 Renaming Worksheets
Lecture 20 Copying Worksheets
Lecture 21 Colouring Worksheets
Lecture 22 Hiding and Unhiding Worksheets
Lecture 23 Deleting Worksheets
Lecture 24 Summary
Section 4: Getting Confident
Lecture 25 Overview
Lecture 26 the Quick Access Toolbar
Lecture 27 Formatting your Worksheets
Lecture 28 Custom Styles
Lecture 29 Sorting Data
Lecture 30 Finding Data
Lecture 31 Dealing with Borders
Lecture 32 Using Format Painter
Lecture 33 Summary
Section 5: Get Going with Basic Formulas
Lecture 34 Overview
Lecture 35 Basic Formula Rules
Lecture 36 Simple Formulas
Lecture 37 Relative Formulas
Lecture 38 Function Commands
Lecture 39 Autosum
Lecture 40 Removing Formulas
Lecture 41 Summary
Section 6: Get Going with Charts
Lecture 42 Overview
Lecture 43 Types of Charts
Lecture 44 Inserting Charts
Lecture 45 The Chart Contextual Ribbons
Lecture 46 Editing Charts
Lecture 47 Moving Charts
Lecture 48 Pie Charts
Lecture 49 Changing Chart Types
Lecture 50 Summary
Section 7: Printing Your Worksheets to Paper or PDF
Lecture 51 Overview
Lecture 52 Different Views
Lecture 53 Printing Options
Lecture 54 Scaling Your Prints
Lecture 55 Print Selection
Lecture 56 Print Orientation
Lecture 57 Margins
Lecture 58 Print Tiles
Lecture 59 Summary
We start from the very beginning so no knowledge of Excel is required.

Homepage

https://www.udemy.com/course/microsoft-excel-for-beginners-from-cognition-training/