Microsoft Excel Beginner Course - Introduction Excel
- 5 hours on-demand video
- 3 articles
- 4 downloadable resources
- Full lifetime access
- Access on mobile and TV
- Certificate of Completion
Get your team access to 4,000+ top Udemy courses anytime, anywhere.Try Udemy for Business
- After completion of this Microsoft Excel Beginner Course you will have mastered the above Excel concepts and will be able to complete the fundamental day to day tasks of an Excel worker.
- Also Two project based examples are provided in the course where you will be able to build and learn along, also practice files are provided so that you can practice every lecture along.
- Working With Microsoft Excel Fundamentals
- Excel Shortcut
- Working with Numeric Data in Excel
- The structure of an Excel Function SUM, AVERAGE, COUNT and More
- Using the AutoSum Command
- Changing the Width and Height of Cells
- Format Data in an Excel Worksheet
- Inserting Images and Shapes
- Creating Basic Charts in Excel
- How to Printing an Excel Worksheet
- Excel Templates
- Creating Templates
- Calculating Monthly Budget Project
- Student Performance Project
- And lot more
- You will need Excel loaded on your computer in order to follow along and complete the exercise files provided in each section.
- Videos have been recorded using Excel 2016, but Excel 2007, 2010 , 2013 or 2016 will work in order to follow along.
- No prior knowledge is required ill be teaching you from scratch.
Quickly Learn Excel Basics Get Working with Excel.
During this Microsoft Excel Beginner Course - Introduction Excel you will build a solid foundation on which you will be able to learn, grow more and be able build the rest of your Excel experience on. Enroll now and I'll guide you step-by-step, exercise files included, through the basics of working with the most powerful spreadsheet tool on the market. In very little time you will master the basics of Excel that'll provide a foundation for more advanced Excel techniques (Course: Microsoft Excel beginner Course - Introduction Excel, (Microsoft Excel Intermediate Course - More Excel, Microsoft Excel Advance Course - Master Excel and Microsoft Excel Expert Course - Expertise Excel (Up Next)).
Each section in this course will introduce you to a key foundational Excel concept that you will quickly master.
Understanding the Excel Interface and Document Structure
Entering and Working with Data in an Excel Worksheet
Working with Formulas and the most common Excel Functions
Formatting Your Excel Data to make it more Presentable
Creating and Working with Excel Charts to Visually Present Data
Preparing Your Excel Documents to be Printed
Connecting with cloud service.
Creating an Excel Template for Easy Reuse
At completion of this Microsoft Excel beginner Course - Introduction Excel you will have mastered the above Excel concepts and able to complete the fundamental day to day tasks of an Excel worker.
Each section also includes quiz to test the knowledge you will gain and exercise files for you to download and practice with. These are the same files that are used in the video lectures. So that you can work along while watching the video lectures.
So, what are you waiting for, enroll now and build a solid foundation within Microsoft Excel.
- Microsoft Excel Beginner Course was designed for those who are just starting out in Excel or for those that are looking to refresh their own skills and pick up some shortcuts Excel. This course is best for beginners.
This lecture tells you about the Structure of Excel Workbook and how you will be working on it.
This lecture provides you the guiding on how to create title of an excel document.
This is all about entering numeric data in an Excel Worksheet and what is the difference between a text data and a numeric data.
This lecture provides you information on how to create cell references. and what is a cell reference? How to Create or change a cell reference. A cell reference refers to a cell or a range of cells on a worksheet and can be used in a formula so that Microsoft Office Excel can find the values or data that you want that formula to calculate.
A relative reference in Excel is a cell address without the $ sign in the row and column coordinates, like A1. When a formula with relative cell references in copied to another cell, the reference changes based on a relative position of rows and columns. By default, all references in Excel are relative.
If you need to sum a column or row of numbers, let Excel do the math for you. Select a cell next to the numbers you want to sum, click AutoSum on the Home tab, press Enter, and you're done. When you click AutoSum, Excel automatically enters a formula (that uses the SUM function) to sum the numbers.
To choose and insert a SmartArt diagram, follow these steps: On the Insert tab, click the SmartArt button in the Illustrations group. The Choose aSmartArt Graphic dialog box appears. Select a category in the navigation pane on the left followed by the list's or diagram's thumbnail in the center section.