Booking options
£25
£25
On-Demand course
2 hours 33 minutes
All levels
ð Unlock the Power of Excel 2019! ð
Are you ready to master Microsoft Excel 2019 and elevate your skills to new heights? Introducing our comprehensive online course: 'Microsoft Excel 2019 - Beginner Level Training.'
ð Dive into Excel's World-Class Features ð
ð Section 1 - Excel Beginner Get started with a solid foundation. Learn the interface, navigation, and essential tools to kickstart your Excel journey.
ð Section 2 - Excel Fundamentals Discover the core functionalities of Excel 2019, from cells and formulas to tables and more. Lay the groundwork for proficient data manipulation.
ï¸ Section 3 - Entering and Editing Text Master the art of inputting and refining text within Excel. Gain efficiency and accuracy in handling textual data.
Section 4 - Basic Excel Functions Explore the fundamental functions that make Excel a powerhouse. From basic calculations to data analysis, unlock Excel's potential.
ð Section 5 - Modifying an Excel Worksheet Learn techniques to manage, organize, and customize worksheets effectively. Boost productivity and streamline your workflow.
ð¨ Section 6 - Formatting Data Transform raw data into visually appealing, easy-to-read formats. Elevate your reports and presentations with polished data formatting skills.
ð¼ï¸ Section 7 - Images, Shapes, and Smart Art Enhance your spreadsheets with visuals! Master the incorporation of images, shapes, and smart art for impactful data representation.
ð¨ï¸ Section 8 - Printing in Excel Navigate the intricacies of printing in Excel. Optimize layouts and settings to produce professional-looking documents.
ð Section 9 - Templates Harness the power of pre-designed templates. Learn how to utilize and customize templates for various Excel projects efficiently.
ð Section 10 - Excel Beginner - Conclusion Wrap up your journey with a comprehensive understanding of Excel's beginner level. Recap key takeaways and prepare to advance your skills further.
ð¥ Join Now and Excel in Excel 2019! ð¥
ð©âð» Whether you're a student, professional, or an Excel enthusiast, this course is your gateway to proficiency in Microsoft Excel 2019. Enroll today and unlock a world of possibilities with data manipulation, analysis, and presentation!
ð Don't miss this opportunity! Enroll now and empower yourself with Excel mastery! ð
Section 1 - Excel Beginner
Introduction
01:02
Section 2 - Excel Fundamentals
Launching Excel
01:59
Start Up Screen
02:54
The Excel Interface
06:46
The Quick Access Toolbar
02:13
The Ribbon
04:43
Creating New Excel Workbooks
01:27
Saving Excel Files
02:22
Opening Excel Files
01:38
Beginner Shortcut Keys
01:37
Section 3 - Entering and Editing Text
Entering Text
06:41
Working with Numbers
06:55
An Introduction to Dates
01:15
Find and Replace
04:10
Sorting Data
04:13
Working with Cell References
06:05
Relative Versus Absolute Cell Reference in Formulas
06:24
Understanding the Order of Operation
02:41
Section 4 - Basic Excel Functions
The structure of an Excel Function
00:00
Working with the Sum Function
00:00
Working with Min and Max
00:00
Working with Averages
00:00
Working with Count and CountA
00:00
Section 5 - Modifying an Excel Worksheet
Moving and Copying Data
00:00
Inserting and Deleting Rows and Columns
00:00
Changing the Width and Height of Cells
00:00
Hiding and Unhiding Rows, Columns and Sheets
00:00
Renaming Worksheets
00:00
Deleting Worksheets
00:00
Moving and Copying Worksheets
00:00
Section 6 - Formatting Data
Adding Borders to Cells
00:00
Formatting Percentages
00:00
Merging and Centering Cells
00:00
A Quick look at Styles
00:00
Basic Conditional Formatting
00:00
Section 7 - Images, Shapes and Smart Art
Inserting Images and Shapes
00:00
Working with SmartArt
00:00
Section 8 - Printing in Excel
Print Preview
00:00
Margins, Scaling and Orientation
00:00
Printing
00:00
Section 9 - Templates
Intro to Excel Templates
00:00
Opening an Existing Template
00:00
Creating a Custom Template
00:00
Section 10 - Excel Beginner - Conclusion
Conclusion
00:00
Compete High: Your