Microsoft Excel 2016 Training for Beginners is designed for newbies and anyone wanting to become familiar with the user interface and perform basic day to day operations in a comfortable manner, with confidence.
This course covers the following topics:
The course materials includes exercises at the end of every lesson that will help you practice what you have learned in the topics and become more confident in performing them later in your workplace or at your home. Solutions are also provided in case you have trouble performing the activities.
If you want to build a good foundation to becoming a power user of Excel, this course will offer you all the skills you need to get started with the software.
An introduction to the topics that you will be learning in Microsoft Excel 2016 Training for Beginners.
Explore the Quick Access Toolbar and learn how to use and customize it to find the commands you frequently use in your day to day work quickly.
Explore the Ribbon and learn how to navigate the Ribbon and find all the commands you need to work in Excel.
Explore the commands in the Formula bar and learn how you can use it when performing calculations in Excel.
Explore the various options in the worksheet area and learn how to navigate between different parts of a worksheet.
Explore the various options and commands available in the Status bar so you can see at a glance information inside the worksheet on it.
You will learn how to create a workbook from scratch or create one using a template and save it in a location on your computer.
You will learn how to navigate within a worksheet and navigate when the workbook has multiple worksheets.
You will learn how to add more worksheets to a workbook and delete them when not necessary.
You will understand the rules for data entry and learn to enter different types of data in cells.
You will learn how to edit data in cells without losing the information that is already available in the worksheet.
You will learn how to use Excel's commands to undo and redo entries you created in your worksheet.
You will learn how to copy and paste data in Excel or move data from one location to another within a worksheet or within worksheets.
You will learn how to copy a range of cells in Excel using the Autofill feature.
You will learn how to insert new rows and columns in Excel and how to hide them when you want to take a print.
You will learn how to find and replace text quickly in a large worksheet using the Find and Replace dialog box.
You will learn how Excel uses the basic operators in Excel to perform addition, subtraction, multiplication and division functions.
You will learn the BODMAS rule and how Excel uses it to make computations.
You will learn different ways in which to sum up values in your worksheet.
You will earn how to apply the formulas you created to other cells.
You will learn how to change the font and font sizes; add font colors and background colors; and bold format, italicize and underline text.
You will learn how to align data in Excel to give it a uniform and neat appearance.
You will apply number formats in Excel to display the data according to your needs.
You will apply date formats to display dates in a short form, long form or custom format as per your requirements.
You will add different types of borders to your data to give it a neat appearance when printing.
You will use the Format Painter to copy and paste formatting styles in your worksheet.
You will find formatting styles in your worksheet quickly and instantly replace them with different styles.
You will clear multiple formatting styles applied to a worksheet so you can start from afresh.
You will format worksheets by adding a color to them.
You will copy and move worksheets within a workbook and between workbooks.
You will arrange workbooks in different styles so you can quickly switch between them when needed.
You will group worksheets so you can make changes to all of them simultaneously and ungroup them when required.
You will set up print titles and print areas for printing select data.
You can set the margins and orientation before printing a worksheet.
You can create headers and footers for printing in a worksheet.
You can set page breaks in a worksheet to optimize the space used in the printing paper.
You will select different ranges of cells for printing.
You will access all the options available for setting the print conditions or a worksheet or workbook.
A quick look at everything we learned so far in Microsoft Excel 2016 Training for Beginners.
I’m Adeline Gear, an instructional designer and blogger at TheAppTimes. I’ve spent many years creating Microsoft courses at ElementK and after I moved on I realized that there's no better way to impart education than through visual and activity based training.
I am glad to be a part of Udemy that offers an excellent opportunity for me to continue to provide such a rich learning experience for students.
I hope you will take up my courses to learn new skills and reach out to me with your questions and feedback.
Looking forward to hearing from you and wishing you all an exciting and engaging learning experience!