Everyday Excel Full Tutorial

Published: 01 January 1970
on channel: freeCodeAcademy
6,021
70

you will learn basic worksheet navigation, how to open and save Excel files, and all about worksheets and workbooks. You will learn the difference between cells, columns, and rows in Excel, as well as cell references. You will learn how to move around the worksheet effectively using shortcut key combinations, and you will learn how to edit the worksheet. You will also learn how to format cells, conditionally format cells, and how to change between number, text, date, currency, and other cell formatting options. There will be particular emphasis on relative vs. absolute cell addressing modes and you will learn how to name cells and cell ranges. You will be introduced to basic macro recording using VBA and you will learn how to set personal preferences in Excel. Week 1 will conclude with a required quiz and an on-computer, in-application assignment. When you successfully complete Assignment 1, you will be given a "completion code", which you can input into the Assignment 1 submission quiz to earn credit for the assignment. The Week 2 material will be released when you have successfully passed Quiz 1 and Assignment 1. Good luck!
#Excel#MicrosoftExcel#Excel2016#


On this page of the site you can watch the video online Everyday Excel Full Tutorial with a duration of online in good quality, which was uploaded by the user freeCodeAcademy 01 January 1970, share the link with friends and acquaintances, this video has already been watched 6,021 times on youtube and it was liked by 70 viewers. Enjoy your viewing!