Course Instructor
Duration
4 hours, 29 minutes
Last updated
February 11, 2023
5
Students
32
A basic level of Excel understanding is crucial for most office roles. Microsoft Excel's fundamental knowledge will enable you to identify trends and organise and sort data into meaningful categories.
PRIVATE
More about the course
You can also perform human resources functions, such as sorting worked hours and organising employee profiles and expenses, which help businesses better understand the structure and activities of their workforce. Excel is the preferred tool for business professionals to analyse and display data.
You will be able to do the following after completing this course:
- Navigate the interface, including creating and saving workbooks, quickly accessing commands, and selecting and entering data
- Insert and delete rows and columns
- Control how your worksheets print using Page Layout options, Page Breaks, and Headers and Footers
- Use multiple View features to compare multiple workbooks, compare worksheets, or save Custom Views.
- Perform calculations using formulas and functions
- Apply formatting to text, numbers, and cells, including Conditional Formatting, Comparative Analysis Formatting, Cell Styles, and Themes
- Manage multiple worksheets within a workbook, including adding, removing, renaming, reordering, copying, and colour-coding worksheets
- Customize your instance of Excel, including adding Groups to the Ribbon and modifying the Quick Access Toolbar.
Is this course for you?
Anyone who has never used Excel or re-entering the workforce with only a rudimentary understanding of the software can sharpen their basic skills from this excel course. A basic level of Excel understanding is crucial for most office roles. This includes office managers, personal assistants and secretaries. Microsoft Excel is essential for anyone involved in accounting, reporting and planning. This beginner's course is recommended for anyone using Excel at home or work for uncomplicated reasons, such as tracking simple expenditures or calculating sums or totals. Learning excel will help you understand what consists of individual cells can be used to build functions, formulas, tables, and graphs that easily organise and analyse large amounts of information and data. Anyone who wants to learn the most widely used software can explore this introductory excel course. Individuals or professionals like bankers, accountants, business analysts, marketing professionals, scientists, and entrepreneurs can build skills in using Excel consistently. You can enhance your practical knowledge with a complete overview of Excel's most common features and how to use them.Why Choose Mastering Excel 2019 - Basics course?
- Conducted by industry experts
- Get Instant E-certificate
- Fully online, interactive course with Professional voice-over
- Developed by qualified professionals
- Self-paced learning and laptop, tablet, smartphone-friendly
- Tutor Support
Certification
Industry Expert Instructor
Rated Excellent on Trustpilot
Course Content
-
- Introduction FREE 00:02:00
- Navigating the Interface. 00:09:00
- Selecting Data. 00:09:00
- Using Commands. 00:07:00
- Creating a New Workbook. 00:08:00
- Entering Cell Data. 00:08:00
- Using AutoFill. 00:07:00
- Using Flash Fill. 00:05:00
- using Excel Help. 00:02:00
-
- Creating Formulas. 00:08:00
- Inserting Functions. 00:08:00
- Copying Formulas and Functions. 00:07:00
- Using Absolute Reference 00:10:00
- Inserting and Deleting Cells.. 00:09:00
- Searching and Replacing. 00:08:00
- Using Proofing and Research Tools 00:07:00
- Printing Workbooks. 00:04:00
- Setting the Page Layout. 00:07:00
- Inserting page Breaks. 00:09:00
- Configuring Headers and Footers, Part 1. 00:05:00
- Configuring Headers and Footers, Part 2. 00:04:00
- Customizing General Options. 00:04:00
- Customizing the Ribbon. 00:07:00
- Customizing the Quick Access Toolbar. 00:07:00
- Get Your Certificate & Transcript 00:00:00