Excel 2008 Tutorials For Mac6/23/2021
Module 2 - EXCEL ESSENTIALS Lesson 6 - Introduction to Excel Tables Click here to download the example Excel file In this video of this Free Online Excel Training, youll learn how to use Excel tables.This page gives you access to a completely FREE Online Excel Training (26 video lessons with 12 hours of learning).You dont need to sign-up or do anything to get access to the course.Just scroll down and start watching the videos to learn Excel.
Excel 2008 Tutorials How To Use ExcelTo make the most of this free training, please go through these Excel training videos in the sequence in which they have been listed. NOTE: In case the video looks a bit blurry, you can change the video quality to 720p (by clicking on the settings gear icon on the bottom right of the video screen) In case youre an intermediate or advanced user, feel free to pick the lessons you want to watch. Also, in case you have any questions or any feedback for me, kindly leave it in the comments area (at the bottom of this page). In case you find the videos useful and would like to support me, you can buy me a coffee Modules Covered in this Free Excel Training MODULE 1 - EXCEL BASICS (for Beginners) Lesson 1 Getting Started with Excel This video is meant for Excel beginners. In this video, I will show you the different parts of Excel working area. In this video, youll learn about the following topics: Structure of the Excel working area, How to navigate in Excel, Ribbons and tabs, Quick Access Toolbar (QAT) Dialog Box Task Panes, Customizing ribbons and QAT, What is an active cell How to use ALT shortcuts Related Excel Articles: Creating Groups in Quick Access Toolbar Lesson 2 - Data Entry, Data Editing, and Number Formatting Once you know are comfortable with the layout of Excel, the next step is to learn how to enter and edit data in Excel. You can enter three types of data in Excel numeric, text, and formulas. To enter data in any cell, just select the cell and start typing. In case you are entering dates, enter it in a format that Excel recognizes as a date (such as 01-01-2020 or 01 Jan 2020 or 01012020). This video will show you how to enter data in Excel and edit already added data (such as deleting data, modifying existing data and replacing data). Apart from this, it also covers the auto-fill in Excel as well as number formatting. Related Excel Articles: Fill Numbers in Cells without dragging 10 Excel Data Entry Tips for Beginners Excel Data Entry Forms (Advanced) Custom Number formatting in Excel (Advanced) Lesson 3 - Data Formatting Click here to download the example Excel file This video covers the basics of data formatting in Excel. You can format data in Excel to make it look better and to highlight some data points. For example, if you have data-set and you want to highlight the negative numbers, you can simply highlight it in red color to it. Since a worksheet in Excel is made up for cells, if you want to become proficient in Excel, you need to know how to best work with cells and ranges. It covers the following topics: Cell address nomenclature Selecting cellranges in Excel Copying and moving cellsranges in Excel Using paste special Selecting special cells Using find and replace to select cells Adding comments and Using quick analysis Related Excel Articles: Find and Replace in Excel How to move Rows Columns in Excel Insert New Columns in Excel Excel AUTOFIT: Make RowsColumns Fit the Text Automatically Lesson 5 - Managing Worksheets Click here to download the example Excel file In this video of this Free Online Excel Training, youll learn how to manage worksheets in Excel. It covers the following topics: Navigating through worksheets in Excel Changing worksheet name and color Addingdeleting worksheets HidingUn-hiding worksheets Movingcopying worksheets Comparing worksheets side by side Splitting worksheet into panes Freeze panes Saving and opening workbooks Related Excel Articles: Freeze Panes in Excel Hide Worksheets in Excel In case youre looking for advanced Excel training, please check out my other Free Online Excel training. I currently have the following three courses: Dashboard Course, VBA course, Power Query Course.
0 Comments
Leave a Reply. |