Course description
Microsoft developed Microsoft Excel to help organize data and perform financial analysis. However, did you ever need to analyze data or perform calculations within charts? The best way to achieve this work quickly is to use a spreadsheet within Microsoft Excel. This unique program consists of columns and rows, at the intersection of which are cells. A spreadsheet consists of thousands of cells, allowing you to store, retrieve, manipulate or analyze any kind of data or information. In this Microsoft Excel certification, whether you are a beginner or expert, you will uncover the hidden tools in Microsoft Excel. For example, as you gather data into the spreadsheet, you will discover that you require it to be contiguous, which is a prerequisite for analysis. This ability makes it possible to present this information in a table format, allowing efficient analysis. Another excellent feature of Excel is the database functions that you can use to perform calculations on a specific range of selected cells with the specified conditions. For instance, you will learn that the SUMIFS Function adds the cells specified by a given set of requirements or criteria.
In the next section of this Microsoft Excel tutorial you will study PivotTables, which allow you to extract essential data from a large detailed dataset. PivotTables are designed to include great features such as building reports, sorting, filtering, grouping, etc. As a modelling technology, a PivotTable allows you to create data models, establish relationships, and work out calculations. You may use conditional functions to perform these calculations if Excel contains a specific value. These conditional functions (IF Functions) make Excel return one value if the condition is true and another if the condition is false. It is even possible to combine the OR Function with the IF Function, in which case only one of the conditions has to be true to return the true value.
Finally, you will uncover another feature of particular importance in Microsoft Excel, the Visual Basic for Applications (VBA). VBA is worked out for automation and governs the relationship between Excel and other office programs (PowerPoint, Word, Outlook, etc.). As you work through this Microsoft Excel course, you will understand that VBA is a great, powerful tool and enables increased efficiency. Once you have come to grips with VBA, you will see how to integrate coding into Microsoft Excel. Another critical part of this course is finding an Excel-related job after learning. You will master how to create an Excel resume and start working as a freelancer. We will unveil top freelance websites so you can start on your career path. Personal branding and positioning yourself as an expert, particularly on social media, is vital. This course is specifically meant for students and working professionals keen to expand their knowledge because it blends practical work with theoretical training and enrolling in this course will take you from the basics to complete proficiency in Microsoft Excel.
Upcoming start dates
Training content
Starting with Excel
Description: This module introduces you to Microsoft Excel. It covers Excel as a powerful spreadsheet program, along with its interface. You will learn how to minimize the ribbon and customize the status bar, the ribbon and the quick access toolbar. You will be taught how to format date values in Excel and use formulas. Referencing will also be covered.
- Learning Outcomes
- Introduction to Excel
- Getting Started with Excel
- Worksheet and Customization
- Values, Referencing and Formulas
- Lesson Summary
Function Worksheet and Cell Formatting
Description: In this module, you will learn about Excel functions. We will cover statistical functions such as Min, Max, Average, and Sum. You will be taught how to insert and delete rows and columns. You will also be taught how to adjust the width and height of cells and protect the workbook. Finally, we will address cell formatting.
- Learning Outcomes
- Introduction to Excel Functions
- Adjusting Excel Worksheet
- Visually Pleasing Cell Formatting
- Lesson Summary
Images, Charts and Templates
Description: In this module, you will be taught how to insert images, customise icons or convert these icons into shapes. You will learn how to use charts, change their design and format their elements. We will cover Excel’s printing options. You will also learn about the benefits of using Excel templates and how to create them.
- Learning Outcomes
- Inserting Images and Shapes
- Visualizing Data with Charts
- Excel’s Printing Options
- Benefits of Using Excel Templates
- Lesson Summary
Excel Database
Description: In this module, you will learn how to sort data and prepare it for analysis. You will be taught multilevel and custom sorting. You will be introduced to Excel database functions and taught how to use these functions by specifying conditions or criteria. Excel data validation will be covered, along with the various types of data validation.
- Learning Outcomes
- Working with Excel Datasheet
- Excel Database Functions
- Excel Data Validation
- Lesson Summary
First Course Assessment
Description: This First Course Assessment enables you to review your learning so you can determine your knowledge and understanding of Module 1 to 4 of the following course, Diploma in Microsoft Excel for Beginners and Experts.
- Assessment: First Course Assessment
Specific Excel Functions
Description: This module covers specific Excel functions. Following the creation of Excel PivotTables, you will learn about Excel’s PowerPivot Add-In and how to activate it. In addition, learn to create relationships between data tables. You will also learn about Excel’s conditional functions, along with the COUNTIF Function and the LOOKUP Functions.
- Learning Outcomes
- Excel PivotTables
- Excel’s PowerPivot Add-In
- Excel’s Conditional Functions
- The Excel’s Lookup Functions
- Lesson Summary
Functions, Tools and Formula Auditing
Description: This module covers the text-based functions in Excel. You will be taught about the LEFT function, the RIGHT function and the MID function. You will learn about showing formulas, grouping data, and 3D referencing in formulas, along with utilizing the watch window and freezing panes. You will also be taught about Excel’s “What If?” Tools.
- Learning Outcomes
- Text Based Functions in Excel
- Auditing Formulas and Custom Views in Excel
- Excel’s “What If” Tools
- Lesson Summary
Microsoft Excel VBA
Description: This module covers Excel Visual Basic of Application (VBA). You will learn about the modules and procedures of the VBA language. You will be taught how to reference a range. You will also learn about InputBox and MsgBox. Looping is addressed and covers Excel VBA Loops, including “For Next Loop”, “Do Until Loop”, and “For Each Loop”.
- Learning Outcomes
- Welcome to Excel VBA
- The VBA language
- Writing VBA Code
- Important VBA Tools and Logic
- Excel VBA Loops
- Lesson Summary
Macros, UserForms and Careers in Excel
Description: This module will teach you how to assign macros to shapes, along with worksheet and workbook events. You will learn how to create Excel UserForms and add controls. You will also be taught how to start a career in Excel. You will discover how to create an Excel resume, personal branding, networking and freelancing.
- Learning Outcomes
- Triggering Macros
- Excel UserForms
- Starting a Career in Excel
- Lesson Summary
Second Course Assessment
Description: This Second Course Assessment enables you to review your learning so you can determine your knowledge and understanding of Module 5 to 8 of the following course, Diploma in Microsoft Excel for Beginners and Experts.
- Assessment: Second Course Assessment
Course assessment
- Assessment: Diploma in Microsoft Excel for Beginners and Experts - Final Course Assessment
Certification / Credits
By the end of this course, you will be able to:
- Explain how to get started with Microsoft Excel
- Discuss how to use Excel functions
- Describe how to create compelling graphics with SmartArt
- Recall the use of the Excel database functions
- Contrast the SUMIF function to the SUMIFS function
- Discuss conditional functions
- Recognize text-based functions in Excel
- Describe how to freeze panes in Excel
- List the main elements of VBA language
- Recall how to write VBA code
- Summarize the importance of networking and freelancing
Quick stats about Alison?
Providing Free Online Learning since 2007
Over 45 Million Learners across 193 Countries have studied with us
Over 5 Million people use the Alison Learning App, where you can study anywhere and anytime
Contact this provider
Alison Free Learning
Alison is the world’s largest free online empowerment platform for education and skills training, offering thousands of CPD-accredited courses and a range of impactful career development tools. It is a for-profit social enterprise dedicated to making it possible for anyone,...