Tech & IT
Business
Coding & Developer
Finance & Accounting
Academics
Office Applications
Art & Design
Marketing
Health & Wellness
Sounds & Music
Lifestyle
Photography
This plan includes
- Limited free courses access
- Play & Pause Course Videos
- Video Recorded Lectures
- Learn on Mobile/PC/Tablet
- Quizzes and Real Projects
- Lifetime Course Certificate
- Email & Chat Support
This plan includes
- Access to 11,000+ Courses
- Ads free experience Courses
- Play & Pause Course Videos
HD Video Recorded Lectures- Learn on Mobile/PC/Tablet
- Quizzes and Real Projects
- Lifetime Course Certificate
- Instructor Direct Support
- Email & Chat Support
- Cancel Anytime
What you'll learn?
- when and where to double-click or right-click with your mouse to uncover hidden functionality,
- how to restore the classic print preview screen in Excel 2010 and later,
- how to have Excel read numbers aloud to you
- locking and unlocking worksheet cells, as well as alternatives that are more efficient
- bypass filter drop-down lists by filtering based on cell contents with a single keystroke or mouse click
- eliminate duplicates from a list with just a few mouse clicks
Course Overview
MASTERING SPREADSHEET SHORTCUTS IN MS EXCEL FOR ACCOUNTING PROFESSIONALS
Are you working Excel or is it working you? Many users end up working harder than necessary in Excel carrying out repetitive tasks in an inefficient manner. In online course focuses on helpful shortcuts that can be used in all versions of Excel. The online course also covers many Excel keyboard shortcuts and even shows you how to create your own custom keyboard shortcuts.
Course Content:
-
when and where to double-click or right-click with your mouse to uncover hidden functionality,
-
how to restore the classic print preview screen in Excel 2010 and later,
-
an alternative to the merged cells feature, and
-
how to have Excel read numbers aloud to you
-
locking and unlocking worksheet cells, as well as alternatives that are more efficient
-
materials cover Excel 2016, 2013, 2010, and 2007.
-
add the hidden Form Command back to Excel 2007 and later
-
converting Excel 2003 files to modern workbook formats with ease.
-
creating a keyboard shortcut for Excel Freeze Panes feature
-
saving workbooks as .XLS files by dispatching the Compatibility Checker
-
bypass filter drop-down lists by filtering based on cell contents with a single keystroke or mouse click
-
convert .XLS workbooks to the up-to-date .XLSX format with just two keystrokes
-
discover how to quickly access folders and workbooks, regardless of whether they are stored on your computer or on a network
-
discover techniques that automatically provide fallback positions in the event you need to see an earlier version of your spreadsheet
-
double-check manual inputs easily by having Excel read numbers aloud to you
-
eliminate duplicates from a list with just a few mouse clicks
-
keep an eye on how much your text is being reduced as you try to squeeze more on a page
-
learn how the Table feature allows you to transform filtering tasks
-
navigate large workbooks with ease by way of a hidden menu as well as keyboard shortcuts
-
restore classic Print Preview functionality in Excel 2007 and later
-
simplify repetitive tasks by creating your own keyboard shortcuts
-
wrangle long lists of data by filtering instead of sorting
Pre-requisites
- No experience needed
Target Audience
- Practitioners will benefit from learning shortcuts that will enable them to use Microsoft Excel and Word more effectively and efficiently.
Curriculum 22 Lectures
Section 1 : Mastering spreadsheet shortcuts in MS Excel Course - Part 1
Section 2 : Mastering spreadsheet shortcuts in MS Excel Course - Part 2
- Lecture 1 :
- Part 2.1
- Lecture 2 :
- Part 2.2
- Lecture 3 :
- Part 2.3
- Lecture 4 :
- Part 2.4
Section 3 : Mastering spreadsheet shortcuts in MS Excel Course - Part 3
- Lecture 1 :
- Part 3.1
- Lecture 2 :
- Part 3.2
- Lecture 3 :
- Part 3.3
- Lecture 4 :
- Part 3.4
Section 4 : Mastering spreadsheet shortcuts in MS Excel Course - Part 4
- Lecture 1 :
- Part 4.1
- Lecture 2 :
- Part 4.2
- Lecture 3 :
- Part 4.3
- Lecture 4 :
- Part 4.4
Section 5 : Section 4: Mastering spreadsheet shortcuts in MS Excel Course - Part 5
- Lecture 1 :
- Part 5.1
- Lecture 2 :
- Part 5.2
- Lecture 3 :
- Part 5.3
- Lecture 4 :
- Part 5.4
- Lecture 5 :
- Part 5.5
- Lecture 6 :
- Part 5.6
Our learners work at
Frequently Asked Questions
How do i access the course after purchase?
It's simple. When you sign up, you'll immediately have unlimited viewing of thousands of expert courses, paths to guide your learning, tools to measure your skills and hands-on resources like exercise files. There’s no limit on what you can learn and you can cancel at any time.Are these video based online self-learning courses?
Yes. All of the courses comes with online video based lectures created by certified instructors. Instructors have crafted these courses with a blend of high quality interactive videos, lectures, quizzes & real world projects to give you an indepth knowledge about the topic.Can i play & pause the course as per my convenience?
Yes absolutely & thats one of the advantage of self-paced courses. You can anytime pause or resume the course & come back & forth from one lecture to another lecture, play the videos mulitple times & so on.How do i contact the instructor for any doubts or questions?
Most of these courses have general questions & answers already covered within the course lectures. However, if you need any further help from the instructor, you can use the inbuilt Chat with Instructor option to send a message to an instructor & they will reply you within 24 hours. You can ask as many questions as you want.Do i need a pc to access the course or can i do it on mobile & tablet as well?
Brilliant question? Isn't it? You can access the courses on any device like PC, Mobile, Tablet & even on a smart tv. For mobile & a tablet you can download the Learnfly android or an iOS app. If mobile app is not available in your country, you can access the course directly by visting our website, its fully mobile friendly.Do i get any certificate for the courses?
Yes. Once you complete any course on our platform along with provided assessments by the instructor, you will be eligble to get certificate of course completion.For how long can i access my course on the platform?
You require an active subscription to access courses on our platform. If your subscription is active, you can access any course on our platform with no restrictions.Is there any free trial?
Currently, we do not offer any free trial.Can i cancel anytime?
Yes, you can cancel your subscription at any time. Your subscription will auto-renew until you cancel, but why would you want to?
.jpg?crop=smart&width=600&height=400)
